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