Online Access Free 1Z0-147 Exam Questions

When creating a function in SQL *Plus, you receive this message:
"Warning: Function created with compilation errors."
Which command can you issue to see the actual error message?

• A.SHOW ERRORS
• B.SHOW USER_ERRORS
• C.SHOW ALL_ERRORS
• D.SHOW FUNCTION_ERROR

A dependent procedure or function directly or indirectly references one or more of which four objects? (Choose four)

• A.view
• B.packaged procedure or function
• C.procedure
• D.privilege
• E.anonymous block
• F.sequence

When creating a function, in which section will you typically find the RETURN keyword?

• A.DECLARATIVE
• B.HEADER only
• C.EXECUTABLE and HEADER
• D.DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING

Examine this code
CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2)
IS
V_file BFILE;
V_filename VARCHAR2 (16);
CURSOR emp_cursor IS
SELECT employee_id
FROM employees
WHERE Job_id = 'IT_PROG'
FOR UPDATE;
BEGIN
FOR emp_record IN emp_cursor LOOP
V_filename:= emp_record.employee_id || '.GIF';
V_file := BFILENAME(p_flle_loc, v_filename);
END LOOP;
END;
/
What does the BFILENAME function do?

• A.It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system
• B.It checks for the existence of an external BFILE
• C.It reads data from an external BFILE
• D.It creates a directory object for use with the external BFILEs

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

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