PRO - PL SQL Programming - Theory

How many times does a PL/SQL engine access the database to fetch 100 rows using BULK SQL?

1 Mark(s)

Twice
Once
Hundred times
One to 10 times depending on the batch size

Which of the following is the correct syntax to use BULK COLLECT with SELECT INTO statement?

1 Mark(s)

SELECT column_names BULK COLLECT INTO collection_type FROM table_name
SELECT column_names INTO BULK COLLECT collection_type FROM table_name
SELECT BULK column_names COLLECT INTO collection_type FROM table_name
SELECT BULK COLLECT column_names INTO collection_type FROM table_name

Where should a nested table be used?

1 Mark(s)

As a small look-up table
When the maximum number of elements of the collection is known
When the elements of the collection are accessed sequentially
When index values are not consecutive and Some elements must be deleted or updated but not all elements simultaneously

Which of the following collections have an unitialized status as empty?

1 Mark(s)

Associative array
Varray
Nested table
Records

What is the main difference in the syntax of creating a nested table from that of an associative array?

1 Mark(s)

No INDEX BY clause in Nested table
No INDEX BY clause in Associative array
No INDEXED BY clause in Nested table
No INDEX clause in Associative array

Where can a BULK COLLECT clause be used?

1 Mark(s)

SELECT INTO statement and FETCH statement
RETURNING INTO clause and SELECT INTO statement
FORALL statement and SELECT INTO statement
SELECT INTO statement,RETURNING INTO statement and FETCH statement

How can a varray variable be assigned values?

1 Mark(s)

Collection constructor or assignment statement or through a subprogram
Through a subprogram only
Collection constructor or assignment statement only
Collection constructor or subprogram only

Which of the following collections can be stored in the database?

1 Mark(s)

Associative array and Varray
Varray and nested table
Associative array and nested table
Associative array,Varray and nested table

Where can a Varray be stored?

1 Mark(s)

At package or at the schema level.
PL/SQL block or at the schema level.
PL/SQL block or at the package level
PL/SQL block or package or at the schema level

What is the only collection that does not return NULL value for LIMIT method?

1 Mark(s)

Associative array
Varray
Nested table
Records

What is the result of EXISTS(n)if n is out of range?

1 Mark(s)

FALSE
Error
NULL
TRUE

What is the best method to access element of a varray?

1 Mark(s)

By first obtanining the index of the elements
Random manner
Sequentially
Using a pointer to locate the place of the element

Which of the following is not the property of a nested table?

1 Mark(s)

Homogenous
Bounded
One dimensional
Initially dense

When is "INDICES OF collection_name" used in a FORALL statement?

1 Mark(s)

To use sparse nested tables
To access any collection element
To use dense nested table
Never. It should be sued with BULK COLLECT only

What is a multi-dimensional nested table?

1 Mark(s)

A multidimensional nested table can be modeled with a nested table whose elements are either nested table or associative array or varray.
A multidimensional nested table can be modeled with a nested table whose elements are nested table only.
A multidimensional nested table can be modeled with a nested table whose elements are either associative array or varray only.
A multidimensional nested table can be modeled with a nested table whose elements are records only

What can be present in the body of a FORALL statement ?

1 Mark(s)

One or more DML statements
A single DML statement
A single SELECT or DML statement
One or more SELECT statement

Which of the following is not a characteristics of EXTEND method?

1 Mark(s)

EXTEND operates on the internal size of a collection.
If DELETE deletes an element but keeps a placeholder for it, then EXTEND considers the element to exist
EXTEND adds elements to the beginning of a collection
There are three forms of EXTEND procedure

Where are nested tables available?

1 Mark(s)

Only in database
Only in PL/SQL
In PL/SQL and in database
In SQL and PL/SQL

While using a collection constructor to assign values, what happens If the parameter list of the collection constructor is empty?

1 Mark(s)

Throws an error
Nothing happens
Returns an empty collection.
Returns a NULL collection

What is the state of an uninitialized nested table variable?

1 Mark(s)

Empty
Undefined
Null collection
Error

PRO - PL SQL Programming - Theory - 6 : Question 1 of 20