Database Management Systems Mcqs

Page No. 27

A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:
F1->F3
F2->F4
(F1,F2)->F5
in terms of normalization, this table is in


a1NF


b2NF


c3NF


dNone of the mentioned


View Answer 1NF

The functional dependency can be tested easily on the materialized view, using the constraints ____________.


aPrimary key


bNull


cUnique


dBoth Null and Unique


View Answer Both Null and Unique

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is


aBCNF algorithm


b2NF algorithm


c3NF synthesis algorithm


d1NF algorithm



R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?


aA->B, B->CD


bA->B, B->C, C->D


cAB->C, C->AD


dA->BCD


View Answer A->BCD

What are the desirable properties of a decomposition


aPartition constraint


bDependency preservation


cRedundancy


dSecurity



A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.


a2NF


b3NF


cBCNF


d1NF


View Answer 3NF

Suppose now that R(A,B) and S(A,B) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query:
R intersect S;
Then which of the following is the most restrictive, correct condition on the value of m?


am = min(r,s)


b0 <= m <= r + s


cmin(r,s) <= m <= max(r,s)


d0 <= m <= min(r,s)


View Answer 0 <= m <= min(r,s)

Consider a relation R(A,B,C,D,E) with the following functional dependencies:
ABC -> DE
and D -> AB
The number of superkeys of R is:


a2


b7


c10


d12


View Answer 10

There are two functional dependencies with the same set of attributes on the left side of the arrow:
A->BC
A->B
This can be combined as


aA->BC


bA->B


cB->C


dNone of the mentioned


View Answer A->BC

Which of the following is not Armstrong’s Axiom?


aReflexivity rule


bTransitivity rule


cPseudotransitivity rule


dAugmentation rule



Goto Page No.

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