Database Management Systems Mcqs

Page No. 9

What type of join is needed when you wish to include rows that do not have matching values?


aEqui-join

✖


bNatural join

✖


cOuter join

✓


dAll of the mentioned

✖


View Answer Outer join

Which of the join operations do not preserve non matched tuples?


aLeft outer join

✖


bRight outer join

✖


cInner join

✓


dNatural join

✖


View Answer Inner join

The____condition allows a general predicate over the relations being joined.


aOn

✓


bUsing

✖


cSet

✖


dWhere

✖


View Answer On

CREATE VIEW faculty AS SELECT ID, name, dept name FROM instructor;
Find the error in this query.


aInstructor

✖


bSelect

✖


cView …as

✖


dNone of the mentioned

✓


View Answer None of the mentioned

Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?


aWith

✖


bCheck

✖


cWith check

✓


dAll of the mentioned

✖


View Answer With check

SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?


aThe from clause has only one database relation

✖


bThe query does not have a group by or having clause

✖


cThe select clause contains only attribute names of the relation and does not have any expressions, aggregates, or distinct specification

✓


dAll of the mentioned

✖



Updating the value of the view


aWill affect the relation from which it is defined

✓


bWill not change the view definition

✖


cWill not affect the relation from which it is defined

✖


dCannot determine

✖



Materialized views make sure that


aView definition is kept stable

✖


bView definition is kept up-to-date

✓


cView definition is verified for error

✖


dView is deleted after specified time

✖



SELECT course_id
FROM physics_fall_2009
WHERE building= ’Watson’;
Here the tuples are selected from the view. Which one denotes the view.


aCourse_id

✖


bWatson

✖


cBuilding

✓


dphysics_fall_2009

✖


View Answer Building

Which of the following is the syntax for views where v is view name?


aCreate view v as “query name”;

✖


bCreate “query expression” as view;

✖


cCreate view v as “query expression”;

✓


dCreate view “query expression”;

✖



Goto Page No.

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