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. 14 rules

B. 12 rules

C. 10 rules

D. 8 rules

Answer: Option B

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)

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

Question #1 Report Error

Which of the following is a valid SQL data type for a date and time?

A. DATE

B. All of the above

C. TIMESTAMP

D. DATETIME

Correct Answer: Option B

Explanation:
Different DBMS support DATETIME, TIMESTAMP, DATE, etc. All are valid date/time types.

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

Question #2 Report Error

What does DDL stand for in SQL?

A. Data Definition Language

B. Data Description Language

C. Data Manipulation Language

D. Dynamic Data Link

Correct Answer: Option A

Explanation:
DDL (Data Definition Language) includes commands like CREATE, ALTER, DROP for defining database structures.

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

Question #3 Report Error

What is a view in a database?

A. A virtual table based on the result of a SELECT query

B. A physical table stored on disk

C. A backup of a table

D. An index on a table

Correct Answer: Option A

Explanation:
A view is a logical representation of data, derived from one or more tables, but does not store data physically.

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