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