TRUE OR FALSE

1/In the numeric for loop, the dummy counter does not need to be declared in declarative section.

2/In a cursor for loop, the program must explicitly use the Fetch-Into statement to get each record.

3/In the inner block, if an error occurs and is handled by one of the handlers in the exception section in this inner block, then the control will be passed to the next statement in the outer block, just as there was no error occurred.

4/A variable declared in the outer block (or say enclosing block) can be referenced in its inner blocks.

5/The cursor attribute cursor_name%rowcount returns the number (how many) of records are processed up to this moment. Thus it will be automatically increased one in each loop.

6/In an Exception section, only one exception handler is allowed.

CHOOSE THE WRONG STATEMENT

1/Please choose one and only one which is the wrong statement, or the least correct.

a)A variable of Associative array type does exist when defined, that is different from the nested table and variable size array which need to call a constructor function.

b)In defining an associative array types, the program can define a non-numeric index, such as ... index by varchar2 (20) .

c)Varrays are always dense, so the delete method is not allowed.

d)The method of NEXT(i) will return the value of the index of the next element of i in the collection.

e)For a nested table, at the moment it is initially created and populated, some internal elements may be deleted, thus it is sparse at its birth.

2/Please choose one and only one which is the wrong statement, or the least correct.

a)All system (internally) defined errors have its own error code (number), and an error message.

b)For those system internally defined errors with predefined names, when these errors occur in a program, the system engine will not automatically raise the exception any more because they have the names.

c)A user defined exceptions, initially it has no individual code number, only has a name.

d)The system engine will not detect/raise a user defined exception.

e)Among thousands system internally defined exceptions, there are around 23 are given names by the system. For these 23, the programmer may write correspondent handler in the exception section.