Which is the correct answer to the following questions?

---

Which is the correct
answer to the following questions?


1.
Which statement about triggers is true?

A. You use an application trigger to tire when a DELETE
statement occurs.
B. You use a database trigger to tire when an INSERT statement occurs.
C. You use a system event trigger to tire when an UP[)ATE
statement occurs.
D. You use INSTEAD OF trigger to fire when a SELECT statement occurs.

2.
You want to create a PL/SQL block of code that
calculates discounts on customer orders. В—This code will he 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?

A. A stored procedure on the server.
B. A block of code in a
PL!SQL library.
C. A standalone procedure on the client machine.
D. A block of code in the body of the program unit ORDERTOTAL.
E. A local
subprogram defined within the program unit ORDEPTOTAL.


3.
Which type of argument passes a value from a procedure to the calling
environment?

A. VARCHAR2
B. BOOLEAN
C. OUT
D. IN



4.
To be callable from a SQL expression, a user-defined function must do
what?

A. Be stored only in the database.
B. Have both IN and OUT parameters.
C. Use the positional notation for parameters.
D. Return a
BOOLEAN or VARCHAR2 data type.


5.
Which two describe a stored procedure? (Choose two)

A. A stored procedure is typically written in
SQL.
B. A stored procedure is a named PL/SQL block that can accept parameters.
C. A stored procedure is a type of PL/SQI. subprogram that performs
an action.
D. A stored procedure has three parts: the specification, the body. and the exception handler part.
E. The executable section of a
stored procedure contains statements that assigns values, control execution, and return values to the calling environment.

6.
Which three are
valid ways to minimize dependency failure? (Choose three)

A. Querying with the SELECT * notification
B. Declaring variables with the %TYPE
attribute.
C. Specifying schema names when referencing objects.
D. Declaring records by using the %ROWTYPH attribute.
H. Specifying
package.procedure notation while executing procedures.


7.
Which two dopes the INSTEAD OF clause in a trigger identify? (Choose two)

A. The
view associated with the trigger.
B. The table associated with the trigger.
C. The event associated with the trigger.
D. The package associated
with the trigger.
H. The statement level or for each row association to the trigger.


8.
What can you do with the DBMS_LOB package?

A. Use
the DBMS LOB. WRITE procedure to write data to a BFILE.
B. Use the DBMS _ LOB . BFILENAME function to locate an external BFILE.
C. Use the
DBMS_LOB. FILEEXISTS function to find the location of a BFILE.
D. Use the DBMS LOB. FILECLOSE procedure to close the file being
accessed.


9.
Which view displays indirect dependencies, indenting each dependency?

A. DEPTREE
B. IDEPTREE
C. INDENT_TREE
D.
I_DEPT_TREE


10.
Which statement is true?

A. Stored functions can be called from the SELECT and WHERE clauses only.
B. Stored Function do
not permit calculations that involve database links in a distributed environment.
C. Stored Functions cannot manipulate new types of data, such as
longitude and latitude.
D. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the
application.


11.
Under which two circumstances do you design database triggers? (Choose two)

A. To duplicate the functionality of other
triggers.
B. To replicate built-in constraints in the Oracle server such as primary key and foreign key.
C. To guarantee that when a specific
operation is performed, related actions are performed.
D. For centralized , global operations that should be fired for the triggering statement,
regardless of which user or application issues the statement.