DBMS MCQ
What is a Database?
A database is a collection of related data which represents some aspect of the real world. A database system is designed to be built and populated with data for a certain task.
What is DBMS?
Database Management System (DBMS) is a software for storing and retrieving users’ data while considering appropriate security measures. It consists of a group of programs which manipulate the database. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software to store and retrieve data.
DBMS allows users to create their own databases as per their requirement. The term “DBMS” includes the user of the database and other application programs. It provides an interface between the data and the software application.
In this section, we are going to cover some of the basic questions based on DBMS, which are frequently asked during an interview. Here we will try to cover almost all the topics related to DBMS.
51) ____a condition where two or more transactions are waiting indefinitely for one another to give up locks.
A. Deadlock
B. Waiting
C. Idle
D. Ready
Answer: a
Explanation: When one data item is waiting for another data item in a transaction, then the system is in a deadlock state.
52) Which of the following are the ways of avoiding deadlock?
A. Deadlock detection
B. Deadlock avoidance
C. Deadlock prevention
D. All of the above
Answer: d
53)Which of the following is the transaction failure?
A. Logical errors
B. Boot errors
C. Read error
D. All of the above
Answer: a
Explanation: Logical errors and syntax errors are the types of transaction failure.
54) Which kind of failure loses its data in head crash or failure during a transfer operation?
A. Disk failure
B. System crash
C. Transaction failure
D. All of the above
Answer: a
Explanation: This kind of error occurs due to the formation of bad sectors, head crashes, and unreachability to the disk.
55) The log is a sequence of _____ recording all the update activities in the database.
A. Records
B. Log records
C. Entries
D. Redo
Answer: b
Explanation: Log records are the most commonly used recovery method.
