A audit trail b alert log file c user trace file d

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: file E. background trace file F. operating system event viewer Answer: B QUESTION 114: You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? A. renaming the control files B. dropping a user in your database C. enabling or disabling redo log archiving D. dropping a tablespace in your database E. re-creating the control files, after you lost all the control files in your database Answer: C QUESTION 115: You specified extent management as local for a tablespace. How will it affect space management in the tablespace? A. All the extents will be of the same size. B. Bitmap will be used to record free and allocated extents. C. Free extents will be managed by the data dictionary tables. D. The tablespace will be system managed and the users cannot specify the extent size. Actualtests.com - The Power of Knowing 1Z0-042 Answer: B QUESTION 116: You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future? (Choose three.) A. guarantee undo retention B. add one more redo log group C. size the redo log files appropriately D. size the UNDO tablespace appropriately E. size the SYSTEM tablespace appropriately F. configure an appropriate undo retention interval G. change automatic undo management to manual Answer: A,D,F QUESTION 117: Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true? (Choose two.) A. The destination must be global only. B. A maximum of five destinations can be assigned. C. A maximum of ten different destinations can be assigned. D. All the destinations are determined by the server automatically. E. The destination may be local or remote for a Standby Database. F. The destination can be changed by setting the LOG_ARCHIVE_FORMAT ini...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online