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
g_id NUMBER := 7829;
discount_rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
CREATE OR REPLACE PACKAGE BODY discounts
PROCEDURE display_price (p_price NUMBER)
discount_rate := 0.10;
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.
Q42. Which two tables or views track object dependencies? (Choose two)
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
Refresh vce 1z0-804:
Q44. Examine this code:
CREATE OR REPLACE TRIGGER update_emp
AFTER UPDATE ON emp
INSERT INTO audit_table (who, dated)
VALUES (USER, SYSDATE);
You issue an UPDATE command in the EMP table that results in changing 10 rows.
How many rows are inserted into the AUDIT_TABLE?
D. A value equal to the number of rows in the EMP table.
Q45. Examine this package:
CREATE OR REPLACE PACKAGE pack_cur
CURSOR c1 IS
ORDER BY prodid DESC;
CREATE OR REPLACE PACKAGE BODY pack_cur
PROCEDURE proc1 IS
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
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' ||c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 6;
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:
What is the output in your session?
A. ERROR at line 1:
B. Row is:
C. Row is: 1
Row is: 2
Row is: 3
D. Row is: 4
Row is: 5
Row is: 6
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.
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;
Q48. Examine this code:
CREATE OR REPLACE PRODECURE add_dept
(p_dept_name VARCHAR2 DEFAULT 'placeholder',
p_location VARCHAR2 DEFAULT 'Boston')
INSERT INTO departments
VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location);
Which three are valid calls to the add_dep procedure? (Choose three)
C. add_dept(, 'New York');
D. add_dept(p_location=>'New York');
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.
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