CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary 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