Relational Database Management System Mcqs

Page No. 16

An entity set that has a primary key is called as ___________


aStrong entity set


bWeak entity set


c Complete entity set


d Complete entity set


View Answer Strong entity set

How is the discriminator of a weak entity set specified?


aUsing a solid line


bCircling it


cUsing a dashed line


dDrawing a square around it


View Answer Using a dashed line

How are roles specified in an ER diagram


aBy labelling the rectangles


bBy labelling the diamonds


cRoles cannot be specified in an ER diagram


dBy labelling the lines



What does a directed line ( → ) from a relationship set to two entity sets mean?


a One-one


b Many-one


cMany-many


dOne-many


View Answer One-one

What do double diamonds represent in an ER diagram


aThey link entity sets to relationship sets


bTotal participation of an entity in a relationship set


c Relationship sets linked to weak entity sets


dNone of the mentioned



Which of the following symbols represent relationship sets in an ER diagram


aDivided rectangles


b Diamonds


cLines


dUndivided rectangles


View Answer Diamonds

Which of the following symbols represent entity sets in an ER diagram?


aDivided rectangles


bDiamonds


cLines


dUndivided rectangles


View Answer Divided rectangles

Which of the following can affect the placement of the relationship attributes?


aAlphabetical order


bThe data in the attribute


cCardinality ratio


d None of the mentioned


View Answer Cardinality ratio

Statement 1: We can create foreign key constraints on relational schema derived from ER diagram Statement 2: Relational schema cannot be derived from an ER diagram


aBoth the statements are true


bBoth the statements are false


cStatement 1 is true and Statement 2 is false


dStatement 2 is true and statement 1 is false



State true or false: The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.


aTrue


b False


ceither true of false


dnone of these


View Answer True

Goto Page No.

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