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

Question

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

A. 10 rules

B. 12 rules

C. 8 rules

D. 14 rules

Answer: Option B

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.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

What is a subquery in database terminology?

A. A query that executes after the main query terminates.

B. A query that runs on a backup server.

C. A nested SQL query placed completely inside another outer query statement.

D. An error log file.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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)

Question #2

Share Report

What is the difference between a clustered and a non-clustered index?

A. They both determine physical order

B. Clustered index determines physical order; non-clustered is a logical order

C. Non-clustered determines physical order; clustered is logical

D. There is no difference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A clustered index sorts the data rows and stores them in that order; a non-clustered index is a separate structure with pointers to data rows.

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