Home »
SQL »
SQL MCQs
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
SQL Codd's 12 Rules MCQs
1. Which of the following is among the 12 Codd's Rules?
- View Updating Rule
- Relational Level Operation Rule
- Distribution Independence Rule
- None of the above
Answer: A) View Updating Rule
Explanation:
Codd's 12 Rules are:
- The Foundation Rule
- Information Rule
- Guaranteed Access Rule
- Systematic Treatment of Null Values
- Active/Dynamic Online Catalog based on the relational model
- Comprehensive Data SubLanguage Rule
- View Updating Rule
- Relational Level Operation Rule
- Physical Data Independence Rule
- Logical Data Independence Rule
- Integrity Independence Rule
- Distribution Independence Rule
- Non Subversion Rule
Discuss this Question
2. Which of the following is TRUE about The Foundation Rule in the 12 Codd's Rules?
- Relational databases are required.
- Databases contain a wide variety of information, and each row and column of each table must hold this information.
- 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.
- 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?
- 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.
- Null values are treated in database records according to this rule.
- Database systems must update all views tables on a regular basis.
- 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.
- Systematic Treatment of Null Values
- Guaranteed Access
- View Updating
- 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?
- No value in cell
- Inappropriate Information
- Unknown data
- 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?
- 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.
- Null values are treated in database records according to this rule.
- Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
- 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?
- Data Definition
- View Definition
- Data Manipulation
- 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.
- Physical Data
- Logical Data
- Integrity
- 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.
- Physical Data
- Logical Data
- Integrity
- 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.
- Interdependent
- Intradependent
- Integration
- 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