Database Management System MCQ DBMS MCQ Questions Answers Download PDF
There is a golden opportunity for all the candidates who want to learn about the database. We are answering all the questions on the database here.
We provide material here for all the candidates who are preparing for the Competitive Exam.Those who have studied computer engineering must be preparing for the competitive exam.We have provided dbms mcq questions and answers thinking about them here. Just thinking about someone we have dbms mcq questions here.dbms interview questions and answers are very important for those who are preparing for the technical line. We have provided all the material here for dbms short notes.
1) In the context of data warehousing, data map or ‘data about data’ is known as …………….
a) tuple
b) attribute
c) metadata
d) teradata
2) Which of the following normal form deals with the anomaly of multivalue dependency?
a) 1NF
b) 2NF
c) 4NF
d) 5NF
3) Which of the following normal form deals with the repeating group anomaly?
a) 1NF
b) 2NF
c) 4NF
d) 5NF
4) …………… is a database language used to define data structures in SQL?
a) Sybase
b) Oracle
c) DDL
d) MySQL
5) The ………………… is a database file that contains metadata.
a) data index
b) data repository
c) data dictionary
d) none
6)Which of the following is not the state of a transaction in the database?
a) Active
b) Committed
c) Terminated
d) Nullified
7) The …………… file saves the recovery scenario in Quick Test Professional (QTP) environment
a) QRS
b) JPEG
c) DOC
d) TSR
8) Which of the following is not a command is SQL?
a) WHERE
b) ORDER BY
c) REMOVE
d) SELECT
9) How should we traverse an oracle database to retrieve a row in the quickest possible time?
a) Full table scan
b) Unique index
c) Primary key
d) Table access by row id
10) Which of the following is a concurrency control protocol?
a) Locked-based protocol
b) two-phase locking protocol
c) Timestamp ordering protocol
d) all