Database Management Systems Mcqs

Page No. 95

A database management system might consist of application programs and a software package called


aFORTRAN


bAUTOFLOW


cBPL


dTOTAL


View Answer BPL

The language used in application programs to request data from the DBMS is referred to as the


aDML


bDDL


cquery language


dNone of the above


View Answer DML

In SQL, the ALTER TABLESPACE command is used


ato add/rename data files


bto change storage characteristics


cto begin/end a backup


dAll of the above


View Answer All of the above

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?


aDEFINE TABLE


bMODIFY TABLE


cALTER TABLE


dAll of the above


View Answer ALTER TABLE

Which command(s) is(are) used to redefine a column of the table in SQL ?


aALTER TABLE


bDEFINE TABLE


cMODIFY TABLE


dAll of the above


View Answer ALTER TABLE

A _____ means that one record in a particular record type may be related to more than one record of another record type.


aOne-to-one relationship


bOne-to-many relationship


cMany-to-one relationship


dMany-to many relationship



Internal auditors should review data system design before they are


adeveloped


bimplemented


cmodified


dAll of the above


View Answer All of the above

Which of the following command(s) is(are) used to recompile a stored procedure in SQL?


aCOMPILE PROCEDURE


bALTER PROCEDURE


cMODIFY PROCEDURE id) All of the above


dNone of the above


View Answer ALTER PROCEDURE

In a large DBMS


aeach user can "see" only a small part of the entire database


beach user can access every sub¬schema


ceach subschema contains every field in the logical schema


dAll of the above



What name is given to the collection of facts, items of information or data which are related in some way?


aDatabase


bDirectory information


cInformation tree


dInformation provider


View Answer Database

Goto Page No.

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