This preview shows page 1. Sign up to view the full content.
Unformatted text preview: . create more undo segments
C. create another undo tablespace
D. increase the size of the undo tablespace
In the instance of the PROD database, the checkpoint (CKPT) process runs after
every minute. A database user updates the rows of the ORDERS table. Because of
the configuration, the CKPT process gets initiated before the user commits the
What would happen to the modified blocks when the CKPT process is started?
A. The modified blocks would be written to the data files.
B. The modified blocks would be written to the temp files.
C. The modified blocks would be written to the control file.
D. The modified blocks would be written to the redo log files.
E. The modified blocks would be written to the archived redo log files.
F. The modified blocks would be retained in the database buffer cache.
You are working on a very large database. You had performed a binary backup of
the control file a month ago. After this you added a few tablespaces, and dropped a
couple of tablespaces. This morning, due to hardware failure, you lost all your
How would you recover the database from this situation?
A. execute the CREATE CONTROLFILE FROM BACKUP.. command
B. restore all database files from the last backup and apply redo logs till the point of
C. restore the binary copy of the control file to the respective location and start up the
D. start up the database in the NOMOUNT state, generate the trace file from binary
Actualtests.com - The Power of Knowing 1Z0-042
backup, and re-create the control file using the trace file and
then mount and open the database
E. restore the binary copy of the control file to the correct location, start up the instance
in the mount state, backup the control file to trace, shut down the instance, edit the trace
file to reflect the added and removed data files, then use the script generated in the trace
file to start the instance and re-create the control file
You are using the following command to clear the log file group:
ALTER DATABASE CLEAR LOFFILE GROUP 2;
In which case would the command be successful?
A. Group 2 is the active group.
B. Group 2 is the current group.
View Full Document
- Fall '09