Home » MCQs » SQL MCQs » SQL Codd's 12 Rules MCQs

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

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.