Discussion
Home ‣ Database ‣ Distributed Databases See What Others Are Saying!
- Question
A homogenous distributed database is which of the following?
Options- A. The same DBMS is used at each location and data are not distributed across all nodes.
- B. The same DBMS is used at each location and data are distributed across all nodes.
- C. A different DBMS is used at each location and data are not distributed across all nodes.
- D. A different DBMS is used at each location and data are distributed across all nodes.
- Correct Answer
- The same DBMS is used at each location and data are distributed across all nodes.
- 1. When mapping a supertype/subtype relationship which of the following is true?
Options- A. The supertype primary key is assigned to each subtype.
- B. The subtype primary key is assigned to each supertype.
- C. There is no link between the supertype/subtype entities.
- D. There is no primary key/foreign key relationship between a supertype/subtype. Discuss
- 2. A subtype entity is a special case of another entity called a supertype entity.
Options- A. True
- B. False Discuss
- 3. A correlated subquery is where the outer query depends on data from the inner query.
Options- A. True
- B. False Discuss
- 4. If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options- A. 1NF.
- B. 2NF.
- C. 3NF.
- D. BCNF. Discuss
- 5. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Options- A. Has ordered recently, orders frequently, and places a large order when she orders.
- B. Hasn't ordered recently, orders infrequently, but places a large order when she orders.
- C. Has ordered recently, orders frequently, but doesn't place a large order when she orders
- D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders. Discuss
- 6. A supertype/subtype hierarchy has which of the following features?
Options- A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- B. Attributes are assigned at the highest logical level.
- C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- D. Attributes are assigned at the lowest logical level. Discuss
- 7. CASE tools do not include which of the following features?
Options- A. Help to draw data models
- B. Help to generate code
- C. Help to manage people
- D. Create an information repository Discuss
- 8. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Options- A. True
- B. False Discuss
- 9. When an entity instance must be a member of only one subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
- 10. A database application can perform which of the following activities?
Options- A. Add records
- B. Read records
- C. Update records
- D. All of the above. Discuss
More questions
Correct Answer: The supertype primary key is assigned to each subtype.
Correct Answer: True
Correct Answer: False
Correct Answer: BCNF.
Correct Answer: Has ordered recently, orders frequently, but doesn't place a large order when she orders
Correct Answer: Attributes are assigned at the highest logical level.
Correct Answer: Help to manage people
Correct Answer: True
Correct Answer: Disjoint with total specialization
Correct Answer: All of the above.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.