Top

Database Design Using Normalization

21.

Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

Answer: B

No answer description available for this question.

Enter details here

Answer: C

No answer description available for this question.

Enter details here

23.

We have normalized a table into BCNF if all candidate keys are determinants.

Answer: B

No answer description available for this question. 

Enter details here

24.

Read-only databases are ________ updated.

Answer: D

No answer description available for this question.

Enter details here

25.

If a table has been normalized so that all determinants are candidate keys, then that table is in:

Answer: D

No answer description available for this question.

Enter details here

26.

When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:

Answer: B

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

28.

Any table that meets the definition of a relation is said to be in first normal form.

Answer: A

No answer description available for this question.

Enter details here

29.

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

Answer: B

No answer description available for this question.

Enter details here

30.

When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:

Answer: A

No answer description available for this question.

Enter details here

Loading…
Tags: Database Design Using Normalization Questions and Answers || Database Design Using Normalization MCQ Questions and Answers || Database Design Using Normalization GK Questions and Answers || Database Design Using Normalization GK MCQ Questions || Database Design Using Normalization Multiple Choice Questions and Answers || Database Design Using Normalization GK || GK on Database Design Using Normalization || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database