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