Explore topic-wise MCQs in Technical MCQs.

This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.

1.

Maximum size of a varray can be changed using the __________ statement.

A. REPLACE TYPE
B. CREATE TYPE
C. ALTER TYPE
D. ELEMENT TYPE
E.
Answer» D. ELEMENT TYPE
Discussion
2.

What is TRUE about PL/SQL functionalities?

A. Conditions and loops are fundamental elements of procedural languages like PL/SQL.
B. Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types
C. Arrays can be used with it as well as handling exceptions (runtime errors)
D. All of the above
Answer» E.
Discussion
3.

All varrays consist of ___________ memory locations.

A. simple
B. contiguous
C. linear
D. None of the above
Answer» C. linear
Discussion
4.

A varray is automatically _______.

A. blank
B. zero
C. one
D. null
Answer» B. zero
Discussion
5.

Varrays are ___________ arrays.

A. one-dimensional
B. two-dimensional
C. multi-dimensional
D. None of the above
Answer» B. two-dimensional
Discussion
6.

The _________ corresponds to the first element.

A. middle address
B. highest address
C. lowest address
D. None of the above
Answer» D. None of the above
Discussion
7.

varray_type_name is a valid attribute name,

A. Yes
B. No
C. Can be true or false
D. Can not say
Answer» B. No
Discussion
8.

A varray type is created with the _________ statement.

A. REPLACE TYPE
B. CREATE TYPE
C. ELEMENT TYPE
D. ALTER TYPE
Answer» C. ELEMENT TYPE
Discussion
9.

A varray is used to store an ordered collection of data.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
Answer» B. FALSE
Discussion
10.

The PL/SQL programming language provides a data structure called the ________.

A. ARRAY
B. MARRAY
C. VARRAY
D. DARRAY
Answer» D. DARRAY
Discussion