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