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 security and access control are provided

C. All of the above

D. Data redundancy is minimized

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

Which of the following is a DML statement?

A. UPDATE

B. ALTER

C. DROP

D. CREATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPDATE is a Data Manipulation Language (DML) command used to modify existing records in a table. CREATE, ALTER, DROP are DDL.

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

Question #2

Information is:

A. Processed and meaningful form of data

B. Programming code

C. Hardware component

D. Raw facts and figures

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Information is data that has been organized and processed to provide context and meaning.

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

Question #3

Which wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters?

A. Underscore (_)

B. Percentage sign (%)

C. Ampersand (&)

D. Hash (#)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The percentage sign (%) is used as a wildcard character to match any sequence of zero or more characters in an SQL LIKE string comparison query.

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

Explore All Database Management System (DBMS) MCQs