SQL Server 2000 – General Questions
1. With which type of SQL Server recovery model are all database changes logged except those that cause…
Managing Multiuser Databases – True or False
1. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when…
Managing Multiuser Databases – General Questions
1. Locks placed by command are called ________ . A. implicit locks B. explicit locks C. exclusive locks…
SQL for Database Construction – True or False
1. The SQL statement used to create a view is CREATE VIEW. A. True B. False 2. The…
SQL for Database Construction – General Questions
1. The SQL command to create a table is: A. MAKE TABLE. B. ALTER TABLE. C. DEFINE TABLE.…
Data Modeling with ER Model – True or False
1. An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the…
Data Modeling with ER Model – General Questions
1. Which of the following indicates the maximum number of entities that can be involved in a relationship?…
The Relational Model and Normalization – True or False
1. In a relation, the order of the rows matters. A. True B. False 2. In a relation,…
The Relational Model and Normalization – General Questions
1. Every time attribute A appears, it is matched with the same value of attribute B, but not…
Introduction to Database – True or False
1. The relational database model was created by E.F. Codd. A. True B. False 2. A database is…