PL/SQL Online Quiz

Q 1 - Which of the following is not true about the execution section of a PL/SQL block?

A - It should have more than one executable line of code.

B - It may have just a NULL command to indicate that nothing should be executed.

C - The statements must always end with a semicolon.

D - The section may contain SQL commands, logical control commands, assignment commands, as well as other commands.

Q 2 - Which of the following is not true about PL/SQL constants and literals?

A - A constant holds a value that once declared, does not change in the program.

B - The CONSTANT declaration cannot impose the NOT NULL constraint.

C - A constant is declared using the CONSTANT keyword.

D - A CONSTANT declaration requires an initial value.

Q 3 - What is wrong in the following code snippet?

 DECLARE x number := 1; BEGIN LOOP dbms_output.put_line(x); x := x + 1; IF x > 10 THEN exit; END IF; dbms_output.put_line('After Exit x is: ' || x); END; 

A - There is nothing wrong.

B - The IF statement is not required.

C - There should be an END LOOP statement.

D - The exit statement should be in capital letters.

Q 4 - Which of the following is true about the PL/SQL data structure VARRAY?

A - It also has a maximum size that cannot be changed.

B - A VARRAY type is created with the CREATE VARRAY statement, at the schema level.

C - Maximum size of a VARRAY can be changed using the ALTER TYPE statement.

D - Maximum size of a VARRAY can be changed using the ALTER VARRAY statement.

Q 5 - What would be the output of the following code?

 DECLARE num number; fn number; FUNCTION fx(x number) RETURN number IS f number; BEGIN IF x=0 THEN f := 1; ELSE f := x * fx(x-1); END IF; RETURN f; END; BEGIN num:= 5; fn := fx(num); dbms_output.put_line(fn); END; 

A - 1

B - 5

C - 10

D - 125

Q 6 - The pre-defined exception CASE_NOT_FOUND is raised when

A - None of the choices in the WHEN clauses of a CASE statement is selected, and there is no ELSE clause.

B - PL/SQL has an internal problem.

C - A cursor fetches value in a variable having incompatible data type.

D - None of the above.

Q 7 - Observe the syntax given below −

 CREATE [OR REPLACE ] TRIGGER trigger_name {BEFORE | AFTER | INSTEAD OF } {INSERT [OR] | UPDATE [OR] | DELETE} [OF col_name] ON table_name [REFERENCING OLD AS o NEW AS n] [FOR EACH ROW] WHEN (condition) DECLARE Declaration-statements BEGIN Executable-statements EXCEPTION Exception-handling-statements END; 

The {INSERT [OR] | UPDATE [OR] | DELETE} clause specifies a

A - DDL operation.

B - DML operation.

C - None of the above.

D - Both of the above.

Q 8 - Which of the following is true about PL/SQL index-by tables?

A - It is a set of key-value pairs.

B - Each key is unique and is used to locate the corresponding value.

C - The key can be either an integer or a string.

D - All of the above.

Q 9 - Which of the following code is the correct syntax for creating a nested table named salary that will store integer values?

A - TYPE salary IS TABLE OF INTEGER;

B - TYPE salary IS NESTED TABLE OF INTEGER;

C - TABLE salary IS NESTED BY INTEGER;

D - TABLE salary IS INDEXED BY INTEGER;

Q 10 - Savepoints are set to

A - Help in splitting a long transaction into smaller units.

B - Help in rolling back to some checkpoint, within a long transaction.

C - To execute a COMMIT automatically.

D - Answer a. and b.