Tested of 1z0-147 free practice test materials and faq for Oracle certification for client, Real Success Guaranteed with Updated 1z0-147 pdf dumps vce Materials. 100% PASS oracle9i program with pl/sql exam Today!

2021 Apr 1z0-147 Study Guide Questions:

Q41. Examine this package:

CREATE OR REPLACE PACKAGE discounts

IS

g_id NUMBER := 7829;

discount_rate NUMBER := 0.00;

PROCEDURE display_price (p_price NUMBER);

END discounts;

/

CREATE OR REPLACE PACKAGE BODY discounts

IS

PROCEDURE display_price (p_price NUMBER)

IS

BEGIN

DBMS_OUTPUT.PUT_LINE('Discounted '||

TO_CHAR(p_price*NVL(discount_rate, 1)));

END display_price;

BEGIN

discount_rate := 0.10;

END discounts;

/

Which statement is true?

A. The value of DISCOUNT_RATE always remains 0.00 in a session.

B. The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.

C. The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.

D. The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session.

Answer: D


Q42. Which two tables or views track object dependencies? (Choose two)

A. USER_DEPENDENCIES

B. USER_IDEPTREE

C. IDEPTREE

D. USER_DEPTREE

E. USER_DEPENDS

Answer: AC


Q43. Which two statements are true about LOBs? (Choose two.)

A. BFILES are stored in the database

B. All LOBs have read and write access

C. NCLOB represents a multi-byte character object

D. The Oracle9i server performs implicit conversions between BLOBs and NUMBER data types

E. The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types

Answer: CE


1z0-147 test preparation

Refresh vce 1z0-804:

Q44. Examine this code:

CREATE OR REPLACE TRIGGER update_emp

AFTER UPDATE ON emp

BEGIN

INSERT INTO audit_table (who, dated)

VALUES (USER, SYSDATE);

END;

You issue an UPDATE command in the EMP table that results in changing 10 rows.

How many rows are inserted into the AUDIT_TABLE?

A. 1

B. 10

C. None

D. A value equal to the number of rows in the EMP table.

Answer: A


Q45. Examine this package:

CREATE OR REPLACE PACKAGE pack_cur

IS

CURSOR c1 IS

SELECT prodid

FROM poduct

ORDER BY prodid DESC;

PROCEDURE proc1;

PROCEDURE proc2;

END pack_cur;

/

CREATE OR REPLACE PACKAGE BODY pack_cur

IS

v_prodid NUMBER;

PROCEDURE proc1 IS

BEGIN

OPEN c1;

LOOP

FETCH c1 INTO v_prodid;

DBMS_OUTPUT.PUT_LINE('Row is: ' || c1%ROWCOUNT);

EXIT WHEN c1%ROWCOUNT >= 3;

END LOOP; END proc1;

PROCEDURE proc2 IS

BEGIN

LOOP

FETCH c1 INTO v_prodid;

DBMS_OUTPUT.PUT_LINE('Row is: ' ||c1%ROWCOUNT);

EXIT WHEN c1%ROWCOUNT >= 6;

END LOOP;

CLOSE c1;

END proc2;

END pack_cur;

/

The product table has more than 1000 rows. The SQL *Plus SERVEROUTPUT setting is turned on in your session.

You execute the procedure PROC1 from SQL *Plus with the command:

EXECUTE pack_cur.proc1

What is the output in your session?

A. ERROR at line 1:

B. Row is:

Row is:

Row is:

C. Row is: 1

Row is: 2

Row is: 3

D. Row is: 4

Row is: 5

Row is: 6

Answer: C


Q46. 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. Creating the table has no effect and procedure PROCESS_CUSTOMER still accesses data from public synonym CUSTOMER table.

B. 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.

C. 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.

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.

Answer: D


1z0-147 free practice questions

Breathing 1z0-804 exam:

Q47. You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to enable all triggers on the EMPLOYEES table. Which command accomplished this?

A. You cannot enable multiple triggers on a table in one command.

B. ALTER TRIGGERS ON TABLE employees ENABLE;

C. ALTER employees ENABLE ALL TRIGGERS;

D. ALTER TABLE employees ENABLE ALL TRIGGERS;

Answer: D


Q48. Examine this code:

CREATE OR REPLACE PRODECURE add_dept

(p_dept_name VARCHAR2 DEFAULT 'placeholder',

p_location VARCHAR2 DEFAULT 'Boston')

IS

BEGIN

INSERT INTO departments

VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location);

END add_dept;

/

Which three are valid calls to the add_dep procedure? (Choose three)

A. add_dept;

B. add_dept('Accounting');

C. add_dept(, 'New York');

D. add_dept(p_location=>'New York');

Answer: ABD


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

A. Invalid objects cannot be described.

B. An object with status of invalid cannot be a referenced object.

C. The Oracle server automatically records dependencies among objects.

D. All schema objects have a status that is recorded in the data dictionary.

E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.

F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

Answer: ACF


Q50. Consider this scenario

A procedure X references a view Y that is based on a table Z .

Which two statements are true? (Choose two.)

A. Y is a referenced object

B. Z is a direct dependent of X

C. Y is a direct dependent of X

D. Y is an indirect dependent of X

E. Y is an indirect dependent of Z

F. Z is an indirect dependent of Y

Answer: AC