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