Database Management Systems Mcqs

Page No. 100

In SQL, which command(s) is(are) used to enable/disable a database trigger?


aMODIFY USER


bCHANGE USER


cALTER TRIGGER


dAll of the above


View Answer ALTER TRIGGER

The data dictionary tells the DBMS


awhat files are in the database


bwhat attribute are possessed by the data


cwhat these files contain


dAll of the above


View Answer All of the above

Sort/report generators


aare faster than index/report generators


brequire more disk space than index/report generators


cboth (a) and (b)


dNone of the above



Periodically adding, changing and deleting file records is called file


aUpdating


bupgrading


crestructuring


drenewing


View Answer Updating

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?


aZIP


bPACK


cCOMMIT


dSAVE


View Answer COMMIT

Data item characteristics that are important in data management include


apunctuation


blanguage


cspelling


dwidth


View Answer width

What is the language used by most of the DBMSs for helping their users to access data?


aHigh level language


bQuery language


cSQL


d4GL


View Answer Query language

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.


aDelete


bUpdate


cSort key


dIndex


View Answer Update

Each of data files has a _____ that describe the way the data is stored in the file.


aFile structure


bRecords


cFields


dDatabase


View Answer File structure

Primitive operations common to all record management systems include


aPrint


bSort


cLook-up


dAll of the above


View Answer Look-up

Goto Page No.

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