CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 7

time-variant data
design trap
fan trap
6. (TCO 3) All of the following are true about a prime attribute except_____________.
(Points : 4)
it is a key attribute
it is at least part of a key
it is not a key attribute
it may be part of a composite key
7. (TCO 3) The conflicts between design efficiency, information requirements, and
processing speed are often resolved through_____________. (Points : 4)
conversion from 1NF to 2NF
conversion from 2NF to 3NF
compromises that include denormalization
conversion from 3NF to 4NF
8. (TCO 4) When a constraint is created at the ______ level with the CREATE TABLE
command, the constraint definition is simply included as part of the column
definition.(Points : 4)
table
column
database
row
Page 2 - Multiple Choice
1. (TCO 4) In Oracle, the CONSTRAINT clause is used to ___________________.
(Points : 4)