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

All the best!!

Name

Email

1.

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

2.

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

Deselect Answer

COUNT

IS_EMPTY

NULLIF

CARDINALITY

None

3.

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

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

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

All of the above

None

4.

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

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

None

5.

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

Deselect Answer

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

VARRAYs can be sparse, nested tables cannot

None

6.

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 execution time of the loop

To limit the number of iterations in the loop

None

7.

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 := NULL;

my_table := my_table();

None

8.

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 C

Option D

Option B

None

9.

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

10.

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

Deselect Answer

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

To fetch rows from the database in bulk, improving performance

None

11.

Which collection type allows indexing by non-integer types?

Deselect Answer

Nested table

All of the options

VARRAY

Associative array

None

12.

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

13.

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

Deselect Answer

They are only available for associative arrays

They return the first and last elements of the collection

They return the lowest and highest index values in use

They always return 1 and the collection count respectively

None

14.

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 handle exceptions that occur during the execution of the DML statements

To execute multiple DML statements in a single transaction

To collect the results of a function call into a collection

None

15.

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

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

None

16.

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 A

Option C

Option D

Option B

None

17.

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

Deselect Answer

214748347

256

It depends on the declaration

1024

None

18.

What is the purpose of the MULTISET UNION DISTINCT 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 combine two collections into a single collection, removing duplicates

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

None

19.

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

Deselect Answer

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

All of the options

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

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

None

20.

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

Deselect Answer

4096

32767

65535

16383

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 number of iterations in the loop

To limit the number of rows fetched in a single batch

To limit the size of the collection being populated

None

22.

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

Deselect Answer

FIRST

NEXT

PRIOR

FETCH

None

23.

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

Deselect Answer

It removes all NULL elements

It removes the last element

It raises an exception

It removes a specified number of elements from the end

None

24.

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

Deselect Answer

Nested table

VARRAY

Associative array

Linked list

None

25.

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

Deselect Answer

ADD

PUSH

EXTEND

APPEND

None

26.

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

Deselect Answer

To check if an element is a member of a collection

To iterate over the elements of a collection

To add an element to a collection

To remove an element from a collection

None

27.

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 fetch rows from the database in bulk, improving performance

To execute a cursor-based query and process the results

None

28.

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

29.

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

Deselect Answer

TRUNCATE

DELETE

REMOVE

CLEAR

None

30.

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

my_table[i]

None

31.

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

Deselect Answer

Removing elements from the middle

Extending the array's size

Adding elements with non-consecutive indexes

Assigning NULL to an element

None

32.

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 raises an exception if the collection is empty

It sets a new upper bound for the collection

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

None

33.

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

Deselect Answer

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 intersect two collections, returning the elements that are common to both

To combine two collections into a single collection, preserving duplicates

None

34.

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 the last element of the VARRAY

It raises an exception

It removes all elements but keeps the VARRAY's size

None

35.

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

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

All of the options

None

36.

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

Deselect Answer

To check if the collection is empty

To check if the collection has been initialized

To check if a specific index exists in the collection

To check if a specific value exists in the collection

None

37.

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[i]

my_array.item(i)

None

38.

Which method returns the number of elements in a collection?

Deselect Answer

CARDINALITY

SIZE

LENGTH

COUNT

None

39.

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

Option B is correct

Both option B and C are correct

Option A is correct

None

40.

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

Deselect Answer

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;

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

None

41.

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

Deselect Answer

my_array := [];

my_array := NULL;

my_array := new my_array();

my_array := my_array();

None

42.

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

Deselect Answer

A deep copy is created

Only the reference is copied

A shallow copy is created

An exception is raised

None

43.

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

Deselect Answer

To execute multiple DML statements in a single transaction

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

None

44.

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

Deselect Answer

PLS_INTEGER

DATE

VARCHAR2

BLOB

None

45.

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

Deselect Answer

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

TYPE int_array IS TABLE OF INTEGER;

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