PL/SQL Quiz

What is the full form of PL/SQL?

• Procedural Language SQL

• Procedural Logic SQL

• Programming Language SQL

• Process Logic SQL

Which of the following is NOT a valid PL/SQL block structure?

• Declaration

• Execution

• Exception handling

• Data transformation

What is the default value of a variable in PL/SQL if it is not initialized?

• NULL

• 0

• Empty string

• Undefined

Which of the following is true about PL/SQL anonymous blocks?

• They are stored in the database.

• They can be reused multiple times.

• They are not stored in the database.

• They must have parameters.

In PL/SQL, what is used to handle exceptions?

• CATCH block

• EXCEPTION block

• IF-ELSE block

• TRY block

Which of the following datatypes can store a large binary object in PL/SQL?

• NUMBER

• VARCHAR2

• BLOB

• CLOB

Which type of trigger fires when a row is inserted into a table in PL/SQL?

• BEFORE trigger

• AFTER trigger

• INSTEAD OF trigger

• ROW LEVEL trigger

What does %ROWTYPE attribute represent in PL/SQL?

• A variable that holds multiple rows of a table.

• A composite datatype representing a full row of a table.

• A collection of columns from multiple tables.

• A datatype for handling arrays in PL/SQL.

Which of the following is not a valid loop construct in PL/SQL?

• WHILE loop

• FOR loop

• DO-WHILE loop

• LOOP-END LOOP

In PL/SQL, how do you exit a loop prematurely?

• CONTINUE

• EXIT

• RETURN

• BREAK