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 : 28 May 2025

All the best!!

Name

Email

1.

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

Deselect Answer

Nested table

Linked list

VARRAY

Associative array

None

2.

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

Deselect Answer

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;

All of the above

None

3.

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

Deselect Answer

To retrieve data from the database in bulk

To declare and initialize a collection

To iterate over the elements of a collection in a loop

To execute multiple DML statements in a single transaction

None

4.

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

Deselect Answer

my_table := new my_table();

my_table := my_table();

my_table := [];

my_table := NULL;

None

5.

Which collection type allows indexing by non-integer types?

Deselect Answer

VARRAY

Associative array

All of the options

Nested table

None

6.

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

Deselect Answer

To iterate over the elements of a collection

To execute a cursor-based query and process the results

To fetch rows from the database in bulk, improving performance

To handle exceptions that occur during the execution of DML statements

None

7.

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) INDEX BY PLS_INTEGER;

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

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

All of the options

None

8.

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

Deselect Answer

VARCHAR2

PLS_INTEGER

DATE

BLOB

None

9.

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

Deselect Answer

NEXT

PRIOR

FIRST

FETCH

None

10.

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 size of the collection being populated

To limit the number of iterations in the loop

To limit the execution time of the loop

None

11.

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(i)

my_table.item(i)

All of the options

None

12.

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

13.

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

14.

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

Deselect Answer

256

It depends on the declaration

214748347

1024

None

15.

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 VARIABLE_ARRAY(10) OF VARCHAR2(50);

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

All of the options

None

16.

Which method returns the number of elements in a collection?

Deselect Answer

LENGTH

CARDINALITY

SIZE

COUNT

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.

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

Deselect Answer

4096

65535

32767

16383

None

19.

What is the purpose of the LIMIT clause in a PL/SQL bulk collect 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 size of the collection being populated

To limit the execution time of the loop

None

20.

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

Deselect Answer

NULLIF

CARDINALITY

IS_EMPTY

COUNT

None

21.

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 B is correct

Option A is correct

Option D

Both option B and C are correct

None

22.

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

Deselect Answer

All of the options

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

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

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

None

23.

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

Deselect Answer

To iterate over the elements of a collection

To check if an element is a member of a collection

To remove an element from a collection

To add an element to a collection

None

24.

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

Deselect Answer

A shallow copy is created

Only the reference is copied

An exception is raised

A deep copy is created

None

25.

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

26.

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

Deselect Answer

It removes the last element of the VARRAY

It removes all elements and sets the VARRAY to NULL

It raises an exception

It removes all elements but keeps the VARRAY's size

None

27.

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 returns the maximum size for VARRAYs and NULL for other types

It raises an exception if the collection is empty

It sets a new upper bound for the collection

None

28.

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

Deselect Answer

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

All of the options

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

None

29.

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

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 VARCHAR2(50);

None

30.

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

Deselect Answer

CLEAR

REMOVE

TRUNCATE

DELETE

None

31.

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

Deselect Answer

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

To combine two collections into a single collection, preserving duplicates

To combine two collections into a single collection, removing duplicates

None

32.

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

33.

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 subtract one collection from another, returning the elements that are unique to the first collection

To combine two collections into a single collection, removing duplicates

None

34.

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

Deselect Answer

PUSH

APPEND

ADD

EXTEND

None

35.

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

Deselect Answer

VARRAYs can be sparse, nested tables cannot

Nested tables can be sparse, VARRAYs cannot

VARRAYs have a maximum size, nested tables do not

Nested tables have a maximum size, VARRAYs do not

None

36.

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

Deselect Answer

my_array[i]

All of the above

my_array.item(i)

my_array(i)

None

37.

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 C

Option D

Option A

Option B

None

38.

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 C

Option D

Option B

Option A

None

39.

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

Deselect Answer

Removing elements from the middle

Adding elements with non-consecutive indexes

Extending the array's size

Assigning NULL to an element

None

40.

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

Deselect Answer

It raises a SUBSCRIPT_OUTSIDE_LIMIT exception

It raises a COLLECTION_IS_NULL exception

It raises a NO_DATA_FOUND exception

It returns NULL

None

41.

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 return the lowest and highest index values in use

They always return 1 and the collection count respectively

None

42.

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 D

Option B

Option A

Option C

None

43.

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 value exists in the collection

To check if a specific index exists in the collection

None

44.

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 collect the results of a function call into a collection

To execute multiple DML statements in a single transaction

To iterate over the elements of a collection in bulk

None

45.

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 subtract one collection from another, returning the elements that are unique to the first collection

To combine two collections into a single collection, removing duplicates

To combine two collections into a single collection, preserving duplicates

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