RDBMS is based on which model? MCQ with Answer and Explanation

RDBMS is based on which model?

A. Relational model

B. Network model

C. Hierarchical model

D. Object-oriented model

Answer: Option A

Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.

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

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

Question #1 Report Error

What is a primary key in a database table?

A. A key that references a column in another table

B. A key that uniquely identifies each row in a table

C. A key that is always numeric

D. A key that can contain duplicate values

Correct Answer: Option B

Explanation:
A primary key is a column or set of columns that uniquely identifies each row in a table, ensuring entity integrity.

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

Question #2 Report Error

Which of the following ensures data integrity in RDBMS?

A. Constraints like primary key, foreign key

B. User input without checks

C. Random data entry

D. No validation rules

Correct Answer: Option A

Explanation:
Integrity constraints such as keys enforce rules for valid data.

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

Question #3 Report Error

What is the purpose of the SQL 'CASE' statement?

A. To create a table

B. To update records

C. To delete records

D. To implement conditional logic within a query

Correct Answer: Option D

Explanation:
CASE allows for conditional expressions, similar to IF-THEN-ELSE, within SQL statements.

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