Unformatted text preview: ting tablespaces of the PROD
You observe that a large volume of INSERTs and DELETEs are happening on the
TRANS table residing in the USERS tablespace, and you suspect that the TRANS
Actualtests.com - The Power of Knowing 1Z0-042
table is fragmented. Which advisory component would you refer to, in order to find
the information about table fragmentation?
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning and Access Advisors
D. Automatic Workload Repository (AWR)
E. Automatic Database Diagnostic Monitor (ADDM)
In your database, UNDO_RETENTION has been set to 600 sec and UNDO
tablespace is configured for RETENTION GUARANTEE. Which statement
regarding RETENTION GUARANTEE is true?
A. Undo data is retained until the next full database backup.
B. No committed undo data will be overwritten for 10 minutes.
C. Committed undo data will be kept forever if not overwritten within 600 seconds.
D. Guarantees that requested undo information are available until the instance is shut
You want to migrate your application from the development environment to the
production environment. While doing the task, you want the database objects
owned by the user DEVUSER in the development environment to be moved to the
user APPS in the production environment. Which option of Oracle Data Pump
Import would you use to achieve this objective?
Answer: G Actualtests.com - The Power of Knowing 1Z0-042
Data files of which three tablespaces can be recovered by performing an open
What are the consequences of executing the SHUTDOWN ABORT command?
A. The database files are synchronized.
B. Uncommitted changes are not rolled back.
C. The database is closed, but the instance is still started.
D. Database buffers an...
View Full Document
- Fall '09