CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 7

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)
create only referential constraints
define and name any constraint
create a short cut so the constraint does not have to be
named
create only entity entegrity constraints
2. (TCO 4) The SQL command that lets you list the table
contents is (Points : 4)