1z0-033 Oracle - Braindumps.com.ua: question list for "Oracle9i:Performance Tuning", page: 8

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-033: Oracle9i:Performance Tuning

#71. Application developers are complaining about the poor response time of SQL statements on certain tables. On investigation, you find that the generation of recursive calls (in addition to SQL statements) to perform space management operations is the cause for the poor response time. Which of the solutions provided would solve the problem?

#72. Which two factors should be ensured by a DBA or an application developer while designing locking procedures to prevent locking problems? (Choose two.)

#73. Your production database is running in ARCHIVELOG mode but the Archiver (ARCn) process is not started yet. What is the effect of this?

#74. There are three users working on the same schema in your database. The techdt table in this schema does not have any indexes on it. All the three users execute UPDATE statements on the techdt table to update different rows. When the third user executes an UPDATE statement, it waits and does not update the table. You execute the following query to find the reason for this:

 SQL> SELECT sid, TYPE, id1, id2, lmode, request FROM v$lock WHERE TYPE=’TX’;

 SID   TYPE       ID1        lD2     LMODE    REQUEST 
  11     TX    262150      45564         6          0 
  16     TX    393253      45294         6          0 
  18     TX    393253      45294         0          4

Why does the UPDATE statement of the third user wait?

#75. In your database, Transaction 1 and Transaction 2 are waiting for rows locked by each other. This causes a deadlock. What would the Oracle server do in this situation? (Choose all that apply.)

#76. When a row in a table is chained or migrated, performance associated with that row degrades. What are the two reasons for this? (Choose two.)

#77. You want to compact the space of an index on one of the important tables in your database. You used the ALTER INDEX REBUILD ONLINE to achieve this task. Which requirement(s) would have forced you to use this method instead of coalescing the index? (Choose all that apply.)

#78. Exhibit:

View the Exhibit and examine the PGA advisory from the statspack report. You notice from the statspack report that PGA_AGGREGATE_TARGET is set too low for the current workload. The current value of PGA_AGGREGATE_TARGET is 24 MB. What is the optimal value for the PGA_AGGREGATE_TARGET parameter?

#79. The values for the resource plan directives are set as follows:
SWITCH_GROUP = OLAP
SWITCH_TIME = 1000
SWITCH_ESTIMATE = True
What are the two implications of these values on a running session belonging to the consumer group for which these directives are set? (Choose two.)

#80. You created an index on the pdcost column of the PDLIST table in your database, and then executed the following command to find the total number of rows sorted until now:

 SQL> SELECT name, VALUE FROM v$sysstat WHERE name=’sorts (ROWS)’;

 NAME           VALUE 
 sorts (rows)   54762

Execution of which Iwo queries would increase the sorts(rows) value? (Choose two.)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [17]

gen. 0.326

Server date 06:12 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps