In a 1:1 relationship, the primary key placement is arbitrary. True False TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Four Two Three Six TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following columns is(are) are required in a table? An alternate key A foreign key A primary key A surrogate key TRUE ANSWER : ? YOUR ANSWER : ?
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. True False TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, there are six possible sets of minimum cardinalities. False True TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key is used to implement relationships between tables. False True TRUE ANSWER : ? YOUR ANSWER : ?
An ideal primary key is short, numeric and seldom changing. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? An interrelation constraint An intrarelation constraint A domain constraint A range constraint TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, how many possible sets of minimum cardinalities are there? Six Two Four Three TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? Null status Default value Data constraints Data type TRUE ANSWER : ? YOUR ANSWER : ?