Answer c question 172 exhibit view the exhibit to see

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ting tablespaces of the PROD database. 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 - 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) Answer: B QUESTION 173: 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 down. Answer: B QUESTION 174: 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? A. owner B. touser C. include D. schemas E. fromuser F. transform G. remap_schema H. remap_datafile I. reuse_datafiles J. remap_tablespace Answer: G - The Power of Knowing 1Z0-042 QUESTION 175: Data files of which three tablespaces can be recovered by performing an open recovery?(Choose three.) A. TEMP B. UNDO C. INDEX D. SYSAUX E. SYSTEM Answer: A,C,D QUESTION 176: What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.) 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

Ask a homework question - tutors are online