CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 19

4NF.
BCNF.
8. (TCO 4) In Oracle, the DEFAULT constraint is used to
____________________. (Points : 4)
define which column is the default primary key if one is not
explicitly named
define which column is the default foreign key if on is not
explicitly named
assign a value to an attribute when a new row is added and a
value is not defined
validate data when a value is added to an attribute
Page 2 - Multiple Choice
1. (TCO 4) Which of the following is not considered a
database object? (Points : 4)
a table
a view
a constraint
a sequence
an index
2. (TCO 4) Which of the following SQL statements would
you use to create a table named DEVRY? (Points : 4)