Database Management Systems Mcqs

Page No. 98

A file produced by a spreadsheet


ais generally stored on disk in an ASCII text format


bcan be used as it by the DBMS


ccan be used for graphic


dAll of the above



A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?


aSpecialized file


bLog file


cMaster file


dUpdate file


View Answer Master file

Which command is used to remove a table from the database in SQL?


aDELETE TABLE


bDROP TABLE


cERASE TABLE


dUNATTACH TABLE


View Answer DROP TABLE

Which of the following is not a relational database?


adBASE IV


b4th Dimension


cFoxPro


dReflex


View Answer Reflex

A network schema


arestricts the structure to a one-to-many relationship


bpermits many-to-many relation¬ships


cstores data in tables


dAll of the above



When using a database management system, the first thing that you must do is to


acreate a database file


bactivate file editor


cload the software into your micro computer


dkeep a floppy disk in readiness



Which two files are used during operation of the DBMS?


aquery language and utilities


bdata manipulation language and query language


cdata dictionary and transaction log


ddata dictionary and query language



In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.


aNetwork database


bRelational database


cDistributed database


dHierarchical database


View Answer Hierarchical database

Sophisticated report generators can


aprint row-oriented reports


bperform arithmetic operations


cselectively retrieve and print portions of a list


dAll of the above


View Answer All of the above

To have a file hold a list, it is necessary to


aidentify the records in the list


bidentify the name, width and type of the fields of each record.


cdecide which fields will be used as sort or index keys


dAll of the above


View Answer All of the above

Goto Page No.

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