Database Management Systems Mcqs

Page No. 97

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be


athe pin code

✖


bthe last name

✖


ca compound key consisting of the first name and the last name

✓


dAll of the above

✖



The main idea behind computer files is that it is convenient to


aarrange them

✖


bstore information together

✓


ccreate them

✖


daccess them

✖



When you have finished entering information into a form


athe template is written to the data file

✖


bthe contents of the form are written to the data file

✓


cthe contents of the form are written to the data file

✖


dAll of the above

✖



In SQL, which command(s) is(are) used to enable/disable all triggers on a table?


aALTER TRIGGERS

✖


bALTER TABLE

✓


cMODIFY TRIGGERS IN TABLE

✖


dAll of the above

✖


View Answer ALTER TABLE

Updating a database means


arevising the file structure

✖


breorganizing the database

✖


cmodifying or adding record occurrences

✓


dAll of the above

✖



The logical data structure with a one-to-many relationship is a :


anetwork

✖


btree

✓


cchain

✖


drelational

✖


View Answer tree

The highest level in the hierarchy of data organization is called


adata bank

✖


bdatabase

✓


cdata file

✖


ddata record

✖


View Answer database

In SQL, GRANT command is used to


aallow user to access databases

✖


ballow user to create databases

✖


cgrant system privileges, roles, and object privileges to uses and roles

✓


dchoose auditing for specific SQL commands

✖



Which of the following is true of a network structure?


aIt is a physical representation of the data

✖


bIt allows a many-to-many relationship

✓


cIt is conceptually simple

✖


dIt will be the dominant data base of the future

✖



A form defines


awhere data is placed on the screen

✖


bthe width of each field

✖


cboth (a) and (b)

✓


dAll of the above

✖


View Answer both (a) and (b)

Goto Page No.

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