Database Management Systems Mcqs

Page No. 76

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________


aReferential relation


bReferencing relation


cReferenced relation


dReferred relation


View Answer Referenced relation

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.


aCandidate


bPrimary


cSuper


dSub


View Answer Primary

Which one of the following cannot be taken as a primary key?


aId


bRegister number


cDept_id


dStreet


View Answer Street

Which one of the following attribute can be taken as a primary key?


aName


bStreet


cId


dDepartment


View Answer Id

A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.


aRows


bKey


cAttribute


dFields


View Answer Key

The subset of a super key is a candidate key under what condition?


aNo proper subset is a super key


bAll subsets are super keys


cSubset is a super key


dEach subset is a super key



Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?


aNAME


bID


cCITY


dCITY, ID


View Answer ID

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?


aCandidate key


bSub key


cSuper key


dForeign key


View Answer Super key

The tuples of the relations can be of ________ order.


aAny


bSame


cSorted


dConstant


View Answer Any

A domain is atomic if elements of the domain are considered to be ____________ units.


aDifferent


bIndivisible


cConstant


dDivisible


View Answer Indivisible

Goto Page No.

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