Database Management Systems Mcqs

Page No. 44

Bitmap indices are a specialized type of index designed for easy querying on ___________


aBit values

✖


bBinary digits

✖


cMultiple keys

✓


dSingle keys

✖


View Answer Multiple keys

The purpose of an N-Ary association is:


aTo capture a parent-child relationship

✖


bTo deal with one to many relationships

✖


cTo deal with relationships that involve more than two tables

✓


dTo represent an inheritance relationship

✖



The association role defines:


aHow tables are related in the database

✓


bThe relationship between the class diagram and the tables in the database

✖


cThe tables that each attribute is contained

✖


dWhich attribute is the table’s primary key

✖



The database design that consists of multiple tables that are linked together through matching data stored in each table is called


aHierarchical database

✖


bNetwork database

✖


cObject oriented database

✖


dRelational database

✓


View Answer Relational database

The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?


aHierarchical

✓


bNetwork

✖


cObject oriented

✖


dRelational

✖


View Answer Hierarchical

In the client / server model, the database:


aIs downloaded to the client upon request

✖


bIs shared by both the client and server

✖


cResides on the client side

✖


dResides on the server side

✓



The separation of the data definition from the program is known as:


aData dictionary

✖


bData independence

✓


cData integrity

✖


dReferential integrity

✖


View Answer Data independence

The property (or set of properties) that uniquely defines each row in a table is called the:


aIdentifier

✖


bIndex

✖


cPrimary key

✓


dSymmetric key

✖


View Answer Primary key

What is the main limitation of Hierarchical Databases?


aLimited capacity (unable to hold much data)

✖


bLimited flexibility in accessing data

✓


cOverhead associated with maintaining indexes

✖


dThe performance of the database is poor

✖



A hash function must meet ________ criteria.


aTwo

✖


bThree

✓


cFour

✖


dNone of the mentioned

✖


View Answer Three

Goto Page No.

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