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

BCNF.
7. (TCO 3) A table that has all key attributes defined, has no repeating groups, and all its
attributes are dependent on the primary key, is said to be in_____________.(Points : 4)
1NF.
2NF.
3NF.
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)
CREATE Devry