Relational Database Management System Mcqs

Page No. 12

State true or false: Recursive queries are permitted in SQL


aTrue


bFalse


ceither true and false


dnone of the mentioned


View Answer True

A _________ is a statement that the system executes whenever a database is modified


aTrigger


bFunction


cPackage


dProtocol


View Answer Trigger

The part of SQL that deals with the SQL supports constructs is called as _______


aPersistent construct dealer


bPersistent storage module


c Persistent supports center


dPrimary storage medium



Which of the following are not a part of PL/SQL


aTriggers


bPackages


cFunctions


dNone of the mentioned


View Answer None of the mentioned

State true or false: Developers cannot write their own functions into SQL


aTrue


b False


ceither true and false


dnone of these


View Answer False

What is the full form of JDBC?


aJava Database Connectivity


bJava Database Co-Operation


c JSP Database Committee


dJava Database Creation



Which of the following is/are a function of dynamic SQL?


aAllowing a program to construct an SQL query in a character string


bSubmitting the query


c Retrieving the result into the program variables a tuple at a time


dAll of the mentioned


View Answer All of the mentioned

State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.


aTrue


bFalse


ceither true of false


dnone of these


View Answer False

The operation of moving from coarser granular data to finer granular data is called _______


aReduction


bIncrement


cRoll back


dDrill down


View Answer Drill down

State true or false: OLAP systems can be implemented as client-server systems


aTrue


b False


ceither true of false


dnone of these


View Answer True

Goto Page No.

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