Database Management Systems Mcqs

Page No. 47

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.


aClustered index


bStructured index


cUnstructured index


dNonclustered index


View Answer Clustered index

In ________________ of Oracle, the database administrator creates a user account in the database for each user who needs access.


aDatabase Authentication


bOperating System Authentication


cInternal Authentication


dExternal Authentication



In _______________ the management of the password for the account can be handled outside of oracle such as operating system.


aDatabase Authentication


bOperating System Authentication


cInternal Authentication


dExternal Authentication



_________________ is a sequence of zero or more characters enclosed by single quotes.


aIntegers literal


bString literal


cString units


dString label


View Answer String literal

If no header is specified, the block is said to be an _______________ PL/SQL block.


aStrong


bWeak


cEmpty


dAnonymous


View Answer Anonymous

A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier.


aComments


bLiterals


cDelimiters


dIdentifiers


View Answer Literals

We use ______________ name PL/SQL program objects and units.


aLexical Units


bLiterals


cDelimiters


dIdentifiers


View Answer Identifiers

A line of PL/SQL text contains groups of characters known as


aLexical Units


bLiterals


cTextual Units


dIdentifiers


View Answer Lexical Units

_______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer.


aSQL Server


bMy SQL


cOracle


dSQL Lite


View Answer Oracle

___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.


aPL/SQL


bSQL


cAdvanced SQL


dPQL


View Answer PL/SQL

Goto Page No.

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