ADVERTISEMENT
ADVERTISEMENT

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: D) None of the above

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

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.


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.


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.


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.


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: D) None of the above

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.


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.


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.


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.


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.


ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.