1. Which of the following is true about De-normalization?
A. De-normalization is often the opposite way of normalization.
B. De-normalizing BCNF leads to poor performance.
C. After De-normalizing 4th normal form, the remaining problem with multi-valued field is solved by collection arrays.
D. None of above is true
Answer: A

2. When does the De-normalization trick of copying field between tables is applied?
A. If there are active and inactive data.
B. If the tables are not directly related to each other.
C. If hot block problem appears
D. None of above.
Answer: B

3. Which of the following is true?
A. An abstract class is a class inhering every thing from parent class, allowing local overriding changes.
B. A specialized class is a class inhering every thing from parent class, allowing local overriding changes.
C. A method is equivalent to a relational database stored procedure; it executes on the data contents of all other objects.
D. All of above is true
Answer: D

4. We can use cluster to
A. Separate active fields
B. To copy fields between to tables
C. To make summery fields in parent table
D. We do no use cluster for De-normalization
Answer: B

5. De-normalization is not opposite of normalization
A. True
B. False
Answer: B

6. The new tables are linked together with a master – detail also create foreign keys on the both tables in first normal form that’s
A. True
B. False
Answer: B

7. In 3rd normal form eliminate _________dependencies.
A. Transitive
B. Intransitive
Answer: A

8. How many parts of object model?
A. Four
B. Three
C. Five
D. Two
Answer: A

9. Materialized views are allowed in many _________ relational database.
A. large
B. Small
C. Medium
D. None
Answer: A

10. A class is the equivalent of a _________in a relational database.
A. Table
B. Column
C. Row
D. None
Answer: A

11. Data warehouse database model is known as the dimensional model or fact dimensional model.
A. True
B. False
Answer: A
12. Subset data warehouse known as data mart is
A. True
B. False
Answer: A

13. Typically , temporary tables perform intermediary functions, helping to eliminate duplication or processing and reducing repetitive I/O activities
A. True
B. False
Answer: A

14. The relational model breaks data into mathematically precise, detailed structures
A. True
B. False
Answer: A