3.9. Review Questions

  1. Which of the following statements is true about non-critical losses?

    1. Non-critical losses require media recovery.

    2. Non-critical losses have a severe impact on database operations.

    3. Non-critical losses can be resolved quickly with little impact to database operations.

    4. Non-critical losses require the use of the RECOVER command.

  2. Which of the following statements is true about temporary tablespaces?

    1. Temporary tablespaces most often contain some permanent objects.

    2. Temporary tablespaces are responsible for storing temporary or sort statements.

    3. Temporary tablespaces must be recovered with the RECOVER command.

    4. Temporary tablespaces cannot be managed locally.

  3. Why is a missing tempfile considered a non-critical recovery situation?

    1. The tempfile is dictionary managed and can only contain some permanent objects.

    2. The tempfile is locally managed and can only contain some temporary objects.

    3. The tempfile is locally managed and can only contain temporary objects.

    4. The tempfile is dictionary managed and can only contain temporary objects.

  4. How can you resolve a missing temporary tablespace quickly? (Choose all that apply.)

    1. Recover the tablespace immediately because restoring is not needed.

    2. Restore the tablespace from disk and not from tape.

    3. Run CREATE TEMPORARY TABLESPACE and then ALTER DATABASE to the new temporary tablespace.

    4. If a temporary tablespace exists, then run ALTER DATABASE to the existing temporary tablespace.

  5. What must be done to recover a missing redo log file member?

    1. First perform a ALTER DATABASE DROP LOGFILE MEMBER filename and then ALTER DATABASE ADD LOGFILE MEMBER filename on the missing logfile member.

    2. Perform ALTER DATABASE ADD LOGFILE MEMBER filename on the missing logfile.

    3. Nothing is required if you have multiplexed redo logs.

    4. Nothing is required if you do not have multiplexed redo logs.

  6. How would you know if you have lost a mirrored redo log member?

    1. The database would hang.

    2. The archive process would stop working.

    3. The alert log would display an error, and the database would hang.

    4. The alert log would display an error, and the database would process the archive logs.

  7. What happens if the current or active online redo log group has a new member added?

    1. Nothing, the redo log member will be added.

    2. The redo log member will not be added because the log group is actively recording transactions.

    3. The redo log member will be added, but it will be out of sync until a log switch occurs.

    4. The redo log member will be added, but it will be empty.

  8. What happens when you are recovering a temporary tablespace by switching to another available tablespace? (Choose all that apply.)

    1. The new temporary tablespace is made available if the tablespace is permanent.

    2. The new temporary tablespace is made available if the tablespace is temporary.

    3. You will receive an ORA-12904 error if the available tablespace is temporary.

    4. You will receive an ORA-12904 error if the available tablespace is permanent.

  9. How can you rebuild the objects in the index tablespace most efficiently?

    1. Recover the index from tape.

    2. Rebuild the index with LOGGING.

    3. Rebuild the index with NOLOGGING.

    4. Rebuild the index in parallel with NOLOGGING.

  10. What should be updated and readily accessible in case of a non-critical loss of a tablespace?

    1. Temporary segments

    2. SELECT statements using sorting

    3. Current index scripts

    4. Create table scripts

  11. Which type of tablespace contains static data?

    1. Read-only tablespace

    2. Index tablespace

    3. Read-write tablespace

    4. Temporary tablespace

  12. What is the result of starting an Oracle database with a missing read-only tablespace? (Choose two.)

    1. The database opens normally.

    2. The database only mounts.

    3. An ORA-01157 cannot identify datafile halts the database from opening error occurs.

    4. The database functions normally, and the read-only tablespace is static.

  13. When connecting to an Oracle database locally to perform administrative functions, you are connecting with what access privilege?

    1. SQL*Net

    2. IPC

    3. SYSDBA

    4. SYSOPER

  14. What is the proper way of creating a password supporting up to 10 users?

    1. orapwd file=orapwORA101T password=syspass users=10

    2. orapwd file=orapwORA101T password=syspass entry=10

    3. orapwd file=orapwORA101T password=syspass entries=10

    4. orapass file=orapwORA101T password=syspass entries=10

  15. Which initialization parameter is required for remote access to the database?

    1. REMOTE_LOGIN_PASSWORDFILE

    2. BREMOTE_LOGIN_PASSWORD_FILE

    3. REMOTE_PASSWORD_FILE

    4. REMOTE_LOGIN_FILE

  16. Which directory should the password file be stored in to function properly? (Choose all that apply.)

    1. $ORACLE_HOME

    2. $ORACLE_HOME/dbs

    3. C:$ORACLE_HOMEdatabase

    4. $ORACLE_SID

  17. Before running the ORAPWD utility to generate a password file, what should be done?

    1. Start the database but make sure it isn't open.

    2. Start up the database.

    3. Start up the database in MOUNT mode.

    4. Shut down the database.

  18. What do local connections to an Oracle database rely on for security and authentication of the user?

    1. Password file

    2. Database password

    3. Operating system password

    4. Listener password

  19. The main reason that you need to restore and use the RECOVER command on a tablespace that was backed up read-write and converted to read-only is due to what? (Choose all that apply.)

    1. The checkpointing process has changed the control file.

    2. There have been changes to the tablespace.

    3. The tablespace file header has been changed.

    4. Read-only tablespaces require the RECOVER command.

  20. Which situation is considered a non-critical loss to the database? (Choose all that apply.)

    1. Loss of redo log group before archived

    2. Loss of current or active redo member

    3. Loss of archive log

    4. Loss of current or active redo group

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

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