• Sharad Jaiswal
  • 20th Nov, 2021

We have listed here the Best PL/SQL MCQ Questions for your basic knowledge of PL/SQL Language. This PL/SQL MCQ Test contains 35+ PL/SQL Multiple Choice Questions, which cover the important topics of PL/SQL. You have to select the right answer to every questionfor which, you can perform best in PL/SQL Exams, Interviews, and Placement drives.

Practice PL/SQL MCQ Questions:

1) A package cursor is a cursor which you declare in the package specification without an SQL statement.

  • A. Yes
  • B.No

2) Identify the advantages of PL/SQL Packages?

  • A. Modularity
  • B.Added Functionality,Better Performance
  • C.Information Hiding
  • D.All of the above

3) The constructs of a procedure, function or a package are ________ .

  • A. Cursors
  • B.Variables and Constants
  • C.Exceptions
  • D.All of the above

4) Identify the correct collection method returns the index number that precedes index n in a collection?

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

5) Can pass you parameters to procedures or functions in a package.

  • A. Yes
  • B.No

6) Identify the non- schema object?

  • A. Indexes
  • B.Packages
  • C.Public Synonyms
  • D.Triggers

7) Which isn't the characteristics of a cursor FOR loop?

  • A. Record type declaration.
  • B.Requires exit condition to be defined.
  • C.Opening and parsing of SQL statements.
  • D.Fetches records from cursor.

8) Which line in the following statement will produce an error?

  • A. select name, rate, action
  • B.into action_record
  • C.from action_table;
  • D.cursor action_cursor is

9) The command used to open a CURSOR FOR loop is

  • A. parse
  • C.fetch
  • D.None, cursor for loops handle cursor opening implicitly.

10) Which of the following identifier is valid?

  • A. customer_12
  • B.12customer
  • C.customer@orgA
  • D.loop

11) Identify the invalid variable types?


12) Which is false information about the PL/SQL data structure VARRAY?

  • A. Each element in a VARRAY has an index associated with it
  • B.The elements can of various data types
  • C.It is a fixed-size sequential collection of elements
  • D.None of these

13) Which of the following PL/SQL supports datatype(s)?

  • A. Scalar datatype
  • B.Composite datatype
  • C.Both 1 and 2
  • D.None of these

14) From the following PL/SQL Delimiters which symbol is exponentiation operator.

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

15) What does a COMMIT statement do to a CURSOR?

  • A. Close the Cursor
  • B.Fetch the Cursor
  • C.Open the Cursor
  • D.None of these

16) SQL stand for

  • A. Structured Query Language
  • B.Structured Query List
  • C.Simple Query Language

17) What is the subset of SQL commands which is used to manipulate Oracle Database structures, including tables?

  • A. Data Manipulation Language(DML)
  • B.Data Definition Language(DDL)
  • C.Both 1 and 2
  • D.None of these

18) A CASE SQL statement is which of the following?

  • A. A way to establish an IF-THEN-ELSE in SQL.
  • B.A way to establish a data definition in SQL.
  • C.A way to establish a loop in SQL.
  • D.A way to establish a loop in SQL.

19) Identify the sorts rows in SQL?


20) The SQL statement that queries or reads data from a table is

  • A. QUERY
  • B.READ

21) SQL can be used to

  • A. Modify database data only
  • B.Create database structures only
  • C.Both 1 and 2
  • D.None of these

22) The SQL keywords(s) _____ is used with wildcards.

  • A. LIKE only
  • B.IN and NOT IN
  • C.IN only
  • D.NOTIN only

23) Identify the true statement about PL/SQL programs?

  • A. PL/SQL programs can exist with or without any SQL statements.
  • B.PL/SQL programs can exist only with any SQL statements.
  • C.PL/SQLprograms can exist only without any SQL statements.
  • D.SQL programs can exist only with PL/SQL statetment.

24) How many parts of a PL/SQL block are optional?

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

25) Which is used to declare a record?

  • A. %TYPE
  • C.Both 1 and 2
  • D.None of these

26) What is the purpose of triggers?

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

27) The advantage of pl/sql is...........

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

28) Which of the following is not a pl/sql unit?

  • A. Type
  • B.Table
  • C.Trigger
  • D.None of the above

29) Which of the following are the features of pl/sql?

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

30) 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.

31) Which of the following is true about scalar data types in pl/sql?

  • A. PL/SQL provides subtypes of data types.
  • B.They hold single values with no internal components.
  • C.Examples of scalar data types are NUMBER, DATE, or BOOLEAN.
  • D.All of the Above

32) Which of the following statements can be used to terminate a pl/sql loop?

  • A. KILL
  • B.GOTO

33) Which datatype is not allowed in the definition of pl/sql record?

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

34) PL/SQl is a completely portable high-performance transaction processing language.

  • A. True
  • B.False

35) PL/SQL packages supports polymorphism.

  • A. True
  • B.False

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.