PL/SQL Quiz

PL/SQL is an extension of:

• Java

• C++

• SQL

• Python

What is the correct order of a PL/SQL block?

• DECLARE, BEGIN, EXCEPTION, END

• BEGIN, DECLARE, END

• DECLARE, BEGIN, END, EXCEPTION

• EXCEPTION, BEGIN, DECLARE, END

The symbol for assignment in PL/SQL is:

• ==

• =

• :=

• =>

Single-line comment in PL/SQL is indicated by:

• --

• /*

• //

BOOLEAN datatype can store:

• Numbers

• Characters

• TRUE, FALSE, NULL

• Dates

The operator for concatenation in PL/SQL is:

• &

• ||

To print output in PL/SQL, which built-in package is used?

• PUT_LINE

• PRINT

• DBMS_OUTPUT

• OUTPUT_DBMS

The keyword to end a PL/SQL block is:

• STOP

• EXIT

• END

• CLOSE

Conditional checking in PL/SQL is performed using:

• LOOP

• IF-ELSE

• SWITCH

• CASE-ELSE

%TYPE attribute is used to:

• Declare new types

• Match datatype of existing table columns

• Create new tables

• Delete columns