Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
The CustomerID field in a customer table can not be left blank. This is an example of:
A)domain integrity
B)logical integrity
C)referential integrity
D)physical integrity
E)none of the above
2
A table containing records that describe business events is:
A)transaction file
B)document file
C)master file
D)audit file
E)archival file
3
A language used by a DBMS to define a database or a view of a database is:
A)DML
B)DLL
C)DCL
D)DDL
E)none of the above
4
Many relational DBMSs can automatically enforce Delete:Cascade rule of referential integrity using
A)triggers
B)stored procedures
C)views
D)DCL
E)DDL
5
To delete an existing record from a database, you would use:
A)DCL
B)DDL
C)DML
D)DLL
E)none of the above
6
Which of the following is(are) criteria for producing a quality data model?
A)a good data model is complex
B)a good data model is flexible
C)a good data model is redundant
D)a good data model is adaptable to future needs
E)both (b) and (d)
7
Which of the following is(are) goals of database design?
A)a DB should be reliable
B)a DB should be scalable
C)a DB should support the business requirements of the information system
D)a DB should provide for efficient storage
E)all of the above
8
Which form of distribution is the simplest and the easiest to maintain?
A)vertical distribution
B)centralization
C)replication
D)horizontal distribution
E)hierarchical distribution
9
If two records in a student table would have the same value for StudentID, this would violate:
A)key integrity
B)referential integrity
C)table integrity
D)physical integrity
E)field integrity
10
Which of the following is NOT a valid deletion rule?
A)Delete:Restrict
B)Delete:Default
C)Delete:Cascade
D)Delete:Set Null
E)none of the above





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Whitten SAD 7eOnline Learning Center

Home > Chapter 14 > Multiple Choice Quiz