PL/SQL MCQs Quiz

PL/SQL is a procedural extension of which database language?

• SQL Server

• PostgreSQL

• SQL

• MySQL

Which section is mandatory in a PL/SQL block?

• DECLARE

• BEGIN

• EXCEPTION

• END

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

• DECLARE -> BEGIN -> EXCEPTION -> END

• BEGIN -> DECLARE -> EXCEPTION -> END

• DECLARE -> EXCEPTION -> BEGIN -> END

• BEGIN -> END

Which operator is used for string concatenation in PL/SQL?

• +

• ||

• &

• #

Which keyword is used to define a variable with the same data type as a table column?

• %ROWTYPE

• %TYPE

• %COLUMN

• %DATATYPE

Which of the following is true about IF...THEN...ELSE in PL/SQL?

• IF must always be followed by ELSE

• ELSE is mandatory

• Multiple ELSIF can be used

• It cannot be nested

What will be the output if NULLIF(5, 5) is executed?

• 5

• 0

• NULL

• Error

Which function returns the first non-null value from a list?

• NVL

• NULLIF

• COALESCE

• DECODE

Which keyword is used for a conditional statement in PL/SQL that evaluates multiple possible values?

• IF

• CASE

• SWITCH

• WHEN

Which function checks if two values are equal and returns NULL if they are?

• NVL

• COALESCE

• NULLIF

• DECODE