PLSQL

PL/SQL Variables are by default

• 1. Case Sensitive

• 1. Upper Case Sensitive

• 1. Lower Case Sensitive

• 1. Not Case Sensitive

In order to initialize a variable with the value other than NULL, it can be done using which method?

• 1. A. The Assignment Operator

• 1. B. The DEFAULT Keyword

• 1. Both A. and B.

• 1. None of the given

Choose the correct syntax to declare a constant.

• 1. constant_name CONSTANT datatype := VALUE;

• 1. datatype CONSTANT constant_name := VALUE;

• 1. constant_name CONST datatype =: VALUE;

• 1. datatype CONSTANT constant_name =: VALUE;

Which of the following is correct syntax of IF statement?

• 1. IF-THEN statement

• 1. IF-THEN-ELSE statement

• 1. IF-THEN-ELSIF statement

• 1. All of the options

CASE statement uses which keyword to work like IF statement?

• 1. INTO

• 1. AS

• 1. WHEN

• 1. IN

What is the syntax of PL/SQL Loop?

• 1. LOOP END LOOP; Sequence of statements;

• 1. END LOOP; LOOP Sequence of statements;

• 1. LOOP Sequence of statements; END LOOP;

• 1. END LOOP; Sequence of statements; LOOP

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

• 1. Cursor For

• 1. Cursor

• 1. For

• 1. While

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

• 1. GOTO

• 1. CONTINUE

• 1. BLINK

How much number of ways is there to pass the parameters in procedure?

• 1

• 2

• 3

• 4

Which of the following are the pass parameters in procedure?

• IN

• OUT

• INOUT

• All the options