Database Management System (DBMS) MCQs with answers Page - 84

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. To identify the deleted records we use the

  • (A) existence bitmap
  • (B) current bitmap
  • (C) final bitmap
  • (D) deleted bitmap

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

Q. How many types of indexes are there in sql server?

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 4

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

Q. If an index is the metadata and statistics continue to exists

  • (A) disabling
  • (B) dropping
  • (C) altering
  • (D) both disabling and dropping

A

Admin • 833.24K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.