Database Design Using Normalization MCQ

Test your knowledge with important Database Design Using Normalization MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Database Design Using Normalization MCQs on Bissoy. Bissoy App

• 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.
  ক

  True

  খ

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

  True

  খ

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

  True

  খ

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

  True

  খ

  False
• When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
  ক

  True

  খ

  False
• One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
  ক

  True

  খ

  False
• When building a database from an existing set of tables, we still need to consider normalization principles.
  ক

  True

  খ

  False
• 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.
  ক

  True

  খ

  False
• Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
  ক

  Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

  খ

  Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

  গ

  Three rows have the values Brown, NULL, and Blue in the same column.

  ঘ

  One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
• When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
  ক

  first step.

  খ

  second step.

  গ

  third step.

  ঘ

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

  first step.

  খ

  second step.

  গ

  third step.

  ঘ

  fourth step.
• Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
  ক

  Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

  খ

  Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

  গ

  Three rows have the values Brown, NULL, and Blue in the same column.

  ঘ

  One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
• When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
  ক

  first step.

  খ

  second step.

  গ

  third step.

  ঘ

  fourth step.
• Each answer below shows example data from a table. Which answer is an example of the missing values problem?
  ক

  Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

  খ

  Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

  গ

  Three rows have the values Brown, NULL, and Blue in the same column.

  ঘ

  One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
• When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
  ক

  first step.

  খ

  second step.

  গ

  third step.

  ঘ

  fourth step.
• Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
  ক

  The multivalue, multicolumn problem

  খ

  The inconsistent values problem

  গ

  The missing values problem

  ঘ

  The general-purpose remarks column problem
• When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
  ক

  first step.

  খ

  second step.

  গ

  third step.

  ঘ

  fourth step.