• Admin
  • 05th May, 2021


Following are mostly asked Pl/sql MCQ test that are designed for professionals like you to crack you interviews. You can take this Pl/sql online test before appearing to you real interview. This Pl/sql quiz there are around 30+ multiple choice questions on Pl/sql with four options.

1) Which of the following is not a PL/SQL unit?

  • A. Type
  • B. Trigger
  • C. Table
  • D. Package

2) Which of the following is not true about PL/SQL constants and literals?

  • A. A CONSTANT declaration requires an initial value.
  • B. A constant is declared using the CONSTANT keyword.
  • C. The CONSTANT declaration cannot impose the NOT NULL constraint.
  • D. A constant holds a value that once declared, does not change in the program.

3) Which of the following code will open a cursor named cur_employee?

  • A. FETCH cur_employee;
  • B. OPEN cur_employee;
  • C. OPEN CURSOR cur_employee;
  • D. None of the Above

4) Is PL/SQL a completely portable, high-performance transaction processing language?

  • A. Yes
  • B. No

5) Which of the following statements execute a sequence of statements multiple times?

  • A. NULL statement
  • B. LOOP statement
  • C. MERGE statement
  • D. None of the Above
Download Free : PL/SQL MCQ PDF

6) The comparison methods are used for comparing objects. How many ways are available for comparing objects?

  • A. 1
  • B. 2
  • C. 3
  • D. 4

7) A package will have which of these mandatory parts?

  • A. Package specification
  • B. Package specification
  • C. Both A & B

8) Which collection method Returns the index number that precedes index n in a collection?

  • A. LIMIT
  • B. LAST
  • C. COUNT
  • D. PRIOR(n)

9) In which parameter mode Formal parameter acts like an initialized variable?

  • A. IN
  • B. OUT
  • C. IN OUT
  • D. None of the Above

10) Which of the following attribute returns NULL?

  • A. %FOUND
  • C. %ISOPEN

11) You can use the BULK COLLECT INTO clause with the FETCH statement to store values from each column of a cursor in a separate collection.

  • A. True
  • B. False

12) Which is a group of related data items stored in fields, each with its own name and datatype?

  • A. A Record
  • B. A Collection
  • C. A Table
  • D. Both A & B

13) Are associative arrays also known as index-by tables.

  • A. Yes
  • B. No

14) You will write separate routines called exception handlers to handle raised exceptions.

  • A. True
  • B. False

15) What are the different datatypes that can be defined in a PL/SQL block?

  • A. Reference
  • B. Scalar
  • C. Composite
  • D. All are Correct

16) PL/SQL Expressions are constructed using .............

  • A. Operators
  • B. Operands
  • C. Both A & B

17) Which of the following is used for displaying output on a web page?

  • A. HTP
  • B. HTF
  • C. Both A & B

18) Are Cursor attributes not affected by autonomous transactions.

  • A. Yes
  • B. No

19) Which of the following has a return type in its specification and must return a value specified in that type?

  • A. Package
  • B. Function
  • C. Procedure
  • D. None of the above

20) Does PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content?

  • A. Yes
  • B. No

21) Which of the following is a database object that groups logically related PL/SQL types, objects and subprograms?

  • A. Body
  • B. Name
  • C. Module
  • D. Package

22) Is it possible to define a CONSTANT value in a record?

  • A. Yes
  • B. No

23) The INSTEAD OF clause is used for creating trigger on a ______.

  • A. Table
  • B. View
  • C. Cursor
  • D. Index

24) Objects are created using the CREATE [OR REPLACE] CLASS statement.

  • A. True
  • B. False

25) _____ is not a DDL command.

  • B. ALTER

26) How many Primary keys can have in a table?

  • A. Only 2
  • B. Only 1
  • C. Depends on no of Columns
  • D. None of the above

27) ________ is the basic approaches for joining tables.

  • A. Union JOIN
  • B. Natural JOIN
  • C. Subqueries
  • D. All of the above

28) _______ is a constraint that can be defined only at the column level.

  • B. CHECK

29) Which of the following is NOT VALID is PL/SQL?

  • A. Bool boolean;
  • B. deptname dept.dname%type;
  • C. NUM1, NUM2 number;
  • D. None of the above

30) What are the different events in Triggers?

  • A. Insert
  • B. Update
  • C. Delete
  • D. All of the above

31) SHOW_ALERT function returns _____.

  • A. Character
  • B. Number
  • C. Both A and B
  • D. None of the above

32) When do you get a .PLL extension ?

  • A. Run Library file
  • B. Load Library file
  • C. Save Library file
  • D. None of the above

33) :SYSTEM.EFFECTIVE.DATE variable is write only variable.

  • A. True
  • B. False

34) _____ is NOT VALID in PL/SQL ?

  • A. Update
  • B. Delete
  • C. Create
  • D. All of the above

35) PL/SQL supports ______ datatype.

  • A. Scalar
  • B. Composite
  • C. Both A and B
  • D. None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

Html5 MCQ