Google News
logo
PL/SQL - Quiz(MCQ)
A)
Build Structured Language
B)
Brick Structured Language
C)
Block Structured Language
D)
Banner Structured Language

Correct Answer : Option (C) :   Block Structured Language


Explanation : PL/SQL is a Block Structured Language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed to oracle engine all at once which increases processing speed and decreases the traffic.

A)
1991
B)
1992
C)
1993
D)
1994

Correct Answer : Option (A) :   1991


Explanation : In 1991, Oracle Corporation released Oracle Version 6.0, a major advance in its relational database technology. A key component of Oracle Version 6.0 was the so-called "procedural option" or PL/SQL. At roughly the same time, Oracle released its long-awaited upgrade to SQL*Forms Version 2.3.

A)
PL/SQL stands for Pattern Language Extension of SQL
B)
PL/SQL stands for Private Language Extension of SQL
C)
PL/SQL stands for Primary Language Extension of SQL
D)
PL/SQL stands for Procedural Language Extension of SQL

Correct Answer : Option (D) :   PL/SQL stands for Procedural Language Extension of SQL


Explanation : PL/SQL stands for Procedural Language Extension of SQL.

A)
Arrays can be used with it as well as handling exceptions (runtime errors).
B)
Conditions and loops are fundamental elements of procedural languages like PL/SQL.
C)
Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types.
D)
All of the above

Correct Answer : Option (D) :   All of the above


Explanation :

TRUE about PL/SQL functionalities :
 
* Conditions and loops are fundamental elements of procedural languages like PL/SQL.

* Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types.

* Arrays can be used with it as well as handling exceptions (runtime errors).

A)
Security
B)
Portability
C)
Robustness
D)
All of the above

Correct Answer : Option (D) :   All of the above


Explanation : Oracle Database's portability, robustness and security are inherited in it.

A)
20
B)
30
C)
40
D)
50

Correct Answer : Option (B) :   30


Explanation : A Variable in PL/SQL should not exceed 30 characters.

A)
Upper Case Sensitive
B)
Case Sensitive
C)
Not Case Sensitive
D)
Lower Case Sensitive

Correct Answer : Option (C) :   Not Case Sensitive


Explanation : PL/SQL Variables are by default not case sensitive.

A)
Literals
B)
Identifiers
C)
Delimiters
D)
All of the above

Correct Answer : Option (D) :   All of the above


Explanation : PL/SQL text is made up of lexical units, which are groups of characters and can be classified as Delimiters, Identifiers, Literals and Comments.

A)
Variable Section
B)
Declaration Section
C)
Initialization Section
D)
None of the above

Correct Answer : Option (B) :   Declaration Section


Explanation : PL/SQL Variable needs to be declared in the Declaration Section.

A)
variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]
B)
variable_name [CONSTANT] datatype [NULL] [:= | DEFAULT initial_value]
C)
datatype [CONSTANT] variable_name [NULL] [:= | DEFAULT initial_value]
D)
datatype [CONSTANT] variable_name [NOT NULL] [:= | DEFAULT initial_value]

Correct Answer : Option (A) :   variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]


Explanation :

The correct syntax to declare PL/SQL variable is :
 
variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]