McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
My Cart (0)  

Oracle 1Z0-147

1Z0-147

Exam Code: 1Z0-147

Exam Name: Oracle9i program with pl/sql

Updated: Nov 14, 2026

Q & A: 111 Questions and Answers

1Z0-147 Free Demo download

PDF Version Demo PC Test Engine Online Test Engine

Already choose to buy "PDF"

Price: $59.99 

About Oracle 1Z0-147 Exam

In recent years, many people choose to take Oracle 1Z0-147 certification exam which can make you get the Oracle certificate that is the passport to get a better job and get promotions.

How to prepare for Oracle 1Z0-147 exam and get the certificate? Please refer to Oracle 1Z0-147 exam questions and answers on ITCertTest.

ITCertTest is a good website that provides all candidates with the latest IT certification exam materials. ITCertTest will provide you with the exam questions and verified answers that reflect the actual exam. The Oracle 1Z0-147 exam dumps are developed by experienced IT Professionals. 99.9% of hit rate. Guarantee you success in your 1Z0-147 exam with our exam materials.

Furthermore, we are constantly updating our 1Z0-147 exam materials. We will provide our customers with the latest and the most accurate exam questions and answers that cover a comprehensive knowledge point, which will help you easy prepare for 1Z0-147 exam and successfully pass your exam. You just need to spend you 20-30 hours on studying the exam dumps.

ITCertTest provides you not only with the best materials and also with excellent service. If you buy ITCertTest questions and answers, free update for one year is guaranteed. You fail, after you use our Oracle 1Z0-147 dumps, 100% guarantee to FULL REFUND. You just need to send the scanning copy of your examination report card to us. After confirming, we will refund you.

What's more, before you buy, you can try to use our free demo. We provide you some of Oracle 1Z0-147 exam questions and answers and you can download it for your reference.

ITCertTest is no doubt your best choice. Using the Oracle 1Z0-147 training dumps can let you improve the efficiency of your studying so that it can help you save much more time.

Quick and easy: just two steps to finish your order. We will send your products to your mailbox by email, and then you can check your email and download the attachment.

Oracle 1Z0-147 Exam Syllabus Topics:

SectionObjectives
Large Objects and Advanced PL/SQL Features- LOB and Built-in Packages
  • 1. Use DBMS_LOB package
  • 2. Work with LOB data types
  • 3. General PL/SQL programming techniques
SQL within PL/SQL- DML Operations
  • 1. Transaction control
  • 2. SELECT statements
  • 3. INSERT, UPDATE, and DELETE statements
Cursors and Collections- Cursor Management
  • 1. Implicit and explicit cursors
  • 2. Fetch and cursor processing
  • 3. Cursor attributes
Database Triggers- Trigger Implementation
  • 1. Use OLD and NEW qualifiers
  • 2. INSTEAD OF triggers
  • 3. System event triggers
  • 4. Row and statement triggers
Packages- Package Development
  • 1. Package body
  • 2. Package specification
  • 3. Package variables and initialization
PL/SQL Fundamentals- PL/SQL Blocks
  • 1. Declare variables and constants
  • 2. Use %TYPE and %ROWTYPE attributes
  • 3. Define and execute PL/SQL blocks
Program Control Structures- Conditional and Iterative Processing
  • 1. LOOP, WHILE, and FOR loops
  • 2. IF and CASE statements
  • 3. Nested blocks
Procedures and Functions- Stored Program Units
  • 1. Parameter modes
  • 2. Create procedures
  • 3. Invoke functions in SQL
  • 4. Create functions
Exception Handling- Managing Errors
  • 1. User-defined exceptions
  • 2. Predefined exceptions
  • 3. RAISE and exception propagation

Oracle9i program with pl/sql Sample Questions:

Question #1
Examine this package: CREATE OR REPLACE PACKAGE BB_PACK IS V_MAX_TEAM_SALARY NUMBER ( 12,2) ; PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER); END BB_PACK; / CREATE OR REPLACE PACKAGE BODY BB_PACK
IS
V_PLAYER_AVG NUMBER84,3);
PROCEDURE UPD_PLAYER_STAT
(V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER)
IS
BEGIN
UPDATE PLAYER_BAT_STAT
SET AT_BATS = AT_BATS + V_AB,
HITS = HITS + V_HITS
WHERE PLAYER_ID = V_ID;
COMMIT;
VALIDATE_PLAYER_STAT(V_ID);
END UPD_PLAYER_STAT;
PROCEDURE ADD_PLAYER
(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBERI)
IS
BEGIN
INSERT INTO PLAYER (ID,LAST_NAME, SALARY)
VALUES (V_ID, V_LAST_NAME, V_SALARY);
UPD _PLAYER_STAT (V_ID, 0, 0) ;
END ADD_PLAYER;
END BB_PACK;
If you add an IF statement to the ADD_PLAYER procedure which additional step must you
perform?
r A Recompile the ADD PLAYER procedure
Recompile both the BB PACK specification and body

A. Recompile the ADD_PLAYER procedure
B. Recompile both the BB_PACK specification and body
C. Recompile the BB_PACK specification
D. Recompile the BB_PACK body


Question #2
Examine this code:
CREATE OR REPLACE PRODECURE add_dept (p_dept_name VARCHAR2 DEFAULT 'placeholder', p_location VARCHAR2 DEFAULT 'Boston')
IS BEGIN INSERT INTO departments VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location); END add_dept; /
Which three are valid calls to the add_dep procedure? (Choose three)

A. add_dept(, 'New York');
B. add_dept;
C. add_dept('Accounting');
D. add_dept(p_location=>'New York');


Question #3
Examine this procedure:
CREATE OR REPLACE PROCEDURE INSERT_TEAM
(V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2)
IS
BEGIN
INSERT INTO TEAM (id, city, name)
VALUES (v_id, v_city, v_name);
COMMIT;
END
Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)

A. EXECUTE INSERT_TEAM (3, 'LONGHORNS');
B. EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
C. EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
D. EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS');
E. EXECUTE INSERT_TEAM;


Question #4
Which view displays indirect dependencies, indenting each dependency?

A. INDENT_TREE
B. DEPTREE
C. I_DEPT_TREE
D. IDEPTREE


Question #5
Which code can you use to ensure that the salary is not increased by more than 10% at a time nor is it ever decreased?

A. 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 not increase by more than 10%');
END;
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 not increase by more than 10%');
END;
C. CREATE OR REPLACE TRIGGER check_sal
AFTER UPDATE OR sal ON emp
WHEN (new.sal < old.sal OR
-new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease
salary not increase by more than 10%');
END;
D. ALTER TABLE emp ADD
CONSTRAINT ck_sal CHECK (sal BETWEEN sal AND sal*1.1);


Solutions:

Question #1
Correct Answer: D
Question #2
Correct Answer: B,C,D
Question #3
Correct Answer: B,D
Question #4
Correct Answer: D
Question #5
Correct Answer: B

1336 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

I want to be better so i tried to get the 1Z0-147 certification, with your excellent 1Z0-147 exam dumps, my dream became true. I believe i will lead a better life. Big thanks!

Adair

Adair     4.5 star  

Very useful 1Z0-147 exam dumps. Although the price is expensive, it is worthy it.

Morgan

Morgan     4 star  

Thanks for these awesome 1Z0-147 exam dumps. They are valid. I passed my 1Z0-147 exam in German today.

Ursula

Ursula     4.5 star  

Got what I paid for 1Z0-147 Passed and Planning More

Jack

Jack     4.5 star  

Be stress free, my friend, everything is good from Itcerttest. You can rely on this 1Z0-147 exam file. I passed my 1Z0-147 exam only with studying with them. Thanks!

Evelyn

Evelyn     4.5 star  

I do not regret to purchase 1Z0-147 practice material, it help me to clear my exam with ease. Thanks

Rory

Rory     4 star  

Wonderful 1Z0-147 exam study materials. Passed easily. Great!

Franklin

Franklin     5 star  

Due to this reason, I used many reference sites, but all were useless.

Lauren

Lauren     5 star  

Passd 1Z0-147 today with high score! Thanks for all your actual exam Q&As! I also will come back to get other exams in recent several months.

Suzanne

Suzanne     4.5 star  

Got 1Z0-147 materials from William.

Jay

Jay     4.5 star  

I wasted a lot of money and failed twice. Thanks to 1Z0-147 exam collection I pass now.

Giles

Giles     4 star  

Passed 1Z0-147 exams today with a good score. This dump is valid. Your Q&As are very good for the people who do not have much time for their exam preparation. Thanks for your help.

Hunter

Hunter     5 star  

I passed with 75% exactly (USA), but it was a miracle. About 30% or so new questions. 1Z0-147 Dumps still helps.

Toby

Toby     4 star  

The 1Z0-147 braindumps helped me to start preparation for exam with confidence, 1Z0-147 dumps are valid, study hard guys!

Alva

Alva     5 star  

When you learn from best, you can surly pass 1Z0-147 your test easily.

Harry

Harry     5 star  

It was not an easy task without Itcerttest to maintain such a high level of IT certification and passing 1Z0-147 exam with good mark. Thank you!

Carl

Carl     4.5 star  

I am planning my next certification exams with Itcerttest study materials and recommend this site to all my friends and fellows in my contact. Thanks Itcerttest.

Evangeline

Evangeline     5 star  

I did passed the 1Z0-147 exam one week ago! It saved lots of time and effort! Your 1Z0-147 exam questions closely matched the actual 1Z0-147 exam. Thanks a lot!

Hermosa

Hermosa     4.5 star  

Valid exam dumps by Itcerttest for 1Z0-147. Made my concepts clear for the exam. Thank you Itcerttest for this saviour. Cleared my exam with excellent marks.

Hilda

Hilda     4 star  

1Z0-147 questions dump is still valid, i just passed my exam 2 days ago and i studied Q&A from this dump only.

Dale

Dale     4 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Contact US:  
 [email protected]  Support

Free Demo Download

Popular Vendors
Alcatel-Lucent
Avaya
CIW
CWNP
Lpi
Nortel
Novell
SASInstitute
Symantec
The Open Group
Tibco
Zend-Technologies
Lotus
OMG
RES Software
all vendors
Why Choose ITCertTest Testing Engine
 Quality and ValueITCertTest Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
 Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
 Easy to PassIf you prepare for the exams using our ITCertTest testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
 Try Before BuyITCertTest offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.