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.
2021 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'
Q22. Examine this package:
CREATE OR REPLACE PACKAGE manage_emps
tax_rate CONSTANT NUMBER(5,2) := .28;
PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER);
FUNCTION calc_tax (p_sal NUMBER)
CREATE OR REPLACE PACKAGE BODY manage_emps
SET sal = (sal * p_raise_emt) + sal
WHERE empno = v_id;
(p_deptno NUMBER, p_sal NUMBER)
INSERT INTO emp(empno, deptno, sal)
VALYES(v_id, p_depntno, p_sal);
DELETE FROM emp
WHERE empno = v_id;
v_sal NUMBER(10, 2);
v_raise NUMBER(10, 2);
WHERE empno = v_id;
IF v_sal < 500 THEN
v_raise := .05;
ELSIP v_sal < 1000 THEN
v_raise := .07;
v_raise := .04; END
RETURN p_sal * tax_rate;
What is the name of the private procedure in this package?
Q23. Examine this code:
CREATE OR REPLACE PROCEDURE audit_action
INSERT INTO audit(schema_user) VALUES(p_who);
CREATE OR REPLACE TRIGGER watch_it
AFTER LOGON ON DATABASE
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.
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.
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
Updated 1z0-147 rapidshare:
Q26. Examine this package
CREATE OR REPLACE PACKAGE discounts
g_id NUMBER := 7839;
discount _rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
CREATE OR REPLACE PACKAGE BODY discounts
PROCEDURE display_price (p_price NUMBERI)
DBMS_OUTPUT.PUT LINE ( 'Discounted '||
Discount_rate = 0.10;
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
Q27. Which two program declarations are correct for a stored program unit? (Choose two)
A. CREATE OR REPLACE FUNCTION tax_amt
B. CREATE OR REPLACE PROCEDURE tax_amt
C. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER)
D. CREATE OR REPLACE FUNCTION tax_amt
E. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER(10, 2))
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.
Q29. Given a function CALCTAX:
CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBER
RETURN (sal * 0.05);
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);
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.