Relational Database Management System Mcqs

Page No. 10

State true or false: Oracle does not support complex check conditions


a True


bFalse


ceither true and false


dnone of the mentioned


View Answer True

________ is a predicate that we expect the database to always satisfy


aAssertion


bReason


cMandate


dVerify


View Answer Assertion

Referential integrity constraints are also called as _________


aFunctional dependencies


bSubset dependencies


cSuperset dependencies


dPrimary dependencies


View Answer Subset dependencies

What does the following condition do? check( name in( ‘Ryan’, ‘Cristiano’, ‘Leo’))


aThe condition checks whether the name attribute includes the three mentioned names


bThe condition allows the name attribute to possess only the three mentioned names


cThe condition checks whether the given names are sub-strings in at least one of the values


dNone of the mentioned



What is the functions of on delete cascade?


aIt is used to delete a tuple in a table


bIt is used to specify the precise attribute that needs to be deleted in a single relation.


cIt is used to preserve referential integrity in a relation


dIt is used to execute sub-queries in the from clause.



What is the function of the unique constraint?


aIt ensures that no two values under an attribute are identical


bIt ensures that all the attributes are perfectly unique in their data type


cIt ensures that all the relations in the database have a unique set of attributes


dIt does not have any function in SQL



What is the function of the not null constraint?


aIt prevents illegal data from being entered into the database


bIt ensures that data is entered into the database


cIt ensures that the data entered is unique


dNone of the mentioned



revoke select on takes from amit; What does the above query perform?


aIt revokes all authorizations from amit


bIt revokes select authorization from amit


cIt revokes takes authorization from amit


dIt gives an error



The _________ statement is used in SQL to confer authorization.


agrant


bconfer


cimplement


dpermit


View Answer grant

Which of the following is a privilege in SQL standard?


aselect


binsert


cupdate


dAll of the mentioned


View Answer All of the mentioned

Goto Page No.

Page 10 of 54

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