Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following is used for manufacturing chips?
a. control bus
b. control unit
c. parity unit
d. semiconductor
Q. How many types of keys in Database Design?
a. foreign key
b. all of the options
c. candidate key
d. primary key
Q. Which of the following is based on Multi Valued Dependency?
a. third
b. fourth
c. first
d. second
Q. Which of the following is the structure of the Database?
a. table
b. none of these
c. schema
d. relation
Q. The minimal set of super key is called
a. primary key
b. secondary key
c. foreign key
d. candidate key
Q. ______________ is a classical approach to database design?
a. bottom – up approach
b. top – down approach
c. left – right approach
d. right – left approach
Q. _____________ refers to the correctness and completeness of the data in a database?
a. data independence
b. data integrity
c. data security
d. data constraint
Q. A table that displays data redundancies yields ____________ anomalies
a. insertion
b. deletion
c. update
d. all of the options
Q. A lock that allows concurrent transactions to access different rows of the same table is known as a
a. row-level lock
b. database-level lock
c. field-level lock
d. table-level lock
Q. A type of query that is placed within a WHERE or HAVING clause of another query is called
a. multi-query
b. sub query
c. super query
d. master query
Q. A form defined
a. none of the options
b. where data is placed on the screen
c. the width of each field
d. both where data is placed on the screen and the width of each field
Q. If a piece of data is stored in two places in the database, then
a. in can be more easily accessed
b. both storage space is wasted and changing the data in one spot will cause data inconsistency
c. storage space is wasted
d. changing the data in one spot will cause data inconsistency
Q. Which of the following is a problem of file management system?
a. data redundancy and program dependence
b. all of the options
c. difficult to update
d. lack of data independence
Q. Which of the following is not an advantage of the database approach
a. elimination of data redundancy
b. ability of associate deleted data
c. increased security and program/data independence
d. all of the above
Q. An audit trail
a. none of the options
b. is the recorded history of operations performed on a file
c. is used to make backup copies
d. can be used to restore lost information