How many fundamental rules did E.F. Codd define to determine whether a database system qualifies as a true relational database management system? MCQ with Answer and Explanation

How many fundamental rules did E.F. Codd define to determine whether a database system qualifies as a true relational database management system?
A. 12 rules
B. 10 rules
C. 8 rules
D. 14 rules
Answer: Option A
Solution (By JKSSB Mock Tests)
E.F. Codd formulated 12 rules (numbered 0 to 11, often called Codd's 12 Rules) to evaluate relational database management systems.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What is a tuple in a relational database?
A. A relationship between tables
B. A single column in a table
C. A single row in a table
D. The name of the table

Correct Answer: Option C


Explanation:
In RDBMS, a tuple represents a single row or record in a relation (table).

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which property of a DBMS ensures that all operations within a transaction are completed successfully, or none of them are executed at all?
A. Consistency
B. Isolation
C. Durability
D. Atomicity

Correct Answer: Option D


Explanation:
Atomicity follows the 'all-or-nothing' rule, ensuring that a transaction is either fully committed or completely rolled back if an error occurs.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a subquery in database terminology?
A. A query that executes after the main query terminates.
B. An error log file.
C. A query that runs on a backup server.
D. A nested SQL query placed completely inside another outer query statement.

Correct Answer: Option D


Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).

This question belongs to: Computer Database Management System (DBMS)