C if errors occur during the compilation of a trigger

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 Explanation: A: If there is a compilation error in the CREATE TRIGGER statement, the trigger is still created. C: You may view the compilation errors in SQL*Plus by issuing the SHOW ERRORS command. 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 COLUMN. QUESTION 14: Which two dictionary views track dependencies? (Choose two) A. USER_SOURCE B. UTL_DEPTREE C. USER_OBJECTS D. DEPTREE_TEMPTAB E. USER_DEPENDENCIES F. DBA_DEPENDENT_OBJECTS Answer: D, E Explanation: 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. Incorrect answers A: USER_SOURCE describes the text source of the stored objects owned by the current user 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 NUMBER IS BEGIN RETURN (sal * 0.05); END; 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.

Ask a homework question - tutors are online