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 : 21 June 2025

All the best!!

Name

Email

1.

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

2.

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

Deselect Answer

my_table := my_table();

my_table := new my_table();

my_table := [];

my_table := NULL;

None

3.

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

Deselect Answer

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

All of the options

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

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

None

4.

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

Deselect Answer

To limit the number of iterations in the loop

To limit the execution time of the loop

To limit the number of rows fetched in a single batch

To limit the size of the collection being populated

None

5.

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

Deselect Answer

It returns the current number of elements in the collection

It sets a new upper bound for the collection

It raises an exception if the collection is empty

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

None

6.

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

Deselect Answer

TYPE int_array IS TABLE OF INTEGER;

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

TYPE int_array IS VARRAY(100) OF INTEGER;

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

None

7.

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 B

Option C

Option A

Option D

None

8.

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

Deselect Answer

It raises a COLLECTION_IS_NULL exception

It returns NULL

It raises a SUBSCRIPT_OUTSIDE_LIMIT exception

It raises a NO_DATA_FOUND exception

None

9.

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

Deselect Answer

It removes the last element of the VARRAY

It raises an exception

It removes all elements and sets the VARRAY to NULL

It removes all elements but keeps the VARRAY's size

None

10.

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

Deselect Answer

It removes the last element

It removes a specified number of elements from the end

It removes all NULL elements

It raises an exception

None

11.

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

Deselect Answer

Assigning NULL to an element

Removing elements from the middle

Adding elements with non-consecutive indexes

Extending the array's size

None

12.

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

Deselect Answer

All of the options

my_table[i]

my_table(i)

my_table.item(i)

None

13.

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 A

Option D

Option C

Option B

None

14.

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

Deselect Answer

my_array.item(i)

All of the above

my_array[i]

my_array(i)

None

15.

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

Deselect Answer

To iterate over the elements of a collection in bulk

To fetch rows from the database in bulk, improving performance

To collect the results of a function call into a collection

To execute multiple DML statements in a single transaction

None

16.

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

Deselect Answer

EXTEND

PUSH

ADD

APPEND

None

17.

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

Deselect Answer

To fetch rows from the database in bulk, improving performance

To execute multiple DML statements in a single transaction

To collect the results of a function call into a collection

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

None

18.

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

Option D

Both option B and C are correct

Option A is correct

Option B is correct

None

19.

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

Deselect Answer

To iterate over the elements of a collection

To remove an element from a collection

To check if an element is a member of a collection

To add an element to a collection

None

20.

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

Deselect Answer

VARCHAR2

BLOB

DATE

PLS_INTEGER

None

21.

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

Deselect Answer

IS_EMPTY

CARDINALITY

NULLIF

COUNT

None

22.

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

Deselect Answer

Only the reference is copied

A deep copy is created

An exception is raised

A shallow copy is created

None

23.

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

Deselect Answer

Linked list

Nested table

VARRAY

Associative array

None

24.

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 BINARY_INTEGER;

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

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

None

25.

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

Deselect Answer

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

All of the options

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

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

None

26.

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

Deselect Answer

4096

32767

65535

16383

None

27.

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

Deselect Answer

To combine two collections into a single collection, removing duplicates

To combine two collections into a single collection, preserving duplicates

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

None

28.

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 D

Option A

Option C

None

29.

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

Deselect Answer

my_array := NULL;

my_array := new my_array();

my_array := my_array();

my_array := [];

None

30.

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

31.

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

Deselect Answer

To combine two collections into a single collection, removing duplicates

To combine two collections into a single collection, preserving duplicates

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

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

None

32.

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

Deselect Answer

To check if the collection has been initialized

To check if the collection is empty

To check if a specific index exists in the collection

To check if a specific value exists in the collection

None

33.

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

Deselect Answer

VARRAYs have a maximum size, nested tables do not

Nested tables have a maximum size, VARRAYs do not

VARRAYs can be sparse, nested tables cannot

Nested tables can be sparse, VARRAYs cannot

None

34.

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

Deselect Answer

It depends on the declaration

256

1024

214748347

None

35.

Which collection type allows indexing by non-integer types?

Deselect Answer

Associative array

All of the options

Nested table

VARRAY

None

36.

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

Deselect Answer

To combine two collections into a single collection, preserving duplicates

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

None

37.

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

Deselect Answer

They return the lowest and highest index values in use

They always return 1 and the collection count respectively

They are only available for associative arrays

They return the first and last elements of the collection

None

38.

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

Deselect Answer

To combine two collections into a single collection, preserving duplicates

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, removing duplicates

None

39.

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

Deselect Answer

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

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

All of the options

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

None

40.

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

Deselect Answer

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

All of the options

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

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

None

41.

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

Deselect Answer

DELETE

REMOVE

TRUNCATE

CLEAR

None

42.

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

Deselect Answer

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

To limit the execution time of the loop

None

43.

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

Deselect Answer

To iterate over the elements of a collection

To handle exceptions that occur during the execution of DML statements

To execute a cursor-based query and process the results

To fetch rows from the database in bulk, improving performance

None

44.

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

Deselect Answer

PRIOR

NEXT

FIRST

FETCH

None

45.

Which method returns the number of elements in a collection?

Deselect Answer

LENGTH

CARDINALITY

COUNT

SIZE

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