Top

Data Models into Database Designs

31.

Intersection tables are ID-dependent on both their parent tables.

Answer: A

No answer description available for this question.

Enter details here

32.

The identifier of an entity will become the ________ of the new table.

Answer: C

No answer description available for this question.

Enter details here

33.

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

Answer: D

No answer description available for this question

Enter details here

34.

When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

Answer: A

No answer description available for this question.

Enter details here

35.

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?

Answer: C

No answer description available for this question.

Enter details here

36.

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?

Answer: D

No answer description available for this question.

Enter details here

37.

The DBMS allows surrogate keys to be changed.

Answer: B

No answer description available for this question. 

Enter details here

38.

If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

Answer: A

No answer description available for this question.

Enter details here

Answer: B

No answer description available for this question.

Enter details here

40.

When the parent entity is required, a new parent row can always be inserted.

Answer: A

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