TestKing Oracle 9i 1z0-033 - ...

[ Pobierz całość w formacie PDF ]
1z0-033
1z0 - 033
Oracle9i
Performance Tuning Study Guide
Version 2.0
Leading the way in IT testing and certification tools,
www.testking.com
- 1 -
1z0 - 033
Important Note
Please Read Carefully
This product will provide you questions and answers along with detailed explanations carefully compiled
and written by our experts. Try to understand the concepts behind the questions instead of just cramming the
questions. Go through the entire document at least twice so that you make sure that you are not missing
anything.
We are constantly adding and updating our products with new questions and making the previous versions
better so email us once before your exam and we will send you the latest version of the product.
Each pdf file contains a unique serial number associated with your particular name and contact information
for security purposes. So if we find out that particular pdf file being distributed by you. Testking will reserve
the right to take legal action against you according to the International Copyright Law. So don’t distribute
this PDF file.
Leading the way in IT testing and certification tools,
www.testking.com
- 2 -
1z0 - 033
QUESTION NO: 1
Which two statements regarding OLTP systems are true? (Choose two)
A.
Use literals for optimally shared SQL rather than bind variables to keep the overhead of parsing to a
minimum.
B.
To avoid the performance load of dynamic space allocation, allocate space explicitly so tables,
clusters and indexes.
C.
B-tree indexing is preferred to bitmap indexing, because of locking issues affecting DML operations.
D.
Use hash clusters especially on tables that are heavily inserted into, because of the use of space and
the number of blocks that need to be visited.
E.
Use application code to enforce rules instead of constraints, because constraints are extremely
expensive to process.
Answer: B, C
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 187-188
Chapter 3: SQL Application Tuning and Design
QUESTION NO: 2
When performing a sort operation, you notice that there are a large number of sorts requiring I/0 to
the disk. Which parameter could be increased to allow more sorts to be performed in memory?
A.
SORT_AREA_SIZE
B.
LARGE_POOL_SIZE
C.
SORT_AREA_RETAINED_SIZE
D.
SORT_MULTIBLOCK_READ_COUNT
Answer: A
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 412-413
Chapter 8: Tuning Disk I/O
QUESTION NO: 3
Which statement could require a sort?
A.
SELECT DISTINCT dept_id
FROM emp:
B.
UPDATE emp SET salary=salary*1.1
WHERE id 7722;
C.
SELECT emp_id, name
FROM emp
Leading the way in IT testing and certification tools,
www.testking.com
- 3 -
1z0 - 033
WHERE emp-id= 7722;
D.
SELECT emp_id, name
FROM emp
WHERE emp_id BETWEEN 7722 and 7100;
Answer: A
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 411-412
Chapter 8: Tuning Disk I/O
QUESTION NO: 4
Which two views can be used to detect lock contention? (Choose two)
A.
V$LOCK
B.
V$LOCKED_OBJECT
C.
V$LOCK_CONTENTION
Answer: A, B
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 487-489
Chapter 9: Tuning Contention
QUESTION NO: 5
The database includes tables with static data, which are used for queries only. To which size should
you set PCTFREE for this type of table?
A.
0
B.
50
C.
20
D.
10
Answer: A
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 401
Chapter 8: Tuning Disk I/O
QUESTION NO: 6
Which action could potentially cause checkpoints to take longer?
A.
Increasing the number of redo log groups.
B.
Increasing the size of rollback segments.
C.
Decreasing the value of the REDO_LOG_BUFFERS parameter.
Leading the way in IT testing and certification tools,
www.testking.com
- 4 -
1z0 - 033
D.
Increasing the value of the FAST_START_IO_TARGET parameter.
Answer: D
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 343-345
Chapter 7: Tuning Redo Mechanisms
QUESTION NO: 7
When a deadlock shutdown is detected by Oracle, where is the trace file
generated
?
A.
SQL_TRACE
B.
TRACE_DEST
C.
USER_DUMP_DEST
D.
CORE_DUMP_DEST
E.
BACKGROUND_DUMP_DEST
Answer: C
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 40-41
Chapter 2: Sources of Tuning Information
QUESTION NO: 8
If a willing-to-wait latch request is satisfied on the first attempt, which statistic gets incremented?
A.
GETS
B.
SLEEPS
C.
MISSED
D.
IMMEDIATE_GETS
E.
IMMEDIATE_GETS
F.
IMMEDIATE_GETS
Answer: A
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 468-470
Chapter 9: Tuning Contention
QUESTION NO: 9
For which reason would you query V$SYSSTAT?
A.
Name of the sort segment.
B.
Free space available for a sort segment.
C.
Number of disk sorts performed since startup.
Leading the way in IT testing and certification tools,
www.testking.com
- 5 -
[ Pobierz całość w formacie PDF ]