Top

Data Models into Database Designs

21.

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

Answer: D

No answer description available for this question.

Enter details here

22.

SQL Server does not support the BEFORE trigger.

Answer: A

No answer description available for this question.

Enter details here

23.

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

Answer: B

No answer description available for this question.

Enter details here

24.

A foreign key is used to implement relationships between tables.

Answer: A

No answer description available for this question. 

Enter details here

25.

When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

Answer: A

No answer description available for this question. 

Enter details here

Answer: C

No answer description available for this question. 

Enter details here

27.

Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

Answer: A

No answer description available for this question. 

Enter details here

28.

In 1:N relationships, which entity becomes the parent entity is arbitrary.

Answer: B

No answer description available for this question.

Enter details here

29.

An intersection table is required to represent M:N relationships.

Answer: A

No answer description available for this question. 

Enter details here

30.

For every relationship, how many possible sets of minimum cardinalities are there?

Answer: C

No answer description available for this question. 

Enter details here

Loading…
Tags: Data Models into Database Designs Questions and Answers || Data Models into Database Designs MCQ Questions and Answers || Data Models into Database Designs GK Questions and Answers || Data Models into Database Designs GK MCQ Questions || Data Models into Database Designs Multiple Choice Questions and Answers || Data Models into Database Designs GK || GK on Data Models into Database Designs || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database