Database Redesign – True or False
1. A correlated subquery is processed as a nested subquery. A. True B. False 2. A regular subquery…
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 – True or False
1. A foreign key is used to implement relationships between tables. A. True B. False 2. The terms…
Database Design Using Normalization – True or False
1. When building a database from an existing set of tables, we may safely assume that referential integrity…
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 – True or False
1. The condition in a WHERE clause can refer to only one value. A. True B. False 2.…
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 – True or False
1. With failure transparency, all of the actions of a transaction are committed or none of them are…