Database Management Systems Mcqs

Page No. 53

The time factor when determining the efficiency of an algorithm is measured by


aCounting microseconds


bCounting the number of key operations


cCounting the number of statements


dCounting the kilobytes of algorithm



Two main measures for the efficiency of an algorithm are


aProcessor and memory


bComplexity and capacity


cTime and space


dData and space


View Answer Time and space

Conjunctive selection using one index. This is


aA10


bA7


cA9


dA6


View Answer A7

If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by


aA10


bA7


cA9


dA6


View Answer A10

The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition.


aA2


bA4


cA9


dA6


View Answer A9

The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving <,≤,≥, or > is


aA2


bA4


cA5


dA6


View Answer A6

The strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is


aA2


bA4


cA5


dA6


View Answer A4

Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.


aA2


bA4


cA5


dA6


View Answer A2

Search algorithms that use an index are referred to as


aIndex Search


bLinear search


cFile scan


dAccess paths


View Answer Index Search

Index structures are referred to as __________ since they provide a path through which data can be located and accessed.


aIndex Search


bLinear search


cFile scan


dAccess paths


View Answer Access paths

Goto Page No.

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