Database Management Systems Mcqs

Page No. 43

Which one is true about clustered index?


aClustered index is not associated with table


bClustered index is built by default on unique key columns


cClustered index is not built on unique key columns


dNone of the mentioned



How non clustered index point to the data?


aIt never points to anything


bIt points to a data row


cIt is used for pointing data rows containing key values


dNone of the mentioned



How many types of indexes are there in sql server?


a1


b2


c3


d4


View Answer 2

What is the purpose of the index in sql server?


aTo enhance the query performance


bTo provide an index to a record


cTo perform fast searches


dAll of the mentioned


View Answer All of the mentioned

A tablespace is further broken down into ________


aTablespace


b Segments


cExtents


dBlocks


View Answer Segments

In a B+-tree index ______ for each value, we would normally maintain a list of all records with that value for the indexed attribute.


aLeaf


bNode


cRoot


dLink


View Answer Leaf

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.


aBitmap, B-tree


bBitmap, B-tree


cB-tree, Bitmap


dB+tree, Bitmap


View Answer Bitmap, B-tree

Bitmaps can be used as a compressed storage mechanism at the leaf nodes of ________ for those values that occur very frequently.


aB-trees


bB+-trees


cBit trees


dBoth B-trees and B+-trees


View Answer B+-trees

To identify the deleted records we use the ______________


aExistence bitmap


bCurrent bitmap


cFinal bitmap


dDeleted bitmap


View Answer Existence bitmap

A _______ on the attribute A of relation r consists of one bitmap for each value that A can take.


aBitmap index


bBitmap


cIndex


dArray


View Answer Bitmap index

Goto Page No.

Page 43 of 101

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan