Database Management Systems Mcqs

Page No. 26

_____________ can help us detect poor E-R design.


aDatabase Design Process

✖


bE-R Design Process

✖


cRelational scheme

✖


dFunctional dependencies

✓



In 2NF


aNo functional dependencies (FDs) exist

✖


bNo multivalued dependencies (MVDs) exist

✖


cNo partial FDs exist

✓


dNo partial MVDs exist

✖


View Answer No partial FDs exist

Fifth Normal form is concerned with


aFunctional dependency

✖


bMultivalued dependency

✖


cJoin dependency

✓


dDomain-key

✖


View Answer Join dependency

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.


aA many-to-many relationship set

✖


bA multivalued attribute of an entity set

✓


cA one-to-many relationship set

✖


dNone of the mentioned

✖



If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.


aA many-to-many relationship set

✖


bA multivalued attribute of an entity set

✖


cA one-to-many relationship set

✖


dBoth A many-to-many relationship set and A multivalued attribute of an entity set

✓



Which forms has a relation that possesses data about an individual entity?


a2NF

✖


b3NF

✖


c4NF

✓


d5NF

✖


View Answer 4NF

Which of the normal form is based on multivalued dependencies?


aFirst

✖


bSecond

✖


cThird

✖


dFourth

✓


View Answer Fourth

The main task carried out in the __________ is to remove repeating attributes to separate tables.


aFirst Normal Form

✓


bSecond Normal Form

✖


cThird Normal Form

✖


dFourth Normal Form

✖


View Answer First Normal Form

Which of the following is a tuple-generating dependencies?


aFunctional dependency

✖


bEquality-generating dependencies

✖


cMultivalued dependencies

✓


dNon-functional dependency

✖



The normal form which satisfies multivalued dependencies and which is in BCNF is


a4 NF

✓


b3 NF

✖


c2 NF

✖


dAll of the mentioned

✖


View Answer 4 NF

Goto Page No.

Page 26 of 101

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