Database Design Final
Multiple Choice
Identify the choice that best completes the statement or answers the question.
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum )
____1.Based on the code above, for each sales rep, list the rep number, the number of customers assigned to the rep, and the average balance of the rep’s customers. Group the records by rep number and order the records by rep number. REF: 96
Part (PartNum, Description, OnHand, Class, Warehouse, Price )
____2.Based on the code above, list the descriptions of all parts that are located in Warehouse 3 and for which there are more than 20 units on hand. REF: 82
____3.To create the primary key clause for the Customer table on the CustomerNum field, the correct statement is ____. REF: 131
____4.The SQL command for deleting the Warehouse field from the Part table is ____. REF:138
____5.A(n) ____ is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command. REF: 143
____6.The catalog is maintained by ____. REF:231
____7.In order to accomplish serial processing of updates, many DBMSs use ____. REF:237
____8.If two or more users are waiting for the other user to release a lock before they can proceed, this is known as a ____. REF: 240
____9.____ a database reverses encryption. REF:246
____10.A string of characters assigned by the DBA to a database that the user must enter to access the database is known as a database ____. REF: 246
____11.____ rules specify which users have what type of access to which data in the database. REF:247
____12.The DBA usually creates groups of users called ____. REF:247
____13.____ refers to the right of individuals to have certain information about them kept confidential. REF:247
____14.____ integrity implies that the value entered for any field should be consistent with the data type for that field. REF: 248
____15.A ____ is a place where a record of certain corporate data is kept. REF:263
____16.After the DBMS is purchased, the ____ has primary responsibility for installation and maintenance. REF:268
____17.The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary. REF:268
____18.The ____ is responsible for providing training in the use of the DBMS. REF:268
____19.In order to develop new programs, the programmers need access to the information in the DBMS. They are given access to the ____. REF: 269
____20.The formula for message transmission time is: communication time = access delay + (data volume / X), where X represents ____. REF: 278
____21.A DDBMS that has at least two sites at which the local DBMSs are different is known as a ____. REF:279
____22.When users are unaware of the steps taken by the DDBMS to update the various copies of data, this characteristic of the DDBMS is called ____. REF: 279
____23.Which of the following is an advantage of distributed databases? REF:281
____24.It is possible for local DBMSs to commit updates at some sites and undo updates at other sites. This inconsistency can be prevented by using a ____. REF: 283-284
____25.The site that initiates the update in a two-phase commit is known as the ____. REF:284
____26.____ implies that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database. REF: 285
____27.____ is a metalanguage derived from a restricted subset of SGML, and designed for the exchange of data on the Web. REF: 292
____28.When users interact with an RDBMS, they use transactions. These types of systems are called ____ systems. REF: 295
____29.When the data is organized by entity rather than by the application that uses the data, it is called ____. REF: 296
____30.With respect to the definition of data warehouse, ____ means that data in a data warehouse represents snapshots of data at various points in time in the past. REF: 296