Database Redesign – General Questions
1. Which of the following SQL statements are helpful in database redesign? A. Correlated subqueries only B. EXISTS/NOT…
Data Models into Database Designs – General Questions
1. Which of the following data constraints would be used to specify that the value of cells in…
Database Design Using Normalization – General Questions
1. Needing to using more complicated SQL in database applications is a(n) ________ of normalization. A. advantage B.…
Introduction to SQL – General Questions
1. You can add a row using SQL in a database with which of the following? A. ADD…
Object-Oriented Database – True or False
1. ODL supports the abstract keyword for classes and operations. A. True B. False 2. The ODMG Object…
Object-Oriented Database – General Questions
1. ODL supports which of the following types of association relationships? A. Unary B. Unary and Binary C.…
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 – General Questions
1. Which of the following statements is true about symmetric multiprocessing? A. A single copy of the operating…
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 – General Questions
1. Data scrubbing is which of the following? A. A process to reject data from the data warehouse…