PRO - PL SQL Programming - Theory

What is the clause that differentiates creating an associative array from other collections?

1 Mark(s)

INDEX BY
INDEXED BY
INDEX OF
INDEX WITH

How is a mixed notation used for matching formal and actual parameters?

1 Mark(s)

First two parameters is by position and others are by names
Any number of parameters can be passed by position and the rest are passed by names
First parameter is by position and others are by names
Last parameter is by position and others are by names

How are the elements of a collection variable accessed?

1 Mark(s)

variable_name[index]
variable_name(index)
variable_name.index
variable_name{index}

What happens when we execute two subprograms that cannot be overloaded?

1 Mark(s)

Compile time error
Compile time warning
Run time error
Run time warning

Which are the optional parts of a formal parameter declaration?

1 Mark(s)

Name, Datatype, Mode and default value
Datatype, Mode and default value
Mode and default value
Default value only

How is the formal parameter treated when the mode of the parameter is IN OUT?

1 Mark(s)

Formal parameter acts like an uninitialized value.
Formal parameter is initialized to the default value of its type
Formal parameter acts like an initialized variable
Formal parameter acts like a constant.

What is the lower bound of a varray index?

1 Mark(s)

1
0
-1
There is no fixed lower bound

Where should a varray 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 randomly
For huge tables where there are lot of DML activity

Which of the following can be used to create a collection variable?

1 Mark(s)

%TYPE
%ROWTYPE
%DECLARE
%ISTYPE

What are the types of composite datatypes?

1 Mark(s)

Records and Nested table
Collections and BOOLEAN
Collections, PLS_INTEGER and BOOLEAN
Collections and Records

What is the upper bound of a varray index?

1 Mark(s)

Maximum number of elements defined
current number of elements in the array
Unlimited
Maximum number of elements defined - Current number of elements in the array

Which of the following statement is true for a collection?

1 Mark(s)

In a collection, the internal components always have the same data type.
In a collection, the internal components always have different data type
In a collection, the internal components may have the same data type or different datatype
All collection except records have the same datatype

Where can overloaded subprograms be used in PL/SQL?

1 Mark(s)

Anywhere in PL/SQL
Inside an anonymous block only
Inside the declaration section of a PL/SQL block or inside a package
Inside a package only

What is the statement to remove a procedure from a database?

1 Mark(s)

ALTER PROCEDURE
DROP PROCEDURE
DELETE PROCEDURE
TRUNCATE procedure.

What are the different types of composite datatypes in PL/SQL?

1 Mark(s)

Associative array or Nested tables only
Associative array, Varray and Nested tables
Associative array, Varray ,Nested tables and Records
Associative array and Records only

Which of the following subprograms cannot be overloaded?

1 Mark(s)

Nested subprogram
Standalone subprogram
Package subprogram
Nested and Package subprogram

What is the method by which parameters are passed when the actual and formal parameters refer to the same memory location?

1 Mark(s)

By Reference
By Value
By copy
By default values

What are the two different types of values for a parameter?

1 Mark(s)

Default and System given
Default and user given
System given and user given
Compile time and run time values

What are overloaded subprograms?

1 Mark(s)

Two or more subprograms that can have the same name with different parameter lists
Two subprograms that can have different name with different parameter lists.
Two or more subprograms that can have the same name with same parameter lists
Two or more subprograms that can have different name with same parameter lists.

Which of the following function gives the number of elements in an associative array?

1 Mark(s)

MAX
MAXIMUM
COUNT
TOTAL

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