Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. The database design prevents some data from being represented due to
a. deletion anomalies
b. insertion anomalies
c. update anomaly
d. none of the mentioned
Q. Who developed the normalization process:
a. e.f. codd
b. f.f. codd
c. e.e. codd
d. none of the mentioned
Q. Which is the process of breaking a relation into multiple relations:
a. functional dependency
b. database modeling
c. normalization
d. decomposition
Q. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
a. concurrency
b. deadlock
c. backup
d. recovery
Q. Which is the duplication of computer operations and routine backups to combat any unforeseen problems:
a. concurrency
b. deadlock
c. backup
d. recovery
Q. Optimization basically related to the Rewrite module is termed as
a. semantic query optimization
b. global query optimization
c. all of the mentioned
d. none of the mentioned
Q. Database security helps organizations to protect data from
a. internal users
b. external users
c. non-external users
d. non internal users
Q. Which are types of recovery control techniques:
a. deferred update
b. immediate update
c. all of the mentioned
d. none of the mentioned
Q. Which server can join the indexes when only multiple indexes combined can cover the query:
a. sql
b. dbms
c. rdbms
d. all of the mentioned
Q. In concurrency control policy the lock is obtained on
a. entire database
b. a particular transaction alone
c. all the new elements
d. all of the mentioned
Q. Which statement is true regarding external tables?
a. the default reject limit for external tables is unlimited
b. the data and metadata for an external table are stored outside the database
c. oracle_loader and oracle_datapump have exactly the same functionality when used with an external table
d. the create table as select statement can be used to unload data into regular table in the database from an external table
Q. Isolation of the transactions is ensured by
a. transaction management
b. application programmer
c. concurrency control
d. recovery management