11.5. Review Questions

  1. The distance between the checkpoint position in a redo log group and the end of the redo log group can never be what percentage of the smallest redo log group?

    1. 15

    2. 100

    3. 50

    4. 90

    5. None of the above; the distance is relative to the size of the largest redo log group.

  2. A database user tries to add a new row to a table, but the tablespace where the table resides is out of space. This type of failure is considered a(n) ___________ failure, and the DBA can solve this problem by ________________.

    1. User error; providing additional user privileges

    2. User error; increasing the user's quota

    3. Statement failure; enabling resumable space allocation

    4. Statement failure; changing the application logic

  3. Which of the following initialization parameters controls the mean time to recover the database, in seconds, after an instance failure?

    1. FAST_START_IO_TARGET

    2. LOG_CHECKPOINT_TIMEOUT

    3. FAST_START_MTTR_TARGET

    4. MTTR_TARGET_ADVICE

    5. FAST_START_TARGET_MTTR

  4. What background process frees up locks and rolls back uncommitted changes for an abnormally disconnected session?

    1. ORB0

    2. RBAL

    3. SMON

    4. PMON

  5. Which of the following is not a reason for user process failure?

    1. A user's PC suddenly reboots.

    2. The network or an application develops problems.

    3. The DBA kills the user session.

    4. Users terminate SQL*Plus without logging out.

  6. Which of the following can help prevent database network failures? (Choose all that apply.)

    1. Configure a backup listener process on the server.

    2. Open more than one session when updating the database.

    3. Configure multiple network cards on the server.

    4. Create a standby database.

  7. Identify the statement that is not true regarding the loss of a control file.

    1. A damaged control file can be repaired by using one of the remaining undamaged control files, assuming that there are at least two copies of the control file.

    2. The missing or damaged control file can be replaced while the instance is still active.

    3. You can temporarily run the instance with one less control file, as long as you remove one of the references to the missing control file in the SPFILE or init.ora file.

    4. An instance typically fails when one of the multiplexed control files is lost or damaged.

  8. Identify the statement that is not true about checkpoints.

    1. Instance recovery is complete when the data from the last checkpoint up to the latest SCN in the control file has been written to the datafiles.

    2. A checkpoint keeps track of what has already been written to the datafiles.

    3. The redo log group writes must occur before a Commit complete is returned to the user.

    4. The distance between the checkpoint position in the redo log file and the end of the redo log group can never be more than 90 percent of the size of the largest redo log group.

    5. How much the checkpoint lags behind the SCN is controlled by both the size of the redo log groups and by setting the parameter FAST_START_MTTR_TARGET.

  9. The instance can still be started even if some datafiles are missing; this rule does not apply to which tablespaces? (Choose all that apply.)

    1. USERS

    2. SYSTEM

    3. TEMP

    4. SYSAUX

    5. UNDO

  10. Select the statement that is not true regarding media failure.

    1. A media failure occurs when the network card on the server fails.

    2. The DBA accidentally deletes one of the datafiles for the SYSTEM tablespace.

    3. There is a head crash on all physical drives in the RAID controller box.

    4. A corrupted track on a CD containing a read-only tablespace causes a query to fail; therefore, a media failure occurs.

  11. The loss of a datafile in which two tablespaces requires an instance shutdown to recover the tablespace?

    1. TEMP

    2. SYSTEM

    3. UNDO

    4. SYSAUX

  12. To recover a datafile from the SYSTEM or UNDO tablespace, the instance must be in which database state?

    1. NOMOUNT

    2. OPEN

    3. ABORT

    4. MOUNT

  13. The STATUS column of the dynamic performance view V$LOGFILE contains what value if one of the redo log file group members has been lost due to a media failure?

    1. INVALID

    2. STALE

    3. DELETED

    4. The column contains a NULL value.

  14. Place the following events or actions leading up to and during instance recovery in the correct order.

    1. The database is opened and available.

    2. A non-SYSTEM user attempts to connect to the database, and the connection is refused.

    3. A non-SYSTEM user attempts to connect to the database, and the connection is accepted.

    4. Oracle uses undo segments in the undo tablespace to roll back uncommitted transactions.

    5. Power is lost to the database server.

    6. The DBA issues the STARTUP command at the SQL*Plus prompt.

    7. Oracle applies the information in the online redo log files to the datafiles.

      1. 5, 7, 6, 2, 4, 1, 3

      2. 5, 6, 7, 2, 1, 4, 3

      3. 5, 2, 3, 4, 1, 6, 7

      4. 5, 2, 3, 4, 1, 7, 6

      5. 3, 5, 6, 4, 7, 1, 2

      6. 2, 5, 6, 7, 4, 1, 3

  15. The STATUS column of the dynamic performance view V$LOGFILE contains what value if the redo log file group has just been added or the log file group member has just been re-created?

    1. INVALID

    2. STALE

    3. DELETED

    4. The column contains a NULL value.

  16. If a datafile is missing when the instance is started, where is the error message recorded?

    1. Only in the alert log.

    2. All missing files are returned directly to the administrator in the SQL*Plus session.

    3. The first missing file is returned directly to the administrator in the SQL*Plus session, and the rest of the missing files are identified in V$RECOVER_FILE.

    4. Only in the alert log and in the DBWR background process trace files.

  17. In ARCHIVELOG mode, the loss of a datafile for any tablespace other than the SYSTEM or UNDO tablespace affects which objects in the database?

    1. The loss affects only objects whose extents reside in the lost datafile.

    2. The loss affects only the objects in the affected tablespace, and work can continue in other tablespaces.

    3. The loss will not abort the instance, but will prevent other transactions in any tablespace other than SYSTEM or UNDO until the affected tablespace is recovered.

    4. The loss affects only those users whose default tablespace contains the lost or damaged datafile.

  18. Which dynamic performance view shows the datafiles either needing media recovery or missing at instance startup?

    1. V$RECOVER_FILE

    2. V$DATAFILE

    3. V$TABLESPACE

    4. V$RECOVERY_FILE_DEST

    5. V$RECOVERY_FILE_STATUS

  19. A fire breaks out in the server room near the routers, and the operations manager cuts off power to all servers, including the database servers. Before the fire is put out, the disk drive containing the SYSTEM tablespace and both network cards on the Oracle database server are destroyed. The user SCOTT was about to create a new table, but the connection was dropped after the power was disconnected from the server. This scenario is primarily an example of what kind of failure?

    1. Network

    2. Instance

    3. Statement

    4. Media

    5. User error

    6. User process

  20. Which of the following conditions prevents the instance from progressing through the NOMOUNT, MOUNT, and OPEN states?

    1. One of the redo log file groups is missing a member.

    2. The instance was previously shut down uncleanly with SHUTDOWN ABORT.

    3. Either the SPFILE or init.ora file is missing.

    4. One of the five multiplexed control files is damaged.

    5. The USERS tablespace is offline with one of its datafiles deleted.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset