Database Management Systems Mcqs

Page No. 51

The results of each intermediate operation are created and then are used for evaluation of the next-level operations. This is called


aMaterialized evaluation


bExpression evaluation


cTree evaluation


dTree materialization



Pictorial representation of an expression is called


aExpression tree


bOperator tree


cExpression flow


dExpression chart


View Answer Operator tree

Which view that contains more than one table in the top-level FROM clause of the SELECT statement:


aJoin view


bDatable join view


cUpdatable join view


dAll of the mentioned


View Answer Updatable join view

Which operation are allowed in a join view:


aUPDATE


bINSERT


cDELETE


dAll of the mentioned


View Answer All of the mentioned

Which join refers to join records from the write table that have no matching key in the left table are include in the result set:


aLeft outer join


bRight outer join


cFull outer join


dHalf outer join


View Answer Right outer join

Which is a join condition contains an equality operator:


aEquijoins


bCartesian


cBoth Equijoins and Cartesian


dNone of the mentioned


View Answer Equijoins

Which product is returned in a join query have no join condition:


aEquijoins


bCartesian


cBoth Equijoins and Cartesian


dNone of the mentioned


View Answer Cartesian

Which are the join types in join condition:


aCross join


bNatural join


cJoin with USING clause


dAll of the mentioned


View Answer All of the mentioned

How many join types in join condition:


a2


b3


c4


d5


View Answer 5

Which oracle is the join condition is specified using the WHERE clause:


aOracle 9i


bOracle 8i


cPre-oracle 9i


dPre-oracle 8i


View Answer Pre-oracle 9i

Goto Page No.

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