Skip to content

1Z0-052 exam details

Exam number: 1Z0-052

Exam price: $125usd

Duration: 90 minutes

Number of questions: 70

Passing score: 66%

Killtest has the latest version of 1Z0-052 exam, which is written to the highest standards of technical accuracy and provided by certified experts.

Try killtest’s latest version of 1Z0-052 exam, 100% guarantee to pass your exam.

For example:

2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

A.All AWR tables belong to the SYSTEM schema.

B.The AWR contains systemwide tracing and logging information.

C.The snapshots collected by the AWR are accessible through data dictionary views.

D.The snapshots collected by the AWR are used by selftuning components in the database.

Answer: CD

3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

A.Validate the index structure using the ANALYZE…INDEX command.

B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.

C.Change the block space utilization parameters using the ALTER INDEX command.

D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.

Answer: B

Posted in 11g.

Tagged with .

0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

Some HTML is OK

or, reply to this post via trackback.

Anti-Spam Protection by WP-SpamFree