Which of the following is NOT an advantage of DBMS over traditional file systems? MCQ with Answer and Explanation

Which of the following is NOT an advantage of DBMS over traditional file systems?
A. Data independence
B. Higher data security
C. Data redundancy control
D. Simpler implementation and lower cost
Answer: Option D
Solution (By JKSSB Mock Tests)
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.

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 database schema?
A. A single table
B. The overall design or structure of the database, including tables, columns, and relationships
C. A backup file
D. A query result

Correct Answer: Option B


Explanation:
A schema is the logical description of the entire database, defining tables, views, indexes, and constraints.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which SQL keyword is placed immediately inside a SELECT statement or an aggregate function to eliminate duplicate rows from the output?
A. DISTINCT
B. UNIQUE
C. SINGLE
D. DIFFERENT

Correct Answer: Option A


Explanation:
The DISTINCT keyword is used to remove all duplicate values or records from the output of an SQL SELECT query.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which type of join returns all rows from the left table and matching rows from the right table?
A. LEFT JOIN
B. RIGHT JOIN
C. INNER JOIN
D. FULL JOIN

Correct Answer: Option A


Explanation:
LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table, with matching rows from the right table; NULLs appear when no match.

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