Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. To identify the deleted records we use the
a. existence bitmap
b. current bitmap
c. final bitmap
d. deleted bitmap
Q. In B+ tree the node which points to another node is called
a. leaf node
b. external node
c. final node
d. internal node
Q. In the client / server model, the database:
a. is downloaded to the client upon request
b. is shared by both the client and server
c. resides on the client side
d. resides on the server side
Q. Bitmaps can be combined with regular B+- tree indices for relations where a few attribute values are extremely common, and other values also occur, but much less frequently.
a. bitmap, b-tree
b. bitmap, b+tree
c. b-tree, bitmap
d. b+tree, bitmap
Q. What is the purpose of the index in sql server?
a. to enhance the query performance
b. to provide an index to a record
c. to perform fast searches
d. all of the mentioned
Q. How non clustered index point to the data?
a. it never points to anything
b. it points to a data row
c. it is used for pointing data rows containing key values
d. none of the mentioned
Q. Which one is true about clustered index?
a. clustered index is not associated with table
b. clustered index is built by default on unique key columns
c. clustered index is not built on unique key columns
d. none of the mentioned
Q. What is true about indexes?
a. indexes enhance the performance even if the table is updated frequently
b. it makes harder for sql server engines to work to work on index which have large keys
c. it doesn’t make harder for sql server engines to work to work on index which have large keys
d. none of the mentioned
Q. Does index take space in the disk?
a. it stores memory as and when required
b. yes, indexes are stored on disk
c. indexes are never stored on disk
d. indexes take no space
Q. If an index is the metadata and statistics continue to exists
a. disabling
b. dropping
c. altering
d. both disabling and dropping
Q. In index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
a. clustered
b. column store
c. non clustered
d. row store
Q. Which of the following terms does refer to the correctness and completeness of the data in a database?
a. data security
b. data constraint
c. data independence
d. data integrity
Q. In query processing, the is the lowest-level operator to access data.
a. index search
b. linear search
c. file scan
d. access paths
Q. The algorithm scans each index for pointers to tuples that satisfy an individual condition.
a. a2
b. a4
c. a9
d. a6