1z0-147 9i Internet Application Developer Braindump
ExamSoon 1z0-147 Exams
Oracle oracle9i program with pl/sql
O rder : 1z0-147 Exam
Practice Exam: 1z0-147
Exam Number/Code: 1z0-147
Exam Name: oracle9i program with pl/sql
Questions and Answers: 132 Q&As
Free 1z0-147 Braindumps
Exam : Oracle 1Z0-147
Title : Oracle9i Program with PL/SQL
1. Procedure PROCESS_EMP references the table EMP . Procedure UPDATE_EMP updates rows of table EMP
through procedure PROCESS_EMP . There is a remote procedure QUERY_EMP that queries the EMP table through
the local procedure PROCESS_EMP . The dependency mode is set to TIMESTAMP in this session. Which two
statements are true? (Choose two.)
A. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is
invalidated.
B. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets
invalidated and will recompile when invoked for the first time.
C. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets
invalidated and will recompile when invoked for the first time.
D. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets
invalidated and will recompile when invoked for the first time.
E. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets
invalidated and will recompile when invoked for the second time.
Answer: BE
2. You have a table with the following definition: CREATE TABLE long_tab (id NUMBER, long_col LONG); You need
to convert the LONG_COL column from a LONG data type to a LOB data type. Which statement accomplishes 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)
Answer: A
3. Examine this package: CREATE OR REPLACE PACKAG