How is it that we can guarantee your success and passing your 1z0-147 exam? Simple. The Oracle training we provide here at TestKing.us is designed to elevate your skills and understanding so that not only you can correctly answer your 1z0-147 exam questions accurately – but you will comprehend the material to the point where handling situations and common problems as if they were everyday occurrences… and they are!

Certification Provider: Oracle
Exam Name: 1z0-147 – Oracle9i: Program with PL/SQL
Associated Certifications: Oracle 9i Internet Application Developer
Language:English
Duration: 90 minutes
Number of Questions: 66
Passing Score: 77%

Free download testking Oracle 1Z0-147 practice questions:
1. Which three describe a stored procedure? (Choose three.)
A. A stored procedure is typically written in SQL.
B. By default, a stored procedure executes with the privileges of its owner.
C. A stored procedure has three parts: the specification, the body, and the exception handler part .
D. A stored procedure is stored in the database and can be shared by a number of programs.
E. A stored procedure offers some advantages over a standalone SQL statement, such as programmable functionality and compiled code.
Answer: B, D, E

2. You need to create a DML trigger. Which five pieces need to be identified? (Choose five.)
A. table
B. DML event
C. trigger body
D. package body
E. package name
F. trigger name
G. system event
H. trigger timing
Answer: A, B, C, F, H

3. What can you do with the DBMS_LOB package?
A. Use the DBMS_LOB.WRITE procedure to write data to a BFILE.
B. Use the DBMS_LOB.BFILENAME function to locate an external BFILE.
C. Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.
D. Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed.
Answer: D

Pdf tutorials
Oracle 1z0-131 classes training
Oracle 1z0-132 final questions
Oracle 1z0-032 free braindumps
Oracle 1z0-033 students exam
Novell 50-653 example exam questions
Microsoft 70-310 course test
Microsoft 70-320 cert exam
LPI 117-201 brain exam
LPI 117-202 exams
Novell 50-654 demo
Microsoft 70-305 exam practice tests
Microsoft 70-315 pdf answers

Study guide notes
Network Appliance NS0-310 computer software training
Network Appliance NS0-320 practice final exam
Network Appliance NS0-330 professional training
Network General 1T6-220 exam book
Network General 1T6-521 practice test
Network General 1T6-540 basic lab
Nortel 920-181 oral exams
Nortel 920-806 compass test study guide
Nortel 922-072 certification practice tests
Nortel 922-104 general sheet

Oracle 1z0-147 Search Help
Feel free to use search terms below while searching the Net for 1z0-147 exam:
Oracle 1z0-147 core dumps
Oracle 1z0-147 a practice test
Oracle 1z0-147 learning tools
Oracle 1z0-147 exam files
Oracle 1z0-147 free certification
Oracle 1z0-147 boot camp
Oracle 1z0-147 practice testing
Oracle 1z0-147 passing scores
Oracle 1z0-147 practice exams
Oracle 1z0-147 lab normal

Exam Code: 1Z0-043
Exam Name: Oracle Database 10g: Administration II

1. You need to check the EMP_EAST  partition in the EMPLOYEES table for physical corruptions.  You also need to verify that the rows belong to the correct partition. Which option could you use?
A. LogMiner
B. the DBNEWID  utility
C. the DBVERIFY utility
D. the ANALYZE command
E. the RMAN REPORT command
F. the RMAN CROSSCHECK command
G. the RMAN BLOCKRECOVER command
Answer: D

2. You execute the following command to enable a session in resumable mode:
SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;
What is the impact of a timeout on the statements being suspended?
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
Answer: C

3. Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance then gradually returns to normal levels.
Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)
A. increase the number of checkpoint processes
B. define the POWER option while adding or removing the disks
C. increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D. increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
E. increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process
Answer: B, E

4. You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A maximum of 3 GB can be allocated to shared pool.
B. The value for SGA_TARGET can be increased up to a maximum of 14 GB.
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE.
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters.
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB.
Answer: B, E

5. Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement.
What was the first step that was needed in the process to achieve this objective?
A. The user must have been granted the DBA role.
B. The user must have been granted the switch privilege as a part of a role.
C. The user must have been granted the Resource Manager administrator privilege.
D. The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
Answer: D

6. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer: B, E

7. You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:
RMAN> BACKUP TABLESPACE DETTBS;
Under which conditions would this command execute successfully? (Choose all that apply.)
A. The database is in NOMOUNT state.
B. The database is in ARCHIVELOG mode and the tablespace is online.
C. The database is in ARCHIVELOG mode and the tablespace is offline.
D. The database is in NOARCHIVELOG mode and the tablespace is online.
E. The database is in NOARCHIVELOG mode and the tablespace is offline.
Answer: B, C, E

8. You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?
A. flash back the database
B. import the temporary tablespace from the last export
C. restore all the data files and temporary files from the last full database backup and perform a recovery
D. not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace
Answer: D

Free download More TestKing Oracle Exams Q&A now!