All of the following represent restrictions on functions, except ____.

A. Functions cannot modify any tables in Oracle8 and prior versions.
B. Functions cannot be used in a CHECK constraint or as a default value of a table column.
C. If used in a local operation, no reading or writing of packaged variables is allowed.
D. If used in a SELECT, VALUES, or SET clause, the function can write values to packaged variables; otherwise, it is not allowed.


Answer: C

Business

You might also like to view...

Condolence messages should

A) focus on your own sense of loss. B) avoid referring to the deceased. C) be short, simple, and sincere. D) always be sent via electronic media. E) focus on your relationship with the deceased.

Business

________ sources of information are those that are retrieved from memory

A) Internal B) Permanent C) Extrinsic D) Adscititious

Business

Under a ________ new product development approach, company departments work closely together in cross-functional groups, overlapping the steps in the product development process to save time and increase effectiveness

A) cross-sectional B) simultaneous C) sequential D) team-based E) systematic

Business

A company's promotion strategy determines how much the company will charge for its products

Indicate whether the statement is true or false

Business