Relational Database Management System Mcqs

Page No. 37

The lowest level operator to access data in query processing is _______


aFile scan

✓


b File manipulation

✖


cFile handling

✖


dFile organization

✖


View Answer File scan

A sequence of primitive operations that can be used to evaluate a query are called as __________


aQuery evaluation algebra

✖


bQuery evaluation plan

✓


c Query evaluation primitive

✖


dQuery evaluation engine

✖


View Answer Query evaluation plan

A relational algebra operation annotated with instructions on how to evaluate it is called _______


aEvaluation algebra

✖


bEvaluation plan

✖


c Evaluation primitive

✓


d Evaluation engine

✖



Which of the following are steps in query processing?


aParsing and translation

✖


bOptimization

✖


c Evaluation

✖


d All of the mentioned

✓



State true or false: The aggregation functions can be implemented in the same way as that of duplicate elimination.


aTrue

✖


bFalse

✖


ceither true of false

✖


dnone of these

✖


View Answer True

Which of the following joins preserves the tuples of the relation on the left side of the operator?


aLeft outer join

✓


bNatural join

✖


cRight outer join

✖


dNone of the mentioned

✖


View Answer Left outer join

Which of the following is not a set operation


aUnion

✖


bIntersection

✖


cAnd operation

✓


d Set difference

✖


View Answer And operation

Overflow resolution is performed when,


aA hash index overflow is detected

✓


bExtra hash indices are to be added

✖


c When the number of partitions are to be increased

✖


dNone of the mentioned

✖



The splitting of input until each partition of the build input fits the memory is called as ______


aTemporary partitioning

✖


bBlock partitioning

✖


c Recursive partitioning

✓


dByte partitioning

✖



The ___________ merges the sorted relation with leaf entries of the secondary B+ tree index.


aMerge join algorithm

✖


bHybrid merge join algorithm

✓


cHash join algorithm

✖


d Hybrid Hash join algorithm

✖



Goto Page No.

Page 37 of 54

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