Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Where is metadata stored in MySQL?
a. in the mysql database meta
b. in the mysql database metasql
c. in the mysql database metadata
d. in the mysql database mysql
Q. What MySQL property is used to create a surrogate key in MySQL?
a. identical
b. unique
c. auto_increment
d. sequence
Q. A Database Management System (DBMS) is:
a. collection of data describing one particular enterprise
b. collection of programs to access data
c. all options are correct
d. collection of interrelated data
Q. Which of the following is not a level of data abstraction?
a. view level
b. physical level
c. logical level
d. critical level
Q. Disadvantages of File systems to store data is:
a. data isolation
b. data redundancy and inconsistency
c. difficulty in accessing data
d. all options are correct
Q. In an Entity Relationship Diagram Rectangles represents
a. tables
b. attributes
c. database
d. entity sets
Q. Which of the following is not a Storage Manager Component?
a. transaction manager
b. logical manager
c. file manager
d. buffer manager
Q. Data Manipulation Language enables users to
a. retrieval of information stored in database
b. insertion of new information into the database
c. deletion of information from the database
d. all the options are correct
Q. Which of the following is not an Schema?
a. logical schema
b. physical schema
c. database schema
d. critical schema
Q. Which of the following is Database Language?
a. data definition language
b. data manipulation language
c. data query language
d. all of the options
Q. Which of the following in not a function of DBA?
a. network maintenance
b. schema definition
c. authorization for data access
d. routine maintenance
Q. Which of the following is a Data Model?
a. entity relationship model
b. object based data model
c. all of the options are correct
d. relational data model
Q. A Database Management System (DBMS) is
a. collection of interrelated data
b. collection of data describing one particular enterprise
c. all of the options
d. collection of programs to access data
Q. Which of the following is not a level of data abstraction?
a. physical level
b. view level
c. critical level
d. logical level