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