PL/SQL Concepts Quiz

Which section of a PL/SQL block is mandatory?

• Declaration

• Execution

• Exception Handling

• All of the above

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

• BEGIN, DECLARE, EXCEPTION

• DECLARE, BEGIN, EXCEPTION

• EXCEPTION, BEGIN, DECLARE

• BEGIN, EXCEPTION, DECLARE

Which of the following is not a valid PL/SQL data type?

• BOOLEAN

• CHAR

• INTEGER

• STRING

What is the maximum size of a VARCHAR2 variable in PL/SQL?

• 1000 bytes

• 2000 bytes

• 4000 bytes

• 8000 bytes

Which of the following looping constructs is available in PL/SQL?

• FOR LOOP

• WHILE LOOP

• LOOP with EXIT

• All of the above

How do you exit from a loop in PL/SQL?

• BREAK

• CONTINUE

• EXIT

• STOP

Which control structure is not supported in PL/SQL?

• IF-THEN-ELSE

• CASE

• SWITCH

• LOOP

What is the major difference between a procedure and a function in PL/SQL?

• A procedure must return a value, but a function does not

• A function must return a value, but a procedure does not

• Procedures are faster than functions

• Functions cannot have parameters

Which keyword is used to return a value from a function in PL/SQL?

• RETURN

• OUTPUT

• EXIT

• GIVE

Which type of cursor is automatically created for every SQL DML statement?

• Implicit Cursor

• Explicit Cursor

• Dynamic Cursor

• Manual Cursor