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