Which of the following is a benefit of DBMS? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a benefit of DBMS?

A. Limited data access

B. Increased data inconsistency

C. Higher data redundancy

D. Data sharing among multiple users

Answer: Option D

Solution (By JKSSB Mock Tests)

DBMS allows controlled data sharing while maintaining integrity and security.

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 happens when a database transaction triggers a 'COMMIT' statement?

A. The database structure is dropped.

B. The transaction is aborted and wiped.

C. All changes made by the transaction are made permanent on disk storage.

D. The transaction pauses temporarily.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Executing a COMMIT statement instructs the database engine to save all data updates performed during the transaction permanently into physical storage.

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

Question #2

Which constraint ensures that a column cannot have NULL values?

A. UNIQUE

B. PRIMARY KEY

C. NOT NULL

D. FOREIGN KEY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
NOT NULL constraint enforces that a column must have a value, preventing NULL entries.

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

Question #3

Which operator allows you to specify a range of values to filter query results, including the specified start and end endpoints?

A. BETWEEN

B. LIKE

C. WITHIN

D. IN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The BETWEEN operator selects values within a specific inclusive range. It is shorthand for a combination of greater-than-or-equal-to and less-than-or-equal-to conditions.

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

Explore All Database Management System (DBMS) MCQs