C. Non-critical losses have little impact on database operations if resolved properly.

B. Temporary tablespaces are responsible for storing temporary or sort segments. These are used in the sorting of select statements or in building indexes.

C. A missing tempfile can be re-created with the create tablespace command. Because the tempfile is locally managed and contains no permanent data, no restoring or recovering is needed. Therefore recovery can occur quickly with minimal impact to database operations.

C, D. A missing temporary tablespace can be quickly reassigned with the command ALTER DATABASE to an existing temporary tablespace if one is available. If one is not available, you will need to run CREATE TEMPORARY TABLESPACE and then perform the ALTER DATABASE command.

A. The missing redo log must first be dropped even though it doesn't exist physically in the file system. This removes the redo log metadata from the data dictionary. Next the log can be added back to database.

D. If your database has mirrored redo logs and a member is deleted, the database will function as normal. The error signaling that a log member has been deleted would be written to the alert log.

B. The redo log member will not be added to the current or active redo log group. Oracle will not allow this because transactions are actively being written to the redo log group.

B, C. You must use the ALTER DATABASE DEFAULT TEMPORARY TABLESPACE table name command on a temporary tablespace or you will receive an ORA-12904 error.

D. Rebuilding an index in parallel with NOLOGGING is the most efficient method of building an index to minimize the impact on database operations. You must be cautious not to use extensive server resources when you don't use the parallel rebuild option.

C. The index scripts must be current and stored locally so they can be accessed quickly and easily during an index tablespace rebuild.

A. The read-only tablespace contains only static or non-changing data.

B, C. The database will stop at the mount stage. This is due to the ORA-01157 error.

B. IPC is the method that the local administrative access uses to connect to the database.

C. The correct command to create a password file that supports 10 users is orapwd file=orapwORA101T password=syspass entries=10.

A. The initialization parameter required for remote access is REMOTE_LOGIN_PASSWORDFILE.

B, C. The $ORACLE_HOME/dbs is the Unix location for the password file, and C:$ORACLE_HOMEdatabase is the Windows location for the password file.

D. The database should be shut down before running the ORAPWD utility.

C. Local connections are secured by the operating system password logging on to an administrative account such as Oracle user in Unix and administrator in Windows.

A, B, C. The scenario of read-write to read-only tablespace requires the use of the RECOVER command, which will apply necessary redo changes to make the tablespace consistent with the control file. The checkpointing operation of Oracle will change the control file, and the header of the read-only tablespace will be modified, which equates to changes in the tablespace.

B, C. A non-critical loss should have limited impact on database operations. This means that incomplete recovery or media failure scenarios need to be performed. A loss of a redo group before archived will require incomplete recovery, which is the same as the loss of current or active redo log group. The current or active member or loss of archive will not significantly impact operations. A backup can be performed to eliminate the need for the archive log, and the database will function normally with the loss of a redo log member.