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