♥♥ 2017 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-147 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
1z0-147 Product Description:
Exam Number/Code: 1z0-147 vce
Exam name: oracle9i program with pl/sql
n questions with full explanations
Certification: Oracle Certification
Last updated on Global synchronizing
Accurate of 1z0-147 practice test materials and discount pack for Oracle certification for IT examinee, Real Success Guaranteed with Updated 1z0-147 pdf dumps vce Materials. 100% PASS oracle9i program with pl/sql exam Today!
2016 May 1z0-147 Study Guide Questions:
Q1. You want to create a PL/SQL block of code that calculates discounts on customer orders. –This code will be invoked from several places, but only within the program unit ORDERTOTAL.
What is the most appropriate location to store the code that calculates the discounts?
A. A stored procedure on the server.
B. A block of code in a PL/SQL library.
C. A standalone procedure on the client machine.
D. A block of code in the body of the program unit ORDERTOTAL.
E. A local subprogram defined within the program unit ORDERTOTAL.
Q2. Examine this procedure:
CREATE OR REPLACE PROCEDURE DELETE_PLAYER
(V_ID IN NUMBER)
DELETE FROM PLAYER
WHERE ID = V_ID;
('Cannot delete this player, child records exist in PLAYER_BAT_STAT table');
What prevents this procedure from being created successfully?
A. A comma has been left after the STATS_EXIST_EXCEPTION exception.
B. The STATS_EXIST_EXCEPTION has not been declared as a number.
C. The STATS_EXIST_EXCEPTION has not been declared as an exception.
D. Only predefined exceptions are allowed in the EXCEPTION section.
Q3. Which three are true regarding error propagation? (Choose three)
A. An exception cannot propagate across remote procedure calls.
B. An exception raised inside a declaration immediately propagates to the current block.
C. The use of the RAISE; statement in an exception handler reraises the current exception.
D. An exception raised inside an exception handler immediately propagates to the enclosing block.
Abreast of the times comptia it fundamentals fc0-u51:
Q4. 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.
Q5. 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
Q6. You have a table with the following definition:
CREATE TABLE long_tab
You need to convert the LONG_COL column from a LONG data type to a LOB data type. Which statement accomplish this task?
A. ALTER TABLE long_tab
MODIFY (LONG_COL CLOB);
B. EXECUTE dbms_lob.migrate(long_tab, long_col, clob)
C. EXECUTE dbms_manage.lob.migrate(long_tab, long_col, clob)
D. EXECUTE utl_lob.migrate(long_tab, long_col, clob)
E. EXECUTE utl_manage_lob.migrate(long_tab, long_col, clob)
Pinpoint comptia it fundamentals study guide exam fc0-u51:
Q7. Which type of argument passes a value from a procedure to the calling environment?
Q8. 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.
Q9. 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.
Q10. The creation of which database objects will cause a DDL trigger to fire? (Choose all that apply)
G. Database links
see more oracle9i program with pl/sql