Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part I. Please choose True or False for following questions ( 2 points for each question ) In the numeric for loop, system will take

Part I. Please choose True or False for following questions (2 points for each question)
In the numeric for loop, system will take care of the increasing of the dummy counter, thus if the program changes the dummy counter, that will cause an error.
In a cursor for loop, the program should not use the Fetch into statement to get each record.
The variables declared in the outer block (or say enclosing block) cannot be referenced in its inner blocks.
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 exception section in the outer block.
The cursor attribute cursor_name%rowcount returns the total number (how many) of records that returns by the cursor.
In an exception section, the program may have many exception handlers.
Part II. Multiple choices. (4 points for each question). Please choose one and only one which is the wrong statement, or the least correct.
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.
(b) Generally speaking, a program will call constructor functions to initialize the variables of nested tables and varray type.
(c) In defining Associative array types, the syntax such as "... index by varchar2(20)" is allowed.
(d) Varrays are always dense, delete method is allowed.
(e) The method of NEXT(i) will return the value of the element next to i.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Image Databases Towards Advanced Image Retrieval

Authors: Yihong Gong

1st Edition

1461375037, 978-1461375036

More Books

Students also viewed these Databases questions

Question

What advice would you provide to Jennifer?

Answered: 1 week ago

Question

What are the issues of concern for each of the affected parties?

Answered: 1 week ago