Database Management Systems Mcqs

Page No. 19

Not applicable condition can be represented in relation entry as


aNA


b0


cNULL


dBlank Space


View Answer NULL

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is


aSingle valued


bMulti valued


cComposite


dDerived


View Answer Derived

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called


aSimple attribute


bComposite attribute


cMultivalued attribute


dDerived attribute


View Answer Composite attribute

The function that an entity plays in a relationship is called that entity’s _____________


aParticipation


bPosition


cRole


dInstance


View Answer Role

____________ is preferred method for enforcing data integrity


aConstraints


bStored Procedure


cTriggers


dCursors


View Answer Constraints

Drop Table cannot be used to drop a table referenced by a _________ constraint.


aLocal Key


bPrimary Key


cComposite Key


dForeign Key


View Answer Foreign Key

Which one of the following uniquely identifies the elements in the relation?


aSecondary Key


bPrimary key


cForeign key


dComposite key


View Answer Primary key

______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.


aEntity Integrity Constraints


bReferential Integrity Constraints


cDomain Integrity Constraints


dDomain Constraints



Which of the following can be addressed by enforcing a referential integrity constraint?


aAll phone numbers must include the area code


bCertain fields are required (such as the email address, or phone number) before the record is accepted


cInformation on the customer must be known before anything can be sold to that customer


dThen entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)



Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:


aAttributes


bData integrity constraints


cMethod constraints


dReferential integrity constraints



Goto Page No.

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