PRO - PL SQL Programming - Theory

Which of the following statements can be used to terminate a PL/SQL loop?

1 Mark(s)

GOTO
EXIT WHEN
CONTINUE WHEN
KILL

When does a FOR Loop end?

1 Mark(s)

Only when the index reaches the UPPER bound
When the index reaches the UPPER bound or is terminated early using EXIT statement
When lower bound and upper bound are equal
Whenlower bound is greater than UPPER bound or is terminated early using EXIT statement

What can be the value of the lower and upper bounds of the FOR Loop?

1 Mark(s)

Numeric literals only
Numeric literal, Numeric variable or Numeric expression
Any Literal or expression
Numeric variables only

Which of the following is equivalent to multiple IF-ELSIF statements?

1 Mark(s)

LOOP statement
FOR statement
WHILE statement
CASE statement

Where can EXIT and CONTINUE appear inside PL/SQL?

1 Mark(s)

Anywhere inside a loop but not outside a loop
Anywhere in a PL/SQL block, not necessary in a loop
Anywhere in the execution part of a PL/SQL block only
Anywhere in the execution and exception handling block of PL/SQL

Which of the following is optional while using IF-THEN-ELSIF statements?

1 Mark(s)

END IF
ELSE
THEN
ELSIF

When can one record variable be assigned to another record variable?

1 Mark(s)

The fields of both variables match in number and order, and corresponding fields have the same data type
The fields of both variables match in number and corresponding fields have the same data type
The fields of both variables match in order, and corresponding fields have the same data type.
The fields of both variables match in number and order, but corresponding fields can have different data type

What is the datatype of the counter used in FOR Loop?

1 Mark(s)

INTEGER
Any Data type
INTEGER OR Character datatype
Any data type other than DATE

How many times does a BASIC Loop run?

1 Mark(s)

Zero or one
One or more
Zero or more
Only one always

How many times does a WHILE Loop run?

1 Mark(s)

Zero or one
Until the condition becomes TRUE
One or many
Until the condition becomes FALSE.

Which of the following is mandatory while using an IF statement?

1 Mark(s)

ELSE clause
ELSIFclause
END IF clause
Atleast one executable statement between IF and ENDIF

Which of the following statements can be used to skip some iterations of a Loop?

1 Mark(s)

GOTO
EXIT WHEN
CONTINUE WHEN
KILL

How many different types of Sequential control statements are there in PL/SQL?

1 Mark(s)

1
2
3
4

How many ELSIF clauses can an IF statement have?

1 Mark(s)

0 or 1
0 or many
1 or 2
1 to 10

Which of the following correctly describes a FOR Loop?

1 Mark(s)

The FOR LOOP statement runs one or more statements until the condition evaluates to FALSE
The FOR LOOP statement runs one or more statements while the loop index is in a specified range
The FOR LOOP statement runs one or more statements until an explicit EXIT statement terminates the loop.
The FOR LOOP statement runs one or more statements until the condition evaluates to TRUE.

In the following code when is the second ELSIF statement executed? IF condition-1 THEN statements-1 ELSIF condition-2 THEN statements-2 ELSIF condition-3 THEN statements-3 [ELSE ELSE statements] END IF;

1 Mark(s)

Anytime. There is no particular order
When the first IF evaluates to FALSE
When the first IF and the first ELSIF evaluates to FALSE
When the first IF and the first ELSIF evaluates to FALSE and ELSE also evaluates to FALSE

Where is the control transferred while using a CONTINUE statement?

1 Mark(s)

First statement after the end of the loop
Next iteration of the current loop
First iteration of the current loop
Last iteration of the current loop

Which of the following Loop statements can have EXIT and CONTINUE?

1 Mark(s)

A while loop only
A while or a for loop only
A while, for or basic loop
A while or a basic loop only

Which of the following is not true about a WHILE Loop?

1 Mark(s)

An EXIT statement terminates a WHILE Loop early
The statements inside a WHILE Loop is always executed at least once
The condition of a WHILE loop is evaluated at the beginning of each iteration
The statements EXIT, EXIT WHEN, CONTINUE and CONTINUE WHEN has the same meaning inside a WHILE Loop as it applied for a Simple Loop

What is the value of the FOR Loop index after the Loop runs?

1 Mark(s)

0
-1
Undefined
-1

PRO - PL SQL Programming - Theory - 3 : Question 1 of 20