Top

Database Design Using Normalization

31.

Denormalized tables are in BCNF.

Answer: B

No answer description available for this question

Enter details here

32.

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

Answer: A

No answer description available for this question. 

Enter details here

33.

Creating a read-only database is a task that is ________ assigned to beginning database professionals.

Answer: B

No answer description available for this question.

Enter details here

34.

One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.

Answer: A

No answer description available for this question.

Enter details here

35.

We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

Answer: B

No answer description available for this question.

Enter details here

36.

When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.

Answer: B

No answer description available for this question.

Enter details here

37.

One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.

Answer: B

No answer description available for this question.

Enter details here

38.

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

Answer: B

No answer description available for this question.

Enter details here

39.

When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

Answer: B

No answer description available for this question.

Enter details here

40.

One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

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