PL/SQL Questions and Answers – PL/SQL Syntax

This set of PL/SQL Multiple Choice Questions & Answers (MCQs) focuses on “PL/SQL Syntax”.

1. Which of the following syntax is correct way to declare a variable in PL/SQL?
a) datatype variable_name [NOT NULL := value ];
b) variable_name datatype [NOT NULL := value ];
c) variable_name datatype;
d) variable_name datatype (NOT NULL := value );
View Answer

datatype [NOT NULL := VALUE];

2. Which of the following statement is used to initialise a variable in PL/SQL?
a) variable_name datatype := value;
b) datatype variable_name := value;
c) variable_name datatype = value;
d) datatype variable_name = value;
View Answer

variable_name datatype := VALUE;

3. Which of the following statement is used to take input from the user in PL/SQL?
a) variable_name datatype = &variable_name;
b) datatype variable_name := &variable_name;
c) datatype variable_name = &variable_name;
d) variable_name datatype := &variable_name;
View Answer

variable_name datatype := &variable_name;

4. What will be the output of the following PL/SQL code?

SQL> SET SERVEROUTPUT ON; 
SQL> DECLARE 
    a varchar2(20) := 'Sanfoundry' ;  
BEGIN 
    dbms_output.put_line(a); 
END; 
/

a)

Sanfoundry
procedure successfully completed.

b)

PL/SQL procedure successfully completed.

c)

Sanfoundry
PL/SQL procedure successfully completed.

d)

Sanfoundry

Sanfoundry
PL/SQL PROCEDURE successfully completed.

5. The slash (/) tells the SQL*Plus to execute the block written.
a) True
b) False
View Answer

Sanfoundry Global Education & Learning Series – PL/SQL.

To practice all areas of PL/SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]