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. All of the above

C. Data redundancy is minimized

D. Data security and access control are provided

Answer: Option B

Solution (By JKExamLibrary)

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 metadata?

A. Data about data

B. User data

C. Backup data

D. Temporary data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Metadata is data that provides information about other data, such as structure and constraints.

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

Question #2

What is a candidate key in a relation?

A. A super key that is minimal

B. Any column that can be used as a primary key

C. A foreign key

D. A key that is not unique

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A candidate key is a minimal super key, meaning no subset of it can uniquely identify a row.

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

Question #3

What is the main purpose of indexing in a database?

A. To encrypt data

B. To delete data

C. To backup data

D. To speed up data retrieval

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Indexes improve the speed of data retrieval operations on a database table.

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

Explore All Database Management System (DBMS) MCQs