What is the main advantage of using a DBMS over a file system? MCQ with Answer and Explanation

Question

Share Report Error

What is the main advantage of using a DBMS over a file system?

A. Data consistency is maintained

B. Data redundancy is minimized

C. All of the above

D. Data security and access control are provided

Answer: Option C

Solution (By JKSSB Mock Tests)

A DBMS offers advantages like reduced redundancy, consistency, security, concurrent access, and backup/recovery compared to file 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

What is a candidate key?

A. A column that allows duplicate values

B. A column that can be used as a primary key but is not chosen

C. A set of columns that uniquely identifies a row and can serve as a primary key

D. A foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A candidate key is an attribute or set of attributes that can uniquely identify a tuple; one is selected as the primary key.

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

Question #2

Which SQL keyword is used to remove a table from the database?

A. DELETE

B. REMOVE

C. DROP

D. TRUNCATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DROP TABLE is a DDL command that deletes the table and its structure from the database.

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 specify the new values

B. To join tables

C. To sort the results

D. To specify which rows to update

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

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)

Explore All Database Management System (DBMS) MCQs