Take PL/SQL MCQ Quiz & Online Test to Test your Knowledge

Read the best PL/SQL MCQ Questions, that check your basic knowledge of PL/SQL. This PL/SQL MCQ Test contains 25 Multiple Choice Questions. these MCQs are very popular and asked various times in PL/SQL exams and interviews. You have to select the right answer to every question to check your final preparation. apart from this, you can also download the PL/SQL MCQ PDF completely from the given link below.


1) PL/SQL is a completely portable, ________________transaction processing language.

  • A. Low-performance
  • B.high-performance
  • C.both 1 & 2
  • D.None of the above

2) ___________types of literals are available in PL/SQL.

  • A. 2
  • B.5
  • C.4
  • D.6

3) SQL stands for ________.

  • A. Simple Query Language
  • B.Structured Query Language
  • C.Structured Query List
  • D.None of these

4) ____________is not a PL/SQL unit.

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

5) It contains all information about the content of the package and the code for the subprograms. it is not true about PL/SQL package.

  • A. true
  • B.false
Download Free : PL/SQL MCQ PDF

6) From the following PL/SQL Delimiters____________symbol is exponentiation operator.

  • A. ~=
  • B.<>
  • C.**
  • D.

7) PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content.

  • A. true
  • B.false

8) PL/SQL stands for -

  • A. Portable Language/SQL
  • B.Programming Language/SQL
  • C.Procedural Language/SQL
  • D.none of these

9) which of the following datatypes supports PS/SQL ?

  • A. Scalar datatype
  • B.Composite datatype
  • C.both 1 & 2
  • D.None of the above

10) which of the following are the features of PL/SQL.

  • A. It offers extensive error checking
  • B.It offers numerous data types.
  • C.It offers a variety of programming structures.
  • D.All of the mentioned

11) The Advantage of PL/SQL is -

  • A. Applications written in PL/SQL are fully portable.
  • B.PL/SQL provides high security level.
  • C.PL/SQL provides access to predefined SQL packages.
  • D.All of the mentioned

12) PL/SQL subprograms, unlike anonymous blocks, are compiled each time they are executed.

  • A. True
  • B.False

13) what is the purpose of triggers ?

  • A. Enforcing referential integrity
  • B.Synchronous replication of tables
  • C.Preventing invalid transactions
  • D.All of the mentioned above

14) __________________you declare an explicit cursor in the PL/SQL language

  • A. In the PL/SQL exception section
  • B.In the PL/SQL working storage sectio
  • C.In the PL/SQL declaration section
  • D.None of the above

15) PL/SQL is a block structured language. (true or false)

  • A. true
  • B.false

16) Boolean values cannot be used in −

  • A. SQL statements
  • B.Built-in SQL functions
  • C.PL/SQL functions invoked from SQL statements
  • D.All of the above

17) _______________________datatype is not allowed in the definition of PL/SQL record.

  • A. A Collection
  • B.A Scalar
  • C.Both A & B
  • D.None of the above

18) PL/SQL has two types of subprograms, procedures and functions. Which of the following subprogram is used to compute a value?

  • A. Procedure
  • B.Function
  • C.Both A & B
  • D.All of the above

19) PL/SQL has two types of subprograms, procedures and functions. Which of the following subprogram is used to compute a value?

  • A. Procedure
  • B.Function
  • C.Both A & B
  • D.All of the above

20) WRAP command is used to encrypt a PL/SQL application.

  • A. True
  • B.False

21) Which statement can be used to terminate a PL/SQL loop?

  • A. KILL
  • B.GOTO

22) PL/SQL is a procedural language that has .........................

  • A. Portability
  • B.Better Performance
  • C.Integration with database
  • D.All of the above

23) ................... provide a way for select multiple rows of data from the database.

  • A. PL/SQL Select
  • B.PL/SQL Trigger
  • C.PL/SQL Cursors
  • D.PL/SQL Process

24) Which of the followings are not the types of PL/SQL records?

  • A. View-based
  • B.Table-based
  • C.Cursor-based records
  • D.User-defined records

25) Which of the following option declares an instance of an object type?

  • A. object_declaration
  • B.record_declaration
  • C.procedure_declaration
  • D.None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

Maven MCQ