MCQ | SQL – Codd's 12 Rules

SQL Codd's 12 Rules MCQ: This section contains the Multiple-Choice Questions & Answers on SQL Codd's 12 Rules.
Submitted by Anushree Goswami, on October 18, 2021

1. Which of the following is among the 12 Codd's Rules?

  1. View Updating Rule
  2. Relational Level Operation Rule
  3. Distribution Independence Rule
  4. None of the above

Answer: A) View Updating Rule

Explanation:

Codd's 12 Rules are:

  1. The Foundation Rule
  2. Information Rule
  3. Guaranteed Access Rule
  4. Systematic Treatment of Null Values
  5. Active/Dynamic Online Catalog based on the relational model
  6. Comprehensive Data SubLanguage Rule
  7. View Updating Rule
  8. Relational Level Operation Rule
  9. Physical Data Independence Rule
  10. Logical Data Independence Rule
  11. Integrity Independence Rule
  12. Distribution Independence Rule
  13. Non Subversion Rule

Discuss this Question


2. Which of the following is TRUE about The Foundation Rule in the 12 Codd's Rules?

  1. Relational databases are required.
  2. Databases contain a wide variety of information, and each row and column of each table must hold this information.
  3. The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
  4. Null values are treated in database records according to this rule.

Answer: A) Relational databases are required

Explanation:

Relational databases are required in The Foundation Rule of 12 Codd's Rules. By using its relational capabilities, the system will be able to manage the database.

Discuss this Question


3. Which of the following is TRUE about Information Rule in the 12 Codd's Rules?

  1. The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
  2. Null values are treated in database records according to this rule.
  3. Database systems must update all views tables on a regular basis.
  4. Databases contain a wide variety of information, and each row and column of each table must hold this information.

Answer: D) Databases contain a wide variety of information, and each row and column of each table must hold this information

Explanation:

In case of Information Rule in the 12 Codd's Rules, Databases contain a wide variety of information, and each row and column of each table must hold this information.

Discuss this Question


4. In case of ____Rule, the primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.

  1. Systematic Treatment of Null Values
  2. Guaranteed Access
  3. View Updating
  4. Physical Data Independence

Answer: B) Guaranteed Access

Explanation:

In case of Guaranteed Access Rule, the primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.

Discuss this Question


5. What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules?

  1. No value in cell
  2. Inappropriate Information
  3. Unknown data
  4. All of the above

Answer: D) All of the above

Explanation:

Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules has different meanings such as no value in the cell, missing the data, inappropriate information, the primary key should not be null and unknown data.

Discuss this Question


6. What is TRUE about the Active/Dynamic Online Catalog based on the relational model in the 12 Codd's Rules?

  1. The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
  2. Null values are treated in database records according to this rule.
  3. Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
  4. None of the above

Answer: C) Database dictionaries represent the complete logic of all descriptive data, which must be stored online

Explanation:

In the case of Active/Dynamic Online Catalogue based on the relational model in the 12 Codd's Rules, Database dictionaries represent the complete logic of all descriptive data, which must be stored online.

Discuss this Question


7. Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?

  1. Data Definition
  2. View Definition
  3. Data Manipulation
  4. All of the above

Answer: D) All of the above

Explanation:

Comprehensive Data SubLanguage Rule in the 12 Codd's Rules supports the comprehensive, Data Definition, Data Manipulation, View Definition, Limit Transaction Management Operations, and Integrity Constraints.

Discuss this Question


8. In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.

  1. Physical Data
  2. Logical Data
  3. Integrity
  4. Distribution

Answer: A) Physical Data

Explanation:

In the case of the Physical Independence Rule, the Physical independence of data to access the database is a requirement for a database or an application.

Discuss this Question


9. In the case of the ____ Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.

  1. Physical Data
  2. Logical Data
  3. Integrity
  4. Distribution

Answer: B) Logical Data

Explanation:

In the case of the Logical Data Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.

Discuss this Question


10. In the case of ____ Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.

  1. Interdependent
  2. Intradependent
  3. Integration
  4. Integrity

Answer: D) Integrity

Explanation:

In the case of the Integrity Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.

Discuss this Question





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.