1z0-101 9i Internet Application Developer Braindump
ExamSoon 1z0-101 Exams
Oracle develop pl/sql program units
O rder : 1z0-101 Exam
Practice Exam: 1z0-101
Exam Number/Code: 1z0-101
Exam Name: develop pl/sql program units
Questions and Answers: 114 Q&As
Free 1z0-101 Braindumps
Exam : Oracle 1Z0-101
Title : Develop Pl/Sql Program Units
1. Which two programming constructs can be grouped within a package? (Choose two.)
A. cursor
B. constant
C. trigger
D. sequence
E. view
Answer: AB
2. 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
3. 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