Database Management Systems Mcqs

Page No. 42

The flash memory storage used are


aNOR Flash

✓


bOR Flash

✖


cAND Flash

✖


dAll of the mentioned

✖


View Answer NOR Flash

Which of the following stores several gigabytes of data but usually lost when power failure?


aFlash memory

✖


bDisk

✖


cMain memory

✓


dSecondary memory

✖


View Answer Main memory

The _________ is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.


aCache

✓


bDisk

✖


cMain memory

✖


dFlash memory

✖


View Answer Cache

Which of the following is a physical storage media?


aTape Storage

✖


bOptical Storage

✖


cFlash memory

✖


dAll of the mentioned

✓


View Answer All of the mentioned

A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.


aClustered

✖


bNon Clustered

✖


cCovering

✓


dB-Tree

✖


View Answer Covering

In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.


aClustered

✖


bColumn store

✓


cNon clustered

✖


dRow store

✖


View Answer Column store

If an index is _________________ the metadata and statistics continue to exists


aDisabling

✓


bDropping

✖


cAltering

✖


dBoth Disabling and Dropping

✖


View Answer Disabling

What are composite indexes?


aAre those which are composed by database for its internal use

✖


bA composite index is a combination of index on 2 or more columns

✓


cComposite index can never be created

✖


dNone of the mentioned

✖



Does index take space in the disk?


aIt stores memory as and when required

✖


bYes, Indexes are stored on disk

✓


cIndexes are never stored on disk

✖


dIndexes take no space

✖



What is true about indexes?


aIndexes enhance the performance even if the table is updated frequently

✖


bIt makes harder for sql server engines to work to work on index which have large keys

✓


cIt doesn’t make harder for sql server engines to work to work on index which have large keys

✖


dNone of the mentioned

✖



Goto Page No.

Page 42 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