Our Oracle Oracle exam dumps aims to see whether you have mastered the information points firmly. We provide the Oracle software with regard to free soon after purchase. In the event you have absolutely no idea concerning the Oracle Oracle exam preparation, our 1z0-147 merchandise will be your current study information. If you fail your 1z0-147 exam after employing our merchandise, we can arrange you a new full refund. Examcollection gives you 7/24 customer on the internet support to solve your current problems.

2016 Sep 1z0-147 answers

Q21. You need to remove the database triggerBUSINESS_HOUR.Which command do you use to remove the trigger in the SQL *Plus environment?

A. DROP TRIGGER business_hour;

B. DELETE TRIGGER business_hour;

C. REMOVE TRIGGER business_hour;

D. ALTER TRIGGER business_hour REMOVE;

E. DELETE FROM USER_TRIGGERS

WHERE TRIGGER_NAME = 'BUSINESS_HOUR'

Answer: A


Q22. Examine this package:

CREATE OR REPLACE PACKAGE manage_emps

IS

tax_rate CONSTANT NUMBER(5,2) := .28;

v_id NUMBER;

PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER);

PROCEDURE delete_emp;

PROCEDURE update_emp;

FUNCTION calc_tax (p_sal NUMBER)

RETURN NUMBER;

END manage_emps;

/

CREATE OR REPLACE PACKAGE BODY manage_emps

IS

PROCEDURE update_sal

(p_raise_amt NUMBER)

IS

BEGIN

UPDATE emp

SET sal = (sal * p_raise_emt) + sal

WHERE empno = v_id;

END;

PROCEDURE insert_emp

(p_deptno NUMBER, p_sal NUMBER)

IS

BEGIN

INSERT INTO emp(empno, deptno, sal)

VALYES(v_id, p_depntno, p_sal);

END insert_emp;

PROCEDURE delete_emp

IS

BEGIN

DELETE FROM emp

WHERE empno = v_id;

END delete_emp;

PROCEDURE update_emp

IS

v_sal NUMBER(10, 2);

v_raise NUMBER(10, 2);

BEGIN

SELECT sal

INTO v_sal

FROM emp

WHERE empno = v_id;

IF v_sal < 500 THEN

v_raise := .05;

ELSIP v_sal < 1000 THEN

v_raise := .07;

ELSE

v_raise := .04; END

IF;

update_sal(v_raise);

END update_emp;

FUNCTION calc_tax

(p_sal NUMBER)

RETURN NUMBER

IS

BEGIN

RETURN p_sal * tax_rate;

END calc_tax;

END manage_emps;

/

What is the name of the private procedure in this package?

A. CALC_TAX

B. INSERT_EMP

C. UPDATE_SAL

D. DELETE_EMP

E. UPDATE_EMP

F. MANAGE_EMPS

Answer: C


Q23. Examine this code:

CREATE OR REPLACE PROCEDURE audit_action

(p_who VARCHAR2)

AS

BEGIN

INSERT INTO audit(schema_user) VALUES(p_who);

END audit_action;

/

CREATE OR REPLACE TRIGGER watch_it

AFTER LOGON ON DATABASE

CALL audit_action(ora_login_user)

/

What does this trigger do?

A. The trigger records an audit trail when a user makes changes to the database.

B. The trigger marks the user as logged on to the database before an audit statement is issued.

C. The trigger invoked the procedure audit_action each time a user logs on to his/her schema and adds the username to the audit table.

D. The trigger invokes the procedure audit_action each time a user logs on to the database and adds the username to the audit table.

Answer: D


Q24. Which four triggering events can cause a trigger to fire? (Choose four)

A. A specific error or any errors occurs.

B. A database is shut down or started up.

C. A specific user or any user logs on or off.

D. A user executes a CREATE or an ALTER table statement.

E. A user executes a SELECT statement with an ORDER BY clause.

F. A user executes a JOIN statement that uses four or more tables.

Answer: ABCD


Q25. The OLD and NEW qualifiers can be used in which type of trigger?

A. Row level DML trigger

B. Row level system trigger

C. Statement level DML trigger

D. Row level application trigger

E. Statement level system trigger

F. Statement level application trigger

Answer: A


certifyforall.com

Updated 1z0-147 rapidshare:

Q26. Examine this package

CREATE OR REPLACE PACKAGE discounts

IS

g_id NUMBER := 7839;

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 NUMBERI)

IS

BEGIN

DBMS_OUTPUT.PUT LINE ( 'Discounted '||

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

END display_price;

BEGIN

Discount_rate = 0.10;

END discounts;

/

The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure DISPLAY_PRICE from SQL*Plus with the command EXECUTE discounts. display_price (100);

What is the result?

A. Discounted 10

B. Discounted 100

C. Discounted 0.00

D. Discounted NULL

E. Discounted 0.10

Answer: A


Q27. Which two program declarations are correct for a stored program unit? (Choose two)

A. CREATE OR REPLACE FUNCTION tax_amt

(p_id NUMBER)

RETURN NUMBER

B. CREATE OR REPLACE PROCEDURE tax_amt

(p_id NUMBER)

RETURN NUMBER

C. CREATE OR REPLACE PROCEDURE tax_amt

(p_id NUMBER, p_amount OUT NUMBER)

D. CREATE OR REPLACE FUNCTION tax_amt

(p_id NUMBER)

RETURN NUMBER(10,2)

E. CREATE OR REPLACE PROCEDURE tax_amt

(p_id NUMBER, p_amount OUT NUMBER(10, 2))

Answer: AC


Q28. To be callable from a SQL expression, a user-defined function must do what?

A. Be stored only in the database.

B. Have both IN and OUT parameters.

C. Use the positional notation for parameters.

D. Return a BOOLEAN or VARCHAR2 data type.

Answer: C


Q29. 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 the command :X := CALCTAX(1000);.

D. You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALCTAX;

E. You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALCTAX(1000);

Answer: E


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