What is the difference between a database and a database management system? MCQ with Answer and Explanation

What is the difference between a database and a database management system?
A. Database is a file; DBMS is a table
B. A database is the data; DBMS is the software that manages it
C. DBMS is the data; database is the software
D. They are the same
Answer: Option B
Solution (By JKSSB Mock Tests)
A database is a collection of structured data, while a DBMS is the software used to interact with and manage that data.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which SQL wildcard character is used to match exactly one single character when using the LIKE operator?
A. Question mark (?)
B. Percentage sign (%)
C. Underscore (*)
D. Asterisk (*)

Correct Answer: Option C


Explanation:
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'CONSTRAINT' keyword?
A. To define rules for data integrity
B. To create views
C. To join tables
D. To create indexes

Correct Answer: Option A


Explanation:
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The ability to modify the physical schema without forcing application programs to be rewritten is called what?
A. Data Redundancy
B. Logical Data Independence
C. Physical Data Independence
D. Structural Integrity

Correct Answer: Option C


Explanation:
Physical Data Independence is the ability to modify the physical schema (like storage devices or file structures) without changing the conceptual or external schemas.

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