PL/SQL Flashcard

Front

PL/SQL is an extension of: Java, C++, SQL, Python

Back

SQL

Front

What is the correct order of a PL/SQL block? Options: DECLARE, BEGIN, EXCEPTION, END, BEGIN, DECLARE, END, DECLARE, BEGIN, END, EXCEPTION, EXCEPTION, BEGIN, DECLARE, END

Back

DECLARE, BEGIN, EXCEPTION, END

Front

The symbol for assignment in PL/SQL is:

Back

:=

Front

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

Back

--

Front

BOOLEAN datatype can store:

Back

TRUE, FALSE, NULL

Front

The operator for concatenation in PL/SQL is:

Back

||

Front

To print output in PL/SQL, which built-in package is used? Options: PUT_LINE, PRINT, DBMS_OUTPUT, OUTPUT_DBMS

Back

DBMS_OUTPUT

Front

The keyword to end a PL/SQL block is:

Back

END

Front

Conditional checking in PL/SQL is performed using: LOOP, IF-ELSE, SWITCH, CASE-ELSE

Back

IF-ELSE

Front

%TYPE attribute is used to:

Back

Match datatype of existing table columns