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