Which software utility serves as an interface between an application program and the physical database files? MCQ with Answer and Explanation

Which software utility serves as an interface between an application program and the physical database files?
A. Linker
B. Database Management System (DBMS)
C. Compiler
D. Operating System
Answer: Option B
Solution (By JKSSB Mock Tests)
A Database Management System (DBMS) acts as an interface between application software and the underlying physical database, managing data storage, retrieval, and updates.

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 the difference between a database and a data warehouse?
A. Both A and B
B. Databases store current data; data warehouses store historical data
C. They are the same
D. Databases are for OLTP, data warehouses for OLAP

Correct Answer: Option A


Explanation:
Databases are optimized for transaction processing (OLTP), while data warehouses are designed for analytical reporting (OLAP) using historical data.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'IN' operator?
A. To check if a value is between two values
B. To check if a value is null
C. To check if a value matches any value in a list
D. To join tables

Correct Answer: Option C


Explanation:
IN is used to test membership in a set of values.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a purpose of a database management system?
A. All of the above
B. To manipulate data
C. To define and create databases
D. To control access to data

Correct Answer: Option A


Explanation:
A DBMS provides functionalities for defining, constructing, manipulating, and controlling access to databases.

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