Data files b control files c tablespaces d password

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 F. whole database G. flashback log file H. archived log files I. change tracking file Answer: A,C,F QUESTION 125: 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. Answer: A QUESTION 126: 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 multiplexed. Answer: B,D QUESTION 127: 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 UNDO_RETENTION value? 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 UNDO_RETENTION Answer: A QUESTION 128: 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 database? A. It terminates all user sessions. B. It prevents users from logging i...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online