Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. An Oracle is a set of tables and views that are used as a read-only reference about the database.
a. database dictionary
b. dictionary table
c. data dictionary
d. dictionary
Q. Which of these is not a feature of Hierarchical model?
a. organizes the data in tree-like structure
b. parent node can have any number of child nodes
c. root node does not have any parent
d. child node can have any number of parent nodes
Q. Which of these data models is an extension of the relational data model?
a. object-oriented data model
b. object-relational data model
c. semi structured data model
d. none of the mentioned
Q. The technique where the blocks which have been used are replaced is called
a. replacement strategy
b. forced strategy
c. crash recovery system
d. most recently used
Q. An consists of a search-key value and pointers to one or more records with that value as their search-key value.
a. index entry
b. index hash
c. index cluster
d. index map
Q. In a index, an index entry appears for only some of the search-key values.
a. dense
b. sparse
c. straight
d. continuous
Q. A search key containing more than one attribute is referred to as a search key.
a. simple
b. composite
c. compound
d. secondary
Q. If h is any hashing function and is used to hash n keys in to a table of size m, where n<=m, the expected number of collisions involving a particular key x is :
a. less than 1
b. less than n
c. less than m
d. less than n/2
Q. Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
a. 8, _, _, _, _, _, 10
b. 1, 8, 10, _, _, _, 3
c. 1, _, _, _, _, _,3
d. 1, 10, 8, _, _, _, 3
Q. Key value pairs is usually seen in
a. hash tables
b. heaps
c. both hash tables and heaps
d. skip list
Q. A(n) can be used to preserve the integrity of a document or a message.
a. message digest
b. message summary
c. encrypted message
d. none of the mentioned
Q. The database design that consists of multiple tables that are linked together through matching data stored in each table is called
a. hierarchical database
b. network database
c. object oriented database
d. relational database
Q. A on the attribute A of relation r consists of one bitmap for each value that A can take.
a. bitmap index
b. bitmap
c. index
d. array