Similar Collections

    No collections found

questions

Title
CASE statement uses which keyword to work like IF statement?

CASE statement uses which keyword to work like IF statement?

  1. INTO
  2. AS
  3. WHEN
  4. IN
discuss
What are the selectors in case of CASE statement?

What are the selectors in case of CASE statement?

  1. Variable
  2. Function
  3. Expression
  4. All of the above
discuss
Evaluation of CASE statement is done –

Evaluation of CASE statement is done –

  1. RIGHT to LEFT
  2. TOP to BOTTOM
  3. BOTTOM to TOP
  4. None of the above
discuss
By using PL/SQL ____, you can repeatedly execute one or more statements over and over again

By using PL/SQL ____, you can repeatedly execute one or more statements over and over again.

  1. Loops
  2. Cursor
  3. Variables
  4. Case
discuss
PL/SQL Loops are also known as –

PL/SQL Loops are also known as –

  1. Iterative Case Statements
  2. Iterative Control Statements
  3. Indentation Control Statements
  4. Indentation Case Statements
discuss
What is the syntax of PL/SQL Loop?

What is the syntax of PL/SQL Loop?

  1. LOOP END LOOP; Sequence of statements;
  2. END LOOP; LOOP Sequence of statements;
  3. LOOP Sequence of statements; END LOOP;
  4. END LOOP; Sequence of statements; LOOP
discuss
How many types of PL/SQL Loops are there?

How many types of PL/SQL Loops are there?

  1. 3
  2. 4
  3. 5
  4. 6
discuss
Which of the following is correct type of PL/SQL Loop?

Which of the following is correct type of PL/SQL Loop?

  1. While
  2. For
  3. Cursor For
  4. All of the above
discuss
A/An _______ loop in PL/SQL ensures that at least one statement is executed before the loop terminates

A/An _______ loop in PL/SQL ensures that at least one statement is executed before the loop terminates.

  1. While
  2. For
  3. Cursor For
  4. Exit
discuss
Which of the following is TRUE while using PL/SQL Exit Loop?

Which of the following is TRUE while using PL/SQL Exit Loop?

  1. The loop body should be initialized with a variable
  2. Variables in the loop are incremented.
  3. When you are ready to exit the loop, you should use the EXIT WHEN statement.
  4. All of the above
discuss
The PL/SQL ____ loop runs a series of statements as long as a condition is true, so it can be used in a series of statements

The PL/SQL ____ loop runs a series of statements as long as a condition is true, so it can be used in a series of statements.

  1. While
  2. Cursor For
  3. Basic
  4. For
discuss
What is the correct syntax of WHILE Loop?

What is the correct syntax of WHILE Loop?

  1. WHILE <condition> LOOP statements; END LOOP;
  2. LOOP statements; WHILE <condition> END LOOP;
  3. END LOOP; WHILE <condition> LOOP statements;
  4. None of the above
discuss
When you want to execute a series of statements repeatedly, you use the PL/SQL ____ loop

When you want to execute a series of statements repeatedly, you use the PL/SQL ____ loop.

  1. Cursor For
  2. Cursor
  3. For
  4. While
discuss
The counter in PL/SQL FOR Loop is by default incremented by –

The counter in PL/SQL FOR Loop is by default incremented by –

  1. 0
  2. 1
  3. 2
  4. NULL
discuss
Which of the following is TRUE while using PL/SQL FOR Loop?

Which of the following is TRUE while using PL/SQL FOR Loop?

  1. The counter variable is implicitly declared in the declaration section, so you do not need to declare it explicitly.
  2. It is not necessary to explicitly increment the counter variable since it is incremented by 1.
  3. FOR loops can use EXIT WHEN and EXIT statements, but it isn't often used.
  4. All of the above
discuss
PL/SQL ____ statement initiates the next iteration of a loop, skipping any code in between, by exiting the loop from the reminder in its body either conditionally or unconditionally

PL/SQL ____ statement initiates the next iteration of a loop, skipping any code in between, by exiting the loop from the reminder in its body either conditionally or unconditionally.

  1. Condition
  2. Cursor
  3. Continue
  4. Check
discuss
In which Oracle does the PL/SQL Continue Statement is supported?

In which Oracle does the PL/SQL Continue Statement is supported?

  1. Oracle 8g
  2. Oracle 9g
  3. Oracle 10g
  4. Oracle 11g
discuss
A ____ statement in PL/SQL allows you to jump from this statement to a specific statement label within the same subprogram within a PL/SQL block

A ____ statement in PL/SQL allows you to jump from this statement to a specific statement label within the same subprogram within a PL/SQL block.

  1. JUMP
  2. GOTO
  3. CONTINUE
  4. BLINK
discuss
The symbol in which the label_name is encapsulated in PL/SQL GOTO statement is –

The symbol in which the label_name is encapsulated in PL/SQL GOTO statement is –

  1. ( )
  2. { }
  3. [ ]
  4. <<>>
discuss
What is/are the correct restriction(s) on GOTO statement?

What is/are the correct restriction(s) on GOTO statement?

  1. A LOOP statement or sub-block cannot be used as an IF statement, CASE statement, or LOOP statement.
  2. A CASE statement WHEN clause or an IF statement clause cannot transfer control to another.
  3. No control can be transferred between outer blocks and sub-blocks.
  4. All of the above
discuss
total MCQs: 21

MCQs

21

Views

83

Best Answers

299

Points

5