Discover the power of technology and learning with TechyBuddy

Skip to content

Home
About Us
Contact Us
Browse
Login
Become..
- a Blogger

Home
TechyBuddy Quizzes
Unmasking the Best of PLSQL Quizzes on Collections (2024)

Spread the knowledge

PL/SQL collections are powerful tools for handling sets of data within Oracle databases. In this blog, we explore a series of quizzes designed to test and enhance your understanding of PL/SQL collections, such as associative arrays, nested tables, and varrays. These quizzes cover key concepts, best practices, and practical applications, helping developers improve their PL/SQL programming skills and optimize performance in database operations.

Welcome to your Unmasking the Best of PLSQL Quiz on Collection (2024)

This quiz has multiple choice questions and each has only one correct answer.

Total Questions : 45

To pass this quiz you need to score 80% or above.

Time Provided : 45 minutes

Today's Date : 27 October 2025

All the best!!

Name

Email

1.

What happens when you use the TRIM method on a nested table?

Deselect Answer

It removes the last element

It removes all NULL elements

It removes a specified number of elements from the end

It raises an exception

None

2.

Which of the following is a valid way to access an element in a PL/SQL nested table?

Deselect Answer

my_table[i]

my_table.item(i)

my_table(i)

All of the options

None

3.

Which of the following is a valid way to declare a PL/SQL object type with a nested table attribute?

A) CREATE TYPE my_type AS OBJECT (

field1 VARCHAR2(50),

field2 TABLE OF VARCHAR2(50)

);

B) CREATE TYPE my_type AS OBJECT (

field1 VARCHAR2(50),

field2 VARRAY(10) OF VARCHAR2(50)

);

C) CREATE TYPE my_type AS OBJECT (

field1 VARCHAR2(50),

field2 INDEX BY TABLE OF VARCHAR2(50)

);

D) Both A and B

Deselect Answer

Option B

Option D

Option C

Option A

None

4.

Which of the following is a valid way to declare a PL/SQL index-by table?

Deselect Answer

All of the options

TYPE my_table IS TABLE OF VARCHAR2(50) INDEX BY VARCHAR2(50);

TYPE my_table IS TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER;

TYPE my_table IS TABLE OF VARCHAR2(50) INDEX BY NUMBER;

None

5.

What happens when you assign an existing collection to another variable of the same type?

Deselect Answer

Only the reference is copied

An exception is raised

A deep copy is created

A shallow copy is created

None

6.

Which of the following is NOT a type of collection in PL/SQL?

Deselect Answer

Associative array

VARRAY

Nested table

Linked list

None

7.

What happens when you use the DELETE method on a VARRAY?

Deselect Answer

It removes all elements and sets the VARRAY to NULL

It removes all elements but keeps the VARRAY's size

It raises an exception

It removes the last element of the VARRAY

None

8.

Which of the following is a valid way to declare a PL/SQL nested table?

A) TYPE my_table IS TABLE OF VARCHAR2(50);

B) TYPE my_table IS TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER;

C) TYPE my_table IS TABLE OF VARCHAR2(50) INDEX BY VARCHAR2(50);

D) Both A and B

Deselect Answer

Both option B and C are correct

Option D

Option B is correct

Option A is correct

None

9.

What is the purpose of the MULTISET UNION operator in PL/SQL?

Deselect Answer

To intersect two collections, returning the elements that are common to both

To combine two collections into a single collection, removing duplicates

To subtract one collection from another, returning the elements that are unique to the first collection

To combine two collections into a single collection, preserving duplicates

None

10.

What is the primary difference between a nested table and a VARRAY?

Deselect Answer

Nested tables have a maximum size, VARRAYs do not

VARRAYs can be sparse, nested tables cannot

VARRAYs have a maximum size, nested tables do not

Nested tables can be sparse, VARRAYs cannot

None

11.

Which method can be used to find out if a collection is empty?

Deselect Answer

COUNT

NULLIF

CARDINALITY

IS_EMPTY

None

12.

What is the purpose of the LIMIT clause in a PL/SQL cursor loop?

Deselect Answer

To limit the number of rows fetched in a single batch

To limit the number of iterations in the loop

To limit the execution time of the loop

To limit the size of the collection being populated

None

13.

Which of the following is a valid way to declare a PL/SQL varray of records?

Deselect Answer

All of the options

TYPE my_varray IS VARRAY(10) OF RECORD(field1 VARCHAR2(50), field2 NUMBER);

TYPE my_varray IS ARRAY(10) OF RECORD(field1 VARCHAR2(50), field2 NUMBER);

TYPE my_varray IS TABLE OF RECORD(field1 VARCHAR2(50), field2 NUMBER);

None

14.

What happens when you try to access an element of a nested table that doesn't exist?

Deselect Answer

It returns NULL

It raises a SUBSCRIPT_OUTSIDE_LIMIT exception

It raises a COLLECTION_IS_NULL exception

It raises a NO_DATA_FOUND exception

None

15.

Which of the following is a valid way to declare a PL/SQL associative array?

Deselect Answer

All of the above

TYPE my_array IS TABLE OF VARCHAR2(50) INDEX BY VARCHAR2(50);

TYPE my_array IS TABLE OF VARCHAR2(50) INDEX BY NUMBER;

TYPE my_array IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

None

16.

What is the purpose of the MULTISET INTERSECTION operator in PL/SQL?

Deselect Answer

To intersect two collections, returning the elements that are common to both

To combine two collections into a single collection, preserving duplicates

To combine two collections into a single collection, removing duplicates

To subtract one collection from another, returning the elements that are unique to the first collection

None

17.

Which method can be used to retrieve both the index and value of a collection element in a single operation?

Deselect Answer

FETCH

FIRST

PRIOR

NEXT

None

18.

What is the purpose of the MEMBER OF operator in PL/SQL?

Deselect Answer

To remove an element from a collection

To add an element to a collection

To iterate over the elements of a collection

To check if an element is a member of a collection

None

19.

What is the purpose of the SAVE EXCEPTIONS clause in a PL/SQL FORALL statement?

Deselect Answer

To collect the results of a function call into a collection

To handle exceptions that occur during the execution of the DML statements

To fetch rows from the database in bulk, improving performance

To execute multiple DML statements in a single transaction

None

20.

What is the maximum size of a PL/SQL collection?

Deselect Answer

32767

65535

16383

4096

None

21.

What is the purpose of the LIMIT clause in a PL/SQL bulk collect loop?

Deselect Answer

To limit the execution time of the loop

To limit the size of the collection being populated

To limit the number of iterations in the loop

To limit the number of rows fetched in a single batch

None

22.

Which of the following is true about the LIMIT function for collections?

Deselect Answer

It sets a new upper bound for the collection

It returns the current number of elements in the collection

It returns the maximum size for VARRAYs and NULL for other types

It raises an exception if the collection is empty

None

23.

What is the purpose of the MULTISET EXCEPT operator in PL/SQL?

Deselect Answer

To subtract one collection from another, returning the elements that are unique to the first collection

To intersect two collections, returning the elements that are common to both

To combine two collections into a single collection, preserving duplicates

To combine two collections into a single collection, removing duplicates

None

24.

Which method returns the number of elements in a collection?

Deselect Answer

SIZE

LENGTH

CARDINALITY

COUNT

None

25.

What is the purpose of the BULK COLLECT clause in a PL/SQL cursor loop?

Deselect Answer

To fetch rows from the database in bulk, improving performance

To execute multiple DML statements in a single transaction

To iterate over the elements of a collection in bulk

To collect the results of a function call into a collection

None

26.

Which method is used to remove all elements from a collection?

Deselect Answer

TRUNCATE

DELETE

REMOVE

CLEAR

None

27.

Which of the following is NOT a valid index type for an associative array?

Deselect Answer

VARCHAR2

BLOB

PLS_INTEGER

DATE

None

28.

Which of the following is a valid way to declare a PL/SQL index-by table of records?

Deselect Answer

TYPE my_table IS TABLE OF RECORD(field1 VARCHAR2(50), field2 NUMBER) INDEX BY PLS_INTEGER;

All of the options

TYPE my_table IS TABLE OF RECORD(field1 VARCHAR2(50), field2 NUMBER) INDEX BY BINARY_INTEGER;

TYPE my_table IS TABLE OF RECORD(field1 VARCHAR2(50), field2 NUMBER) INDEX BY VARCHAR2(50);

None

29.

What is the purpose of the FORALL statement in PL/SQL?

Deselect Answer

To declare and initialize a collection

To retrieve data from the database in bulk

To iterate over the elements of a collection in a loop

To execute multiple DML statements in a single transaction

None

30.

What is the purpose of the EXISTS method in PL/SQL collections?

Deselect Answer

To check if the collection is empty

To check if a specific value exists in the collection

To check if a specific index exists in the collection

To check if the collection has been initialized

None

31.

Which of the following is a valid way to declare a PL/SQL varray?

Deselect Answer

TYPE my_varray IS VARRAY(10) OF VARCHAR2(50);

TYPE my_varray IS VARIABLE_ARRAY(10) OF VARCHAR2(50);

TYPE my_varray IS ARRAY(10) OF VARCHAR2(50);

All of the options

None

32.

Which of the following is a valid way to declare a PL/SQL nested table of records?

Deselect Answer

TYPE my_table IS VARRAY(10) OF RECORD(field1 VARCHAR2(50), field2 NUMBER);

All of the options

TYPE my_table IS TABLE OF RECORD(field1 VARCHAR2(50), field2 NUMBER);

TYPE my_table IS TABLE OF RECORD(field1 VARCHAR2(50), field2 NUMBER) INDEX BY PLS_INTEGER;

None

33.

Which collection type allows indexing by non-integer types?

Deselect Answer

Nested table

VARRAY

Associative array

All of the options

None

34.

What is the correct syntax to declare an associative array of integers indexed by string?

Deselect Answer

TYPE int_array IS VARRAY(100) OF INTEGER;

TYPE int_array IS ARRAY(100) OF INTEGER INDEX BY VARCHAR2(50);

TYPE int_array IS TABLE OF INTEGER INDEX BY VARCHAR2(50);

TYPE int_array IS TABLE OF INTEGER;

None

35.

Which of the following is a valid way to declare a PL/SQL index-by table of object types?

A) TYPE my_table IS TABLE OF my_type INDEX BY PLS_INTEGER;

B) TYPE my_table IS VARRAY(10) OF my_type;

C) TYPE my_table IS TABLE OF my_type INDEX BY VARCHAR2(50);

D) Both A and C
Choose the correct option

Deselect Answer

Option B

Option C

Option D

Option A

None

36.

What is the maximum number of elements allowed in a VARRAY?

Deselect Answer

1024

214748347

It depends on the declaration

256

None

37.

What is the purpose of the MULTISET UNION DISTINCT operator in PL/SQL?

Deselect Answer

To subtract one collection from another, returning the elements that are unique to the first collection

To combine two collections into a single collection, preserving duplicates

To combine two collections into a single collection, removing duplicates

To intersect two collections, returning the elements that are common to both

None

38.

Which of the following is NOT a valid operation on an associative array?

Deselect Answer

Adding elements with non-consecutive indexes

Extending the array's size

Assigning NULL to an element

Removing elements from the middle

None

39.

Which of the following is a valid way to initialize a PL/SQL nested table?

Deselect Answer

my_table := NULL;

my_table := new my_table();

my_table := [];

my_table := my_table();

None

40.

Which of the following is a valid way to declare a PL/SQL index-by table of nested tables?

A) TYPE my_table IS TABLE OF TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER;

B) TYPE my_table IS VARRAY(10) OF TABLE OF VARCHAR2(50);

C) TYPE my_table IS TABLE OF TABLE OF VARCHAR2(50) INDEX BY VARCHAR2(50);

D) Both A and C
Choose the correct option

Deselect Answer

Option A

Option D

Option B

Option C

None

41.

Which of the following is a valid way to access an element in a PL/SQL associative array?

Deselect Answer

All of the above

my_array(i)

my_array[i]

my_array.item(i)

None

42.

What is the purpose of the CURSOR FOR loop in PL/SQL?

Deselect Answer

To handle exceptions that occur during the execution of DML statements

To fetch rows from the database in bulk, improving performance

To iterate over the elements of a collection

To execute a cursor-based query and process the results

None

43.

Which of the following is true about the FIRST and LAST methods of a collection?

Deselect Answer

They return the first and last elements of the collection

They are only available for associative arrays

They always return 1 and the collection count respectively

They return the lowest and highest index values in use

None

44.

Which of the following is the correct way to initialize a PL/SQL associative array?

Deselect Answer

my_array := new my_array();

my_array := my_array();

my_array := NULL;

my_array := [];

None

45.

Which method is used to add an element to the end of a nested table or VARRAY?

Deselect Answer

ADD

APPEND

EXTEND

PUSH

None

If you have anything to suggest or correction on any quiz, feel free to comment in the box below

Are you sure to submit the quiz: Unmasking the Best of PLSQL Quiz on Collection (2024) ?

Home
About Us
Contact Us
Privacy Policy
Disclaimer
Terms of Use
Sitemap

© 2025 by TechyBuddy

Scroll to Top