This preview shows page 1. Sign up to view the full content.
Unformatted text preview: file
E. background trace file
F. operating system event viewer
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
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
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
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
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09