Discussion
Home ‣ Database ‣ Distributed Databases See What Others Are Saying!
- Question
Some of the columns of a relation are at different sites is which of the following?
Options- A. Data Replication
- B. Horizontal Partitioning
- C. Vertical Partitioning
- D. Horizontal and Vertical Partitioning
- Correct Answer
- Vertical Partitioning
- 1. A proxy server is used for which of the following?
Options- A. To provide security against unauthorized users
- B. To process client requests for Web pages
- C. To process client requests for database access
- D. To provide TCP/IP Discuss
- 2. A DBMS that combines a DBMS and an application generator is ________ .
Options- A. Microsoft's SQL Server
- B. Microsoft's Access
- C. IBM's DB2
- D. Oracle Corporation's Oracle Discuss
- 3. In OLE DB, a tabular data provider:
Options- A. does not own data.
- B. transforms data through ODE DB interfaces.
- C. is both a consumer and a provider of data.
- D. exposes data via rowsets. Discuss
- 4. A regular subquery can be processed:
Options- A. from the top down.
- B. from the bottom up.
- C. by nesting.
- D. None of the above is correct. Discuss
- 5. Which of the following situation requires the use of ID-dependent entities?
Options- A. Association relationships only
- B. Multivalued attributes only
- C. Archetype/instance relationships only
- D. All of the above use ID dependent entities Discuss
- 6. What is not an advantage of stored procedures?
Options- A. Greater security
- B. SQL can be optimized
- C. Code sharing
- D. Increased network traffic Discuss
- 7. The SQL statement that queries or reads data from a table is ________ .
Options- A. SELECT
- B. READ
- C. QUERY
- D. None of the above is correct. Discuss
- 8. A foreign key is which of the following?
Options- A. Any attribute
- B. The same thing as a primary key
- C. An attribute that serves as the primary key of another relation
- D. An attribute that serves no purpose Discuss
- 9. Most operational databases can be used for many BI applications.
Options- A. True
- B. False Discuss
- 10. Given the functional dependency R ? (S,T) , then it is also true that R ? S.
Options- A. True
- B. False Discuss
More questions
Correct Answer: To provide security against unauthorized users
Correct Answer: Microsoft's Access
Correct Answer: exposes data via rowsets.
Correct Answer: from the bottom up.
Correct Answer: All of the above use ID dependent entities
Correct Answer: Increased network traffic
Correct Answer: SELECT
Correct Answer: An attribute that serves as the primary key of another relation
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.