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