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

Question

Share Report Error

What is the main advantage of using a DBMS?

A. Data sharing and concurrency control

B. All of the above

C. Reduced application development time

D. Data integrity and security

Answer: Option B

Solution (By JKSSB Mock Tests)

DBMS provides numerous benefits including data sharing, concurrency control, integrity, security, and reduces development time.

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 condition-tester returns TRUE if a subquery returns one or more records, and FALSE if the subquery returns no rows?

A. ALL

B. ANY

C. EXISTS

D. IN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The EXISTS operator is used to test for the presence of any records in a subquery, returning TRUE as soon as a single matching row is encountered.

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

Question #2

Which SQL statement is used to delete all rows from a table without logging individual row deletions?

A. TRUNCATE TABLE table_name;

B. DROP TABLE table_name;

C. REMOVE FROM table_name;

D. DELETE FROM table_name;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.

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

Question #3

Which SQL keyword is used within a SELECT query to filter records matching a specified pattern using wildcards?

A. IN

B. BETWEEN

C. LIKE

D. EXISTS

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The LIKE operator is specifically used in a WHERE clause to perform pattern matching on string columns using wildcards (% and _).

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

Explore All Database Management System (DBMS) MCQs