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