Relational Database Management System Mcqs

Page No. 4

Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?


a all


b not unique


c notnull


dinclude


View Answer all

. Which of the following syntax of the basic query is correct?


aselect from


b select from


cselect from


d select from


View Answer select from

Which of the following correctly describes the between predicate in the where clause?


aIt is used to check whether a value is in between two specified values


bIt is used to check whether a value is exactly in the center of the relation alphabetically


c It is used to check whether a value is in between any two other values in the database


d None of the mentioned



What will be the result of the following query?


aAll the values of the studentid for which section is c and roll < 10


b All the values of the studentid for which section is c and roll > 10


cAll the values of the studentid for which section not c and roll < 10


dAll the values of the studentid for which section not c and roll > 10



Observe the following query and choose the correct option


aThe query is syntactically wrong


bThe query gives all the possible student names where a finite value exists for ID


cThe query gives the names of the students that have a null ID and it also excludes identical names


dThe query gives the student names where a finite value exists for ID and it excludes identical names



Using the _______ clause retains only one copy of identical tuples


a distinct


bis not null


cno repeat


dfrom


View Answer distinct

When does the predicate is null succeed?


aIf the value on which it is applied is finite


b If the value on which it is applied is invalid


cIf the value on which it is applied is blank


dIf the value on which it is applied is more than the allowed limit



What is the function of the except operation?


a It excludes all the results present in both the queries


bIt includes the results of the second query but excludes the results of the first query


cIt includes the results of the first query but excludes the results of the second query


d It includes all the results of both queries but removes duplicates



What is the function of the intersect operation?


aIt returns the intersection of the results of the results of any two different queries


bIt returns the intersection of the results of two different queries which have the same set of attributes in the select clause


c It returns the intersection of the results of two different queries which have the same condition in the where clause


dNone of the mentioned



What is the function of the union operation?


a It combines the results of any two different queries


bIt combines the results of two different queries which have the same set of attributes in the select clause


cIt combines the results of two different queries which have the same condition in the where clause


dIt gives the Cartesian product of the results of any 2 queries



Goto Page No.

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