Try and practice the latest Oracle : 1Z0-147 real questions & answers

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

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

There is a CUSTOMER table in a schema that has a public synonym CUSTOMER and you are granted all object privileges on it. You have a procedure PROCESS_CUSTOMER that processes customer information that is in the public synonym CUSTOMER table. You have just created a new table called CUSTOMER within your schema. Which statement is true?

• A. If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER is invalidated and gives compilation errors.
• B. If the structure of your CUSTOMER table is entirely different from the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles and accesses your CUSTOMER table.
• C. Creating the table has no effect and procedure PROCESS_CUSTOMER still accesses data from public synonym CUSTOMER table.
• D. If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles when invoked and accesses your CUSTOMER table.

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

Examine this code:
CREATE OR REPLACE FUNCTION gen_email_name
(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER)
RETURN VARCHAR2
IS
v_email_name VARCHAR2(19=;
BEGIN
v_email_name := SUBSTR(p_first_name, 1, 1) ||
SUBSTR(p_last_name, 1, 7) ||
'@Oracle.com';
UPDATE employees
SET email = v_email_name
WHERE employee_id = p_id;
RETURN v_email_name;
END;
Which statement removes the function?

• A. DROP FUNCTION gen_email_name;
• B. ALTER FUNCTION gen_email_name REMOVE;
• C. REMOVE gen_email_name;
• D. DELETE gen_email_name;
• E. TRUNCATE gen_email_name;

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

Which three are true statements about dependent objects? (Choose three)

• A. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
• B. The Oracle server automatically records dependencies among objects.
• C. Invalid objects cannot be described.
• D. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.
• E. An object with status of invalid cannot be a referenced object.
• F. All schema objects have a status that is recorded in the data dictionary.

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

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

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

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).