Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Disadvantages of File systems to store data is:
a. data redundancy and inconsistency
b. difficulty in accessing data
c. data isolation
d. all of the above
Q. In an Entity-Relationship Diagram Rectangles represents
a. entity sets
b. attributes
c. database
d. tables
Q. Which of the following is not a Storage Manager Component?
a. transaction manager
b. logical manager
c. buffer manager
d. file 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 of the above
Q. Which of the following is not an Schema?
a. database schema
b. physical schema
c. critical schema
d. logical schema
Q. Which of the following schemas does define a view or views of the database forparticular users?
a. Internal schema
b. Conceptual schema
c. Physical schema
d. External schema
Q. Which of the following are the process of selecting the data storage and data accesscharacteristics of the database?
a. Logical database design
b. Physical database design
c. Testing and performance tuning
d. Evaluation and selecting
Q. Which of the following terms does refer to the correctness and completeness of the datain a database?
a. Data security
b. Data constraint
c. Data independence
d. Data integrity
Q. A table can be logically connected to another table by defining a
a. Super key
b. Candidate key
c. Primary key
d. Unique key
Q. If the state of the database no longer reflects a real state of the world that the databaseis supposed to capture, then such a state is called
a. Consistent state
b. Parallel state
c. Durable state
d. Inconsistent state
Q. Ensuring isolation property is the responsibility of the
a. Recovery-management component of the DBMS
b. Concurrency-control component of the DBMS
c. Transaction-management component of the DBMS
d. Buffer management component in DBMS
Q. DBMS manages the interaction between __________ and database.
a. Users
b. Clients
c. End Users
d. Stake Holders
Q. Which of the following is not involved in DBMS?
a. End Users
b. Data
c. Application Request
d. HTML