Database Management Systems Mcqs

Page No. 89

A data dictionary is a special file that contains


athe names of all fields in all files


bthe data types of all fields in all files


cthe widths of all fields in all files


dAll of the above


View Answer All of the above

If a piece of data is stored in two places in the database, then


astorage space is wasted


bchanging the data is one spot will cause data inconsistency


cit can be more easily accessed


dboth (a) and (b)


View Answer both (a) and (b)

A list in alphabetical order


ais in descending order


bis in ascending order


cis the result of a sort operation


dboth (b) and (c)


View Answer both (b) and (c)

In SQL, the _____ command is used to recompile a view


aCOMPILE VIEW


bDEFINE VIEW


cCREATE VIEW


dALTER VIEW


View Answer ALTER VIEW

A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.


aOne-to-one relationship


bOne-to-many relationship


cMany-to-one relationship


dMany-to-many relationship



Related fields in a data base are grouped to form


adata file


bdata record


cmenu


dbank


View Answer data record

Versatile report generators can provide


aColumnar totals


bSubtotals


cCalculations


dAll of the above


View Answer All of the above

The activity of a file


ais a low percentages of number of records added or deleted from a file


bif high, reduces processing efficiency for sequential and non-sequential files


cis a measure of the percentage of existing records updated during a run


drefers to how closely the files fits into the allocated



Data items grouped together for storage purposes are called a


arecord


btitle


clist


dstring


View Answer record

Which of the following is a type of DBMS software?


adatabase manipulation language


bquery language


cutilities


dreport writer



Goto Page No.

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