Relational Database Management System Mcqs

Page No. 3

While operating with strings, what does “_ _ _%” match with?


aA string of three letters

✖


bA string of at least three letters

✓


cA string of three words

✖


dA string of at least three words

✖


View Answer A string of at least three letters

Which keyword is used to rename a relation in a query?


arename

✖


b as

✓


c is

✖


d to

✖


View Answer as

Observe the following query and choose the correct option. select name, ID from student natural join department natural join section


aThe query is syntactically wrong because there is no where clause

✖


bThe query is syntactically wrong because there are more than one attributes in the select clause

✖


che query is syntactically wrong because more than one relations are included in the natural join operation

✖


dThe query is correct

✓


View Answer The query is correct

What does the natural join operation do?


a It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations

✓


bIt considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations

✖


cIt considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations

✖


dNone of the mentioned

✖


View Answer It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations

State true or false: Multiple conditions in the where clause are separated by a “,”


aTrue

✖


b False

✓


ceither true and false

✖


dnone of these

✖


View Answer False

If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be?


a The natural join of both the relations

✖


bThe left outer join of both the relations

✖


c A syntactical error

✖


d The Cartesian product of both the relations

✓


View Answer The Cartesian product of both the relations

What does the following query do? select name, ID, branch from student, department where student.branch = department.branch;


aIt gives all values of name, ID, branch from both the relations only if all those attributes are present in both

✖


bIt gives all values of name, ID, branch from their respective relations

✖


cIt gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

✓


d It gives the values of name, ID, branch from their respective relations where all the values are matching with each other

✖


View Answer It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

What does the above query do?


aIt gives all the tuples having a distinct dept_name

✖


b It gives the dept_name attribute values of all tuples without repetition

✓


c It gives all the dept_name attribute of all the tuples

✖


dIt gives all the tuples having a null value under the dept_name attribute

✖


View Answer It gives the dept_name attribute values of all tuples without repetition

The where clause is a predicate involving attributes of the relation in the ______ clause.


a select

✖


bfrom

✓


c with

✖


dnone of the mentioned

✖


View Answer from

Which of the following logical connectives is not included in SQL?


aand

✖


b or

✖


cnor

✖


dnot

✓


View Answer not

Goto Page No.

Page 3 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!"

⚛ Agriculture MCQs
⚛ Artificial Intelligence MCQs
⚛ Accounting MCQs
⚛ Auditing MCQs
⚛ Biology MCQs
⚛ Biochemistry MCQs
⚛ Bioinformatics MCQs
⚛ Chemistry MCQs
⚛ Chemical Engineering MCQs
⚛ Civil Engineering MCQs
⚛ Computer MCQs
⚛ Computer Fundamentals MCQs
⚛ Computer Networks MCQs
⚛ Computer Organization and Architecture MCQs
⚛ Current Affairs (Pakistan)
⚛ Current Affairs (World)
⚛ Dental Materials MCQs
⚛ Database Management Systems MCQs
⚛ Data Structures and Algorithms-I MCQs
⚛ Data Structures and Algorithms-II MCQs
⚛ English MCQs
⚛ English Literature MCQs
⚛ Economics MCQs
⚛ Everyday Science MCQs
⚛ Electrical Engineering MCQs
⚛ Finance MCQs
⚛ General Knowledge MCQs
⚛ General Anatomy MCQs
⚛ Human Resource Managemeent(HRM) MCQs
⚛ Islamic Study MCQs
⚛ Judiciary And Law MCQs
⚛ Mathematics MCQs
⚛ Medical MCQs
⚛ Microbiology MCQs
⚛ Oral Anatomy MCQs
⚛ Oral Histology MCQs
⚛ Oral Pathology and Medicine MCQs
⚛ Object Oriented Programming MCQs
⚛ Operating System MCQs
⚛ Pakistan Study MCQs
⚛ Pedagogy MCQs
⚛ Physics MCQs
⚛ Pathology MCQs
⚛ Pharmacology MCQs
⚛ Physiology MCQs
⚛ Relational Database Management System MCQs
⚛ Software Engineering MCQs
⚛ Sociology MCQs
⚛ Statistics MCQs
⚛ Software Architecture & Design MCQs
⚛ Urdu 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.

Popular Posts

Software Engineering MCQs
Computer Networks MCQs
Computer MCQs
English Literature MCQs

Support

Terms & Conditions
Privacy Policy
Contact Us
About

Copyright © 2024, Designed & Developed by BolPakistan