Array MCQ Questions And Answers

Array MCQs : This section focuses on "Array" in Pl/Sql. These Multiple Choice Questions (MCQ) should be practiced to improve the Pl/Sql skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.

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

A. ARRAY
B. MARRAY
C. VARRAY
D. DARRAY

View Answer


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

View Answer


3. A varray type is created with the _________ statement.

A. REPLACE TYPE
B. CREATE TYPE
C. ELEMENT TYPE
D. ALTER TYPE

View Answer


4. varray_type_name is a valid attribute name,

A. Yes
B. No
C. Can be true or false
D. Can not say

View Answer


5. The _________ corresponds to the first element.

A. middle address
B. highest address
C. lowest address
D. None of the above

View Answer


6. Varrays are ___________ arrays.

A. one-dimensional
B. two-dimensional
C. multi-dimensional
D. None of the above

View Answer


7. A varray is automatically _______.

A. blank
B. zero
C. one
D. null

View Answer


8. All varrays consist of ___________ memory locations.

A. simple
B. contiguous
C. linear
D. None of the above

View Answer


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

View Answer


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

A. REPLACE TYPE
B. CREATE TYPE
C. ALTER TYPE
D. ELEMENT TYPE

View Answer





Discussion


* You must be logged in to add comment.