Database Management Systems Mcqs

Page No. 12

Values of one type can be converted to another domain using which of the following?


aCast


bDrop type


cAlter type


dConvert


View Answer Cast

The user defined data type can be created using


aCreate datatype


bCreate data


cCreate definetype


dCreate type


View Answer Create type

Which of the following is used to store movie and image files?


aClob


bBlob


cBinary


dImage


View Answer Blob

Create index studentID_index on student(ID);
Here which one denotes the relation for which index is created?


aStudentID_index


bID


cStudentID


dStudent


View Answer Student

A ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.


aIndex


bReference


cAssertion


dTimestamp


View Answer Index

Dates must be specified in the format


amm/dd/yy


byyyy/mm/dd


cdd/mm/yy


dyy/dd/mm


View Answer yyyy/mm/dd

The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation


aThe privilege must be granted only by roles


bThe privilege is granted by roles and users


cThe user role cannot be removed once given


dBy restricting the user access to the roles



Which of the following is used to avoid cascading of authorizations from the user?


aGranted by current role


bRevoke select on department from Amit, Satoshi restrict;


cRevoke grant option for select on department from Amit;


dRevoke select on department from Amit, Satoshi cascade;



In authorization graph, if DBA provides authorization to u1 which intern gives to u2 which of the following is correct?


aIf DBA revokes authorization from u1 then u2 authorization is also revoked


bIf u1 revokes authorization from u2 then u2 authorization is revoked


cIf DBA & u1 revokes authorization from u1 then u2 authorization is also revoked


dIf u2 revokes authorization then u1 authorization is revoked



If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.


aWith grant


bGrant user


cGrant pass privilege


dWith grant option


View Answer With grant option

Goto Page No.

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