Oracle DBMS PL/SQL
Description: Online Test for Oracle,DBMS, PL/SQL, Structured Query Language, Trigger, Packages, Users, Permissions and other software Technology tests and Notes | |
Number of Questions: 25 | |
Created by: Jatin Goyal | |
Tags: Oracle DBMS PL/SQL Structured Query language Triggers Packages Users Permissions Databases Programming OOPs |
The total main features of object oriented programming are
The wrapping of data and functions into a single unit is known as
_______ commands can be used in PL/SQL blocks.
_______ is a pointer to an object and may be used within a SQL statement as an operator.
PL/SQL supports all _____ statements.
_______ engine executes only the procedural statement.
PL/SQL text can contain group of characters known as _______ units.
Variables and constants should be declared in the _______ part of PL/SQL block.
______ is available only with SQL statement.
The ability of an object to take more than one form is known as
DBMS stands for
_______ statement allows us to complete a loop if further processing is undesirable or impossible.
The object oriented programming is a way to organize data and code within
_______ statement can be used when we want to select from several mutually exclusive alternatives.
_______ statement allows us to branch to a label unconditionally.
Loops can be broadly classified into _____ types.
Which of the following statements is used to execute sequence of statements multiple times?
PL/SQL data types can be classified into _______ data types.
Object is a _______ software component.
To check the source code of object types, use the _____ data dictionary view.
______condition in PL/SQL is termed as an exception.
User-defined exceptions should be declared in the ________ part of the PL/SQL block.
________ allows designing of new objects that inherit the functionality of objects that are already created.
To see the various types created, use the ______ data dictionary view.
There are _____ types of exceptions in PL/SQL.