Unformatted text preview: iew to see the compilation errors.
C. If errors occur during the compilation of a trigger you can use the SHOW ERRORS
command within iSQL *Plus to see the compilation errors.
D. If errors occur during the compilation of a trigger you can go into SQL *Plus and
query the USER_ERRORS data dictionary view to see compilation errors.
Answer: A, C, D
A: If there is a compilation error in the CREATE TRIGGER statement, the trigger is still
C: You may view the compilation errors in SQL*Plus by issuing the SHOW ERRORS
D: The TEXT column of the USER_ERRORS View contains the compilation errors.
The LINE Column stored the LINE number of the error and the POSITION
column contains the character POSITION of the LINE identified in the line
QUESTION 14: Which two dictionary views track dependencies? (Choose two)
Answer: D, E
D: DEPTREE_TEMPTAB is a temporary table used to store dependency information
returned by the DEPTREE_FILL procedure.
Actualtests.com - The Power of Knowing 1Z0-147
E: USER_DEPENDECIES is used to display direct dependencies. ALL
_DEPENDENCIES and DBA_DEPENDENCIES also store dependency information.
A: USER_SOURCE describes the text source of the stored objects owned by the current
B: UTL_DEPTREE is not a valid data dictionary view.
C: USER_OBJECTS contains basic information about all objects owned by the current
user, but does not contain dependency information
F: DBA_DEPENDENT_OBJECTS this is not a valid data dictionary view however there
is a DBA_DEPENDENCIES view
QUESTION 15: Given a function CALCTAX:
CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN
RETURN (sal * 0.05);
If you want to run the above function from the SQL *Plus
prompt, which statement is true?
A. You need to execute the command CALCTAX(1000);.
B. You need to execute the command EXECUTE FUNCTION calctax;
C. You need to create a SQL *Plus environment variable X and issue th...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09