Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. When the the backup site takes over processing and becomes the primary.
a. secondary fails
b. backup recovers
c. primary fails
d. none of the mentioned
Q. The simplest way of transferring control is for the old primary to receive from the old backup site.
a. undo logs
b. redo logs
c. primary logs
d. all of the mentioned
Q. The time to process the remote backup can be reduced by
a. flags
b. breakpoints
c. redo points
d. checkpoints
Q. A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is
a. one safe
b. two safe
c. two-very safe
d. very safe
Q. A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
a. one safe
b. two safe
c. two-very safe
d. very safe
Q. If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is
a. one safe
b. two safe
c. two-very safe
d. very safe
Q. A Database Management System (DBMS) is
a. Collection of interrelated data
b. Collection of programs to access data
c. Collection of data describing one particular enterprise
d. All of the above
Q. Which of the following is not a Schema?
a. Database Schema
b. Physical Schema
c. Critical Schema
d. Logical Schema
Q. The number of entities associated in relationship is called as it’s.....................
a. Cardinality
b. Degree
c. Tuples
d. Entity
Q. The DBMS utility...................... allows reconstructing the correct state of database from the backupand history of transactions.
a. Backup
b. Recovery
c. Monitoring
d. Data loading
Q. In the........... Normal form, a composite attribute is converted to individual attributes.
a. First
b. Second
c. Third
d. Fourth
Q. In RDBMS, Data is presented as a collection of............
a. Table
b. Attributes
c. Relations
d. Entities
Q. To select all columns from the table the syntax is:
a. Select all from table_name
b. Select * from table_name
c. Select from table_name
d. Non of the above