For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Four Three Six Two TRUE ANSWER : ? YOUR ANSWER : ?
In 1:N relationships, which entity becomes the parent entity is arbitrary. True False 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 : ?
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): foreign key. primary key. surrogate key. composite key. TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the primary key placement is arbitrary. True False TRUE ANSWER : ? YOUR ANSWER : ?
A primary key should be defined as: Either of the above can be used. None of these NOT NULL. NULL. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? A domain constraint A range constraint An interrelation constraint An intrarelation constraint TRUE ANSWER : ? YOUR ANSWER : ?
When transforming an entity-relationship model into a relational database design, each entity is represented as a table. True False TRUE ANSWER : ? YOUR ANSWER : ?
Cascading updates refers to child rows being automatically deleted when a parent row is deleted. False True TRUE ANSWER : ? YOUR ANSWER : ?