Distributed Databases – True or False
1. With failure transparency, all of the actions of a transaction are committed or none of them are…
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…
Physical Database Design – True or False
1. Two basic constructs to link one piece of data with another piece of data: sequential storage and…
Data Warehousing – True or False
1. A data mart is designed to optimize the performance for well-defined and predicable uses. A. True B.…
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.…
The Database Development Process – True or False
1. There is one physical schema for each logical schema. A. True B. False 2. The most important…
SQL Server 2000 – True or False
1. There is only one way to create and modify tables in SQL Server. Write SQL code using…
Managing Multiuser Databases – True or False
1. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when…
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…
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…