Database Management Systems Mcqs

Page No. 80

_______ produces the relation that has attributes of R1 and R2


aCartesian product


bDifference


cIntersection


dProduct


View Answer Cartesian product

Key to represent relationship between tables is called


aPrimary key


bSecondary Key


cForeign Key


dNone of these


View Answer Foreign Key

Data independence means


adata is defined separately and not included in programs.


bprograms are not dependent on the physical attributes of data.


cprograms are not dependent on the logical attributes of data


dboth (B) and (C).


View Answer both (B) and (C).

Transaction processing is associated with everything below except


aproducing detail, summary, or exception reports.


brecording a business activity.


cconfirming an action or triggering a response.


dmaintaining data.



A DBMS query language is designed to


asupport end users who use English-like commands


bsupport in the development of complex applications software.


cspecify the structure of a database.


dall of the above.


View Answer all of the above.

An advantage of the database management approach is


adata is dependent on programs.


bdata redundancy increases.


cdata is integrated and can be accessed by multiple programs


dNone



Which one of the following statements is false?


aThe data dictionary is normally maintained by the database administrator.


bData elements in the database can be modified by changing the data dictionary.


cThe data dictionary contains the name and description of each data element.


dThe data dictionary is a tool used exclusively by the database administrator.



A table joined with itself is called


aJoin


bSelf Join


cOuter Join


dEqui Join


View Answer Self Join

The method of access which uses key transformation is known as


aDirect


bHash


cRandom


dSequential


View Answer Hash

_____________ function divides one numeric expression by another and returns the remainder


aPOWER


bMOD


cROUND


dREMAINDER


View Answer MOD

Goto Page No.

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