Distributed Databases – True or False
1. With failure transparency, all of the actions of a transaction are committed or none of them are…
Distributed Databases – General Questions
1. A distributed database has which of the following advantages over a centralized database? A. Software cost B.…
The Client-Server Database – True or False
1. Activities of a DBMS occur in the processing component logic. A. True B. False 2. The presentation…
The Client-Server Database – General Questions
1. Which of the following statements is true about symmetric multiprocessing? A. A single copy of the operating…
Physical Database Design – True or False
1. Two basic constructs to link one piece of data with another piece of data: sequential storage and…
Physical Database Design – General Questions
1. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true? A.…
Data Warehousing – True or False
1. A data mart is designed to optimize the performance for well-defined and predicable uses. A. True B.…
Data Warehousing – General Questions
1. Data scrubbing is which of the following? A. A process to reject data from the data warehouse…
ER Model and Business Rules – True or False
1. Packaged data models are meant to be exactly right straight out of the box. A. True B.…
ER Model and Business Rules – General Questions
1. An action assertion must include which of the following? A. Anchor object B. Action C. Corresponding object…