CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 17
3NF. 4NF. 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
3NF. 4NF. 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