When the parent entity is required, a new child row can always be inserted. True False TRUE ANSWER : ? YOUR ANSWER : ?
A primary key should be defined as: None of these Either of the above can be used. NOT NULL. NULL. TRUE ANSWER : ? YOUR ANSWER : ?
An intersection table is required to represent M:N relationships. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row? Data type Null status Default value Data constraints TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key is: used to define null status. All of these used to define data types. a column containing the primary key of another table. TRUE ANSWER : ? YOUR ANSWER : ?
An ideal primary key is short, numeric and seldom changing. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Null status Default value Data constraints Data type TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, how many possible sets of minimum cardinalities are there? Six Two Three Four TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the foreign key is placed in: the parent table. the child table. either table without specifying parent and child tables. either the parent table or the child table. TRUE ANSWER : ? YOUR ANSWER : ?