PL/SQL MCQ

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 question, for 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
D.COUNT

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
B.open
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?

A. INTEGER
B.VARCHAR1
C.VARCHAR2
D.NUMBER

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?

A. ORDERBY
B.SORTBY
C.ALIGNBY
D.GROUPBY

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

A. QUERY
B.READ
C.SELECT
D.QUERY

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
B.%ROWTYPE
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
C.EXIT WHEN
D.CONTINUE WHEN

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 :

Your Comment

Valid name is required.

Name *

Valid name is required.

Your Email *

Valid email id is required.

Related MCQ/Quiz

01st
Nov

5G MCQ Questions

5G MCQ Questions

01st
Nov

3D Printing MCQ

3D Printing MCQ

01st
Nov

Data Analysis MCQ Questions

Data Analysis MCQ Questions

01st
Nov

DBMS MCQ Questions

DBMS MCQ Questions

01st
Nov

Software Engineering MCQ Questions

Software Engineering MCQ Questions

01st
Nov

Data Structure MCQ

Data Structure MCQ