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