Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Snapshot of the data in the database at a given instant of time is called
a. database instance
b. all of the options
c. database schema
d. database snapshot
Q. Which of the following is not binary operation?
a. union
b. set difference
c. cartesian product
d. project
Q. Which of the following is correct regarding Aggregate functions?
a. it takes a single value and returns a single value as result
b. it takes a list of values and return a single values as result
c. it takes a list of values and return a list of values as result
d. it takes a single value and returns a list of values as result
Q. A command to remove a relation from an SQL database
a. delete table
b. erase table
c. alter table
d. drop table
Q. The attribute that can be divided into other attributes is called
a. composite attribute
b. derived attribute
c. simple attribute
d. multi-valued attribute
Q. What is ACID properties of Transactions?
a. atomicity, consistency, isolation, database
b. automatically, concurrency, isolation, durability
c. atomicity, consistency, isolation, durability
d. atomicity, consistency, inconsistent, durability
Q. If every non-key attribute is functionally dependent on the primary key, the relation will be in
a. fourth formal form
b. third normal form
c. first normal form
d. second normal form
Q. Database locking concept is used to solve the problem of
a. inconsistent data
b. all of the options
c. lost update
d. uncommitted dependency
Q. UML is stands for
a. universal modeling language
b. united modeling language
c. uni modeling language
d. unified modeling language
Q. Data Manipulation Language (DML) is not to
a. insertion of new information into the database
b. modification of information in the database
c. create information table in the database
d. deletion of information in the database
Q. Which of the following in true regarding Referential Integrity?
a. every primary-key value must match a primary-key value in an associated table
b. every primary-key value must match a foreign-key value in an associated table
c. every foreign-key value must match a foreign-key value in an associated table
d. every foreign-key value must match a primary-key value in an associated table
Q. Which of the following option is use to retrieval of data?
a. stack
b. data structure
c. linked list
d. query