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…
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?…