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