1z0-042 Exam Name: Oracle database 10g:Administration , The material of this exam Questions and Answers are122 Q&As , it is cracked by our professional team ,100% Guarantee to Pass Your oracle exam and get your Oracle database 10g:Administration certification . And you can use it safely .The price of this exam 1z0-042 is $99.00 .This exam guide was Updated on 2009-07-20 ,it is the latest one , after you buy it if there are some updates we will give you the one for free .
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 self-tuning components in the database.
Answer: CD
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