What is the difference between a DBMS and an RDBMS? MCQ with Answer and Explanation

What is the difference between a DBMS and an RDBMS?
A. There is no difference
B. DBMS supports only flat files; RDBMS supports relational tables
C. DBMS is a subset of RDBMS
D. DBMS does not support relationships; RDBMS does
Answer: Option D
Solution (By JKSSB Mock Tests)
RDBMS is a type of DBMS that organizes data in tables with relationships, enforcing referential integrity using primary and foreign keys, while a DBMS may not support such relationships.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which property of a DBMS ensures that all operations within a transaction are completed successfully, or none of them are executed at all?
A. Isolation
B. Atomicity
C. Consistency
D. Durability

Correct Answer: Option B


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 #2
Which of the following is an example of a relational database management system (RDBMS)?
A. Redis
B. Oracle Database
C. Cassandra
D. MongoDB

Correct Answer: Option B


Explanation:
Oracle Database is a well-known RDBMS. MongoDB, Redis, and Cassandra are NoSQL databases.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the role of the 'WHERE' clause in an UPDATE statement?
A. To sort the results
B. To specify the new values
C. To join tables
D. To specify which rows to update

Correct Answer: Option D


Explanation:
The WHERE clause in UPDATE identifies the rows that will be updated. Without it, all rows would be updated.

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