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.

PLSQL-Quizzes-Collections

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 : 8 November 2024

All the best!!

Name

Email

1.

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 C

Option B

Option A

Option D

None

2.

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 rows fetched in a single batch

To limit the number of iterations in the loop

To limit the execution time of the loop

None

3.

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

4.

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)

All of the options

my_table(i)

None

5.

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

Deselect Answer

NEXT

PRIOR

FETCH

FIRST

None

6.

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;

All of the above

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

None

7.

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

Deselect Answer

my_table := [];

my_table := new my_table();

my_table := NULL;

my_table := my_table();

None

8.

Which method returns the number of elements in a collection?

Deselect Answer

CARDINALITY

LENGTH

SIZE

COUNT

None

9.

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

Deselect Answer

1024

It depends on the declaration

214748347

256

None

10.

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

Deselect Answer

To collect the results of a function call into a collection

To iterate over the elements of a collection in bulk

To fetch rows from the database in bulk, improving performance

To execute multiple DML statements in a single transaction

None

11.

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 always return 1 and the collection count respectively

They return the lowest and highest index values in use

None

12.

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;

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

All of the options

None

13.

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

Deselect Answer

It removes a specified number of elements from the end

It removes the last element

It removes all NULL elements

It raises an exception

None

14.

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

Deselect Answer

To add an element to a collection

To remove an element from a collection

To check if an element is a member of a collection

To iterate over the elements of a collection

None

15.

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 D

Option B

Option A

Option C

None

16.

What is the purpose of the MULTISET UNION DISTINCT 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 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

None

17.

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

It raises a NO_DATA_FOUND exception

None

18.

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

Deselect Answer

EXTEND

PUSH

ADD

APPEND

None

19.

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

Deselect Answer

To iterate over the elements of a collection in a loop

To execute multiple DML statements in a single transaction

To retrieve data from the database in bulk

To declare and initialize a collection

None

20.

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 iterate over the elements of a collection

To fetch rows from the database in bulk, improving performance

To execute a cursor-based query and process the results

None

21.

Which collection type allows indexing by non-integer types?

Deselect Answer

VARRAY

Nested table

Associative array

All of the options

None

22.

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;

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

All of the options

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

None

23.

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

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

All of the options

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

None

24.

What is the purpose of the MULTISET EXCEPT 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

25.

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

26.

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

Deselect Answer

IS_EMPTY

COUNT

CARDINALITY

NULLIF

None

27.

What is the purpose of the LIMIT clause in a PL/SQL cursor 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

28.

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

A shallow copy is created

An exception is raised

None

29.

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

Deselect Answer

Linked list

Nested table

VARRAY

Associative array

None

30.

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

Option D

Both option B and C are correct

Option B is correct

None

31.

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 D

Option A

Option C

Option B

None

32.

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

Deselect Answer

DATE

PLS_INTEGER

BLOB

VARCHAR2

None

33.

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

Extending the array's size

Adding elements with non-consecutive indexes

None

34.

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

Deselect Answer

Nested tables can be sparse, VARRAYs cannot

Nested tables have a maximum size, VARRAYs do not

VARRAYs have a maximum size, nested tables do not

VARRAYs can be sparse, nested tables cannot

None

35.

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

Deselect Answer

32767

16383

4096

65535

None

36.

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

37.

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

Deselect Answer

CLEAR

TRUNCATE

REMOVE

DELETE

None

38.

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

39.

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

40.

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

41.

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

It sets a new upper bound for the collection

None

42.

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

To check if a specific index exists in the collection

To check if the collection is empty

None

43.

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

Deselect Answer

my_array := [];

my_array := new my_array();

my_array := NULL;

my_array := my_array();

None

44.

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

Deselect Answer

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

To execute multiple DML statements in a single transaction

To fetch rows from the database in bulk, improving performance

To collect the results of a function call into a collection

None

45.

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

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

© 2024 by TechyBuddy

Scroll to Top