Oracle certification

develop pl/sql program units : 1z0-101 Exam

Why choose Greatexam 1z0-101 braindumps

Quality and Value for the 1z0-101 Exam
100% Guarantee to Pass Your 1z0-101 Exam
Downloadable, Interactive 1z0-101 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

Greatexam 1z0-101 Exam Features

1z0-101 News

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


1. 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

2. 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

3. 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

4. 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

5. 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

6. 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 < old.sal OR
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 < old.sal OR
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 < old.sal OR
-new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease salary nor increase by more than 10%');
END;
Answer: B

7. 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

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