Relational Database Management System Mcqs

Page No. 22

State true or false: SQL specifies a way of mentioning functional dependencies


a True


bFalse


ceither true of false


dnone of these


View Answer False

Which of the following is desirable in a database design with functional dependencies?


aBCNF


bLosslessness


cDependency preservation


dAll of the mentioned


View Answer All of the mentioned

The 3NF decomposition algorithm is also called as _______


a3NF normal algorithm


b3NF synthesis algorithm


c3NF generator


dFunctional dependence algorithm



What does the BCNF decomposition algorithm do?


aStates a method to decompose a relation satisfying BCNF


bStates a method for joining two relations satisfying BCNF


c States a method to decompose a relational schema such that there are no multiple occurrences


dNone of the mentioned



To specify the foreign keys in relations referencing temporal data we need to specify _______


aThe time interval


bThe Boolean value for the working


cThe integer corresponding to the relation number


dNone of the mentioned


View Answer The time interval

Which of the following is the time of temporal data that record when a fact was recorded in a database?


aTransaction time


bValid time


cEnter time


dExit time


View Answer Transaction time

State true or false: Overlapping time intervals cannot be prevented


aTrue


bFalse


ceither true and false


dnone of these


View Answer False

Functional dependencies that have a time associated with them during which they are valid are called as________


aTimed functional dependencies


bClocked functional dependencies


cTemporal functional dependencies


dModeled functional dependencies



The value of the data at a particular time is called as?


aInstance


bPicture


cSnapshot


dNone of the mentioned


View Answer Snapshot

The data that have a time interval associated with them during which they are valid are called as ________


aimed data


bTemporal data


cModel data


dClocked data


View Answer Temporal data

Goto Page No.

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