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