Top

Database Redesign

11.

How many copies of the database schema are typically used in the redesign process?

Answer: C

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

13.

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

Answer: C

No answer description available for this question.

Enter details here

14.

Which SQL-92 standard SQL command can be used to change a table name?

Answer: D

No answer description available for this question.

Enter details here

15.

The data model produced from the reverse engineering process does not include intersection table data.

Answer: B

No answer description available for this question.

Enter details here

16.

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

Answer: B

No answer description available for this question. 

Enter details here

17.

The EXISTS keyword will be true if any row in the subquery meets the condition.

 

Answer: A

No answer description available for this question.

Enter details here

18.

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

Answer: A

No answer description available for this question.

Enter details here

19.

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

Answer: A

No answer description available for this question.

Enter details here

20.

A correlated subquery is processed as a nested subquery.

Answer: A

No answer description available for this question. 

Enter details here

Loading…
Tags: Database Redesign Questions and Answers || Database Redesign MCQ Questions and Answers || Database Redesign GK Questions and Answers || Database Redesign GK MCQ Questions || Database Redesign Multiple Choice Questions and Answers || Database Redesign GK || GK on Database Redesign || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database