PL/SQL MCQ

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.

Latest Interview Questions

img
API Testing Interview Questions 08th Aug, 2022
img
Celery Interview Questions 25th Nov, 2021
img
Solaris Interview Questions 24th Feb, 2021
img
Telematics Interview Questions 05th Mar, 2021
img
UFT Interview Questions 08th Aug, 2022
img
Terraform Interview Questions 23rd Nov, 2021

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 :

Valid name is required.

Valid name is required.

Valid email id is required.

Latest Posts

img
Login With Google using PHP 18th Nov, 2019
img
Working with expressions In Angular JS? 01st Nov, 2019
img
What is AngularJS? Why it is Used. 16th Nov, 2019

Latest MCQ Questions

img
Arduino MCQ Questions 08th Dec, 2021
img
3D Printing MCQ 23rd Nov, 2021
img
Bioinformatics MCQ Questions 12th Mar, 2022
img
Business Intelligence MCQ 15th Apr, 2022
img
Salesforce MCQ 28th Feb, 2022
img
SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Dec
Computer Science MCQ Questions

Computer Science MCQ Questions

01st
Nov
Computer Graphics MCQ

Computer Graphics MCQ

01st
Sep
Computer Network MCQ Questions

Computer Network MCQ Questions

01st
Aug
Ansible MCQ

Ansible MCQ

01st
Nov
ASP.NET MCQ Questions

ASP.NET MCQ Questions

01st
Nov
Digital Marketing MCQ

Digital Marketing MCQ