1z0-101 Exam

Quality and Value for the 1z0-101 Exam

Test4pass Practice Exams for Oracle 1z0-101 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1z0-101 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the 9i Internet Application Developer 1z0-101 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1z0-101 Downloadable, Printable Exams (in PDF format)

Our Exam 1z0-101 Preparation Material provides you everything you will need to take your 1z0-101 Exam. The 1z0-101 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

1z0-101 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Oracle 1z0-101 Exam will provide you with free 1z0-101 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 1z0-101 Exam:100% Guarantee to Pass Your 9i Internet Application Developer exam and get your 9i Internet Application Developer Certification.

Hot KeyWords On 1z0-101 test

We collect some hot keywords about this exam:
Test4pass , Pass 4 Sure , Test in Side ,Pass Guide ,Test King 1z0-101 exam | 1z0-101 pdf exam | 1z0-101 braindumps | 1z0-101 study guides | 1z0-101 trainning materials | 1z0-101 simulations | 1z0-101 testing engine | 1z0-101 vce | 1z0-101 torrent | 1z0-101 dumps | free download 1z0-101 | 1z0-101 practice exam | 1z0-101 preparation files | 1z0-101 questions | 1z0-101 answers.

How to pass your 1z0-101 exam

You can search on Search Engine and Find Best IT Certification site: Test4pass.com - Find the Method to succeed 1z0-101 test,The safer.easier way to get 9i Internet Application Developer Certification .

��
��
Exam : Oracle 1Z0-101
Title : Develop Pl/Sql Program Units


1. The number of cascading triggers is limited by which database initialization parameter?
A. CASCADE_TRIGGER_CNT
B. OPEN_CURSORS
C. OPEN_TRIGGERS
D. OPEN_DB_TRIGGERS
Answer: B

2. The programmer who developed a procedure ACCOUNT_TRANSACTION left the organization. You are assigned the task of modifying this procedure. You want to find all the program units invoking the ACCOUNT_TRANSACTION procedure. How can you find this information?
A. Query the USER_SOURCE data dictionary view.
B. Query the USER_PROCEDURES data dictionary view.
C. Query the USER_DEPENDENCIES data dictionary view.
D. Set the SQL*Plus environment variable TRACECODE=TRUE and run the ACCOUNT_TRANSACTION procedure.
E. Set the SQL*Plus environment variable DEPENDENCIES=TRUE and run the ACCOUNT_TRANSACTION procedure.
Answer: C

3. You are creating a stored procedure in the SQL*Plus environment. The text of the procedure is stored in a script file. You run the script file to compile the procedure. What happens if the procedure contains syntax errors?
A. Neither the source code, nor the errors are stored in the database.
B. Both the source code and the compilation errors are stored in the database.
C. Compilation errors are appended to the script file that contains the source code.
D. The source code is stored in the database, and the errors are stored in an output file.
E. Only the compilation errors are written to the database, and source code remains in the script file.
Answer: B

4. When creating procedures, arguments should be placed before which keyword?
A. IS
B. BEGIN
C. DECLARE
D. PROCEDURE
Answer: A

5. Which part of a database trigger determines the number of times the trigger body executes?
A. trigger type
B. trigger body
C. trigger event
D. trigger timing
Answer: A

6. Examine this function:
CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG
(V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE)
RETURN NUMBER
IS
V_AVG NUMBER;
BEGIN
SELECT HITS / AT_BATS
INTO V_AVG
FROM PLAYER_BAT_STAT
WHERE PLAYER_ID = V_ID;
RETURN (V_AVG);
END;
Which statement will successfully invoke this function in SQL*Plus?
A. SELECT CALC_PLAYER_AVG(PLAYER_ID)
FROM PLAYER_BAT_STAT;
B. EXECUTE CALC_PLAYER_AVG(31);
C. CALC_PLAYER('Ruth');
D. CALC_PLAYER_AVG(31);
E. START CALC_PLAYER_AVG(31)
Answer: A

7. Which compiler directive is used to check the purity level of functions?
A. PRAGMA PURITY_LEVEL
B. PRAGMA SERIALLY_REUSEABLE
C. PRAGMA RESTRICT_REFERENCES
D. PRAGMA RESTRICT_PURITY_LEVEL
E. PRAGMA RESTRICT_FUNCTION_REFERENCE
Answer: C

8. Which system privilege must you have to manually recompile a stored procedure owned by another application developer?
A. ALTER PROCEDURE
B. ALTER ANY PROCEDURE
C. ALTER ALL PROCEDURE
D. COMPILE ANY PROCEDURE
Answer: B

9. 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 NUMBER)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Discounted '||
TO_CHAR(p_price*NVL(discount_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.10E.Discounted 0.10
Answer: A

10. Which procedure of the dbms_output supplied package would you use to append text to the current line of the output buffer?
A. GET
B. GET_LINE
C. PUT_TEXT_LINE
D. PUT
Answer: D

11. Which two statements about packages are true? (Choose two.)
A. Packages can be nested.
B. You can pass parameters to packages.
C. A package is loaded into memory each time it is invoked.
D. The contents of packages can be shared by many applications.
E. You can achieve information hiding by making package constructs private.
Answer: DE

12. The procedure ADD_PRODUCT is defined within a package specification as follows:
PROCEDURE ADD_PRODUCT
(p_prodno NUMBER, p_prodname VARCHAR2);
Which procedure declaration cannot be added to the package specification?
A. PROCEDURE add_product
(p_order_date DATE);
B. PROCEDURE add_product
(p_name VARCHAR2, p_ordered DATE);
C. PROCEDURE add_product
(p_prodname VARCHAR2, p_price NUMBER);
D. PROCEDURE add_product
(p_price NUMBER, p_description VARCHAR2);
Answer: D

13. You have created a stored procedure DELETE_TEMP_TABLE that uses dynamic SQL to remove a table in your schema. You have granted the EXECUTE privilege to user A on this procedure. When user A executes the DELETE_TEMP_TABLE procedure, under whose privileges are the operations performed by default?
A. SYS privileges
B. your privileges
C. public privileges
D. user A's privileges
E. User A cannot execute your procedure that has dynamic SQL.
Answer: B

14. Which code can you use to ensure that the salary is neither increased by more than 10% at a time nor is it ever decreased?
A. ALTER TABLE emp ADD
CONSTRAINT ck_sal CHECK (sal BETWEEN sal AND sal*1.1);
B. CREATE OR REPLACE TRIGGER check_sal
BEFORE UPDATE OF sal ON emp
FOR EACH ROW
WHEN (new.sal new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease salary nor increase by more than 10%');
END;
C. CREATE OR REPLACE TRIGGER check_sal
BEFORE UPDATE OF sal ON emp
WHEN (new.sal new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease salary nor increase by more than 10%');
END;
D. CREATE OR REPLACE TRIGGER check_sal
AFTER UPDATE OF sal ON emp
WHEN (new.sal -new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease salary nor increase by more than 10%');
END;
Answer: B