Unformatted text preview: file
F. whole database
G. flashback log file
H. archived log files
I. change tracking file
Due to media failure you lost one of the data files belonging to the USERS
tablespace, and the tablespace is not available to use. Which statement regarding
the status of the database is true?
A. The database remains open.
B. The database gets dismounted.
C. The database becomes read only.
D. The database instance gets aborted.
Actualtests.com - The Power of Knowing 1Z0-042
E. The database gets shut down automatically.
F. The status of the database depends on the status of the USERS tablespace.
In which two cases would you perform only consistent backup? (Choose two.)
A. You are working on a database where downtime is not tolerated.
B. You are working on a database where downtime can be tolerated.
C. You are working on a database that operates in ARCHIVELOG mode.
D. You are working on a database that operates in NOARCHIVELOG mode.
E. You are working on a database where all the tablespaces are locally managed.
F. You are working on a database where control files and redo log files are multiplexed.
G. You are working on a database where control files and redo log files are not
You have a production instance running on your server. UNDO_RETENTION is
not long enough to satisfy read-consistency requirements. How do you change the
A. by executing the ALTER SYSTEM .. command
B. by re-creating the control file with a new value for UNDO_RETENTION
C. by executing the ALTER DATABASE.. command in the MOUNT state
D. by executing UPDATE.. statement on V$PARAMETER to change the value of
You executed the following command in the lsnrctl utility to stop the listener:
lsnrctl> STOP L1
What is the effect of this command if L1 is the only listener configured for your
A. It terminates all user sessions.
B. It prevents users from logging i...
View Full Document
- Fall '09
- administrator, Oracle Database, Certkiller