databases Online Quiz - 65
|Description: databases Online Quiz - 65|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
In a PL/SQL block structure, which parts are optional?
If the Oracle Engine for its internal processing has opened a cursor they are known as _________
You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?
How do you handle an Exception?
Which two statements about packages are true? (Choose two)
A function must return zero or more values to its calling environment, whereas a procedure returns a value to the calling environment.
Identifiers defined only in the package body are public constructs. These are visible outside the package body
Which three are valid ways to minimize dependency failure? (Choose three)