Relational Database Management System Mcqs

Page No. 21

State true or false: Armstrong’s axioms allow us to generate all F+ for any given F


aTrue


bFalse


ceither true of false


dnone of these


View Answer True

If a functional dependency is reflexive, B is a subset of A and A is the set of attributes, then


aB→A holds


b A→B holds


cAB→C holds


d None of the mentioned


View Answer A→B holds

If F is a set of functional dependencies, then the closure of F is denoted by?


aF*


bFo


c F+


dF


View Answer F+

A functional dependency f on R is _______ by a set of functional dependencies F on r if every instance of r(R) that satisfies f also satisfies F.


aLogically Defined


b Logically Derived


cLogically implied


dNone of the mentioned


View Answer Logically implied

Which of the following normal forms does not exist?


aBCNF


b PJNF


c 5NF


dNone of the mentioned


View Answer None of the mentioned

State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency.


a1


b2


c3


d4


View Answer 4

The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies


aStar


b Closure


cDerivation


dEvolution


View Answer Closure

Functional dependencies are sometimes referred to as ________


aEquality generating dependencies


bTuple generating dependencies


cMulti-purpose dependencies


dNone of the mentioned



Multi valued dependencies are also called as __________


aEquality generating dependencies


b Tuple generating dependencies


c Multi-purpose dependencies


dNone of the mentioned



State true or false: Most current database systems do not support constraints on materialized view


aTrue


b False


ceither true of false


dnone of these


View Answer True

Goto Page No.

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