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