1Z0-030 Oracle - Braindumps.com.ua: question list for "Oracle 9i: New Features For Administrators", 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-030: Oracle 9i: New Features For Administrators

#71. The DBMS_STATS.GATHER_SYSTEM_STATS routine collects system statistics in a userdefined time frame.
Which four statements are true of the GATHER_SYSTEM_STATS routine? (Choose four.)

#72. Examine this fragment from a SQL*Plus session:

 SQL> SELECT name, VALUE FROM v$sysstat 
 2> WHERE name LIKE 'work area executions%';

 NAME                                VALUE 
 work area executions - optimal      1544 
 work area executions - onepass      11 
 work area executions - multipass    1038

What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?

#73. Which operation causes an index to be considered "used" while monitoring is turned on for that particular index?

#74. Consider the following statement:

 SQL> EXECUTE DBMS _STATS.GATHER_SCHEMA_STATS (- 
 2> ownname => 'OE', - 
 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - 
 4> method opt => 'for all columns size AUTO');

What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?

#75. Using a bitmap structure to manage database object space has several benefits over using freelist structures.
Which three are benefits of managing space using automatic segment-space managed objects? (Choose three)

#76. The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether t has been used by an execution plan?

#77. What is the benefit of the Cached Execution Plan feature?

#78. For the best performance, what should be done with blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database?

#79. Which statement correctly describes the function of the Oracle9i Cache Fusion feature?

#80. You start a multithreaded heterogeneous service agent with this initialization parameter:
MAX_DISPATCHERS = 10
What is the result?

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

gen. 0.087

Server date 06:41 22-11-2008

Oracle 1Z0-030

Forum

Start online exam simulation

Master braindump

User braindumps