1z0-024 Oracle - Braindumps.com.ua: question list for "Oracle 8i: Performance Tuning", page: 6

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-024: Oracle 8i: Performance Tuning

#51. How are deadlocks resolved within Oracle?

#52. When a deadlock occurs, what should be used to diagnose the problem and determine how to prevent the deadlock from occurring again?

#53. When the archive process encounters an error, which parameter determines the directory where trace files are written?

#54. To control fragmentation of your shared pool space, when is the best time for you to pin objects with the DBMS_SHARED_POOL package?

#55. Which type of change to an application is most likely to improve the performance of the library cache?

#56. The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result?

#57. What is a potential reason for a "snapshot too old" error message?

#58. You are attempting to size the KEEP buffer pool and issue ANALYZE. . . . ESTIMATE STATISTICS commands. Which three data dictionary tables should you query to obtain the total number of blocks required for an object? (Choose three)

#59. The USERS table has thousands of rows and is accessed very often with an index (ISERID_NDX) on a primary key (USER_ID). Where should USERS and USERID_NDX be stored?

#60. You are creating a new rollback segment. Why should you choose the same value for the NEXT and INITIAL attributes?

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

gen. 0.064

Server date 05:59 02-12-2008

Oracle 1z0-024

Forum

Start online exam simulation

Master braindump

User braindumps