Oracle 10g Database Administration
 

  1. Question: Which of the following items are stored in the flash recovery area?

    A
    Datafiles

    B
    Undo segments

    C
    Datafile copies

    D
    Archived redo log files

    Note: not sure
    1. Report

  2. Question: What is the purpose of the flashback technology in Oracle Database 10g?

    A
    Recovery of a data file from physical corruption

    B
    Recovery of a data file from physical and logical corruption

    C
    Recovery of a data file from logical corruption

    D
    Recovery from a problem brought on by a damaged disk drive

    Note: not sure
    1. Report

  3. Question: Where can the nondefault parameters be found when the instance is started?

    A
    Alert log

    B
    Online redo log

    C
    Archiver redo log

    D
    SYSTEM user's trace file

    Note: not sure
    1. Report

  4. Question: Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?

    A
    TEMP

    B
    DATA

    C
    SYSTEM

    D
    ROLLBACK

    Note: not sure
    1. Report

  5. Question: Which of the following are considered types of segments?

    A
    Only LOBS

    B
    Only nested tables

    C
    Only index-organized tables

    D
    Only LOBS and index-organized tables

    E
    Nested tables, LOBS, index-organized tables, and boot straps

    Note: not sure
    1. Report

  6. Question: What does the RMAN CATALOG command do?

    A
    Helps create image copies of datafiles

    B
    Helps create image copies of current control files

    C
    Helps catalog any new files that aren't a part of the recovery catalog

    D
    Helps catalog only the old files

    Note: not sure
    1. Report

  7. Question: Which command would revoke the ROLE_DATA role from all users?

    A
    REVOKE role_data FROM ALL;

    B
    REVOKE role_data FROM PUBLIC;

    C
    REVOKE role_data FROM default;

    D
    REVOKE role_data FROM ALL_USERS;

    Note: not sure
    1. Report

  8. Question: Which of the following sets of tablespaces is mandatory for any Oracle 10g database?

    A
    SYSTEM, SYSAUX, and UNDOTBS

    B
    SYSTEM and UNDOTBS

    C
    SYSAUX and UNDOTBS

    D
    SYSTEM and SYSAUX

    Note: not sure
    1. Report

  9. Question: To grant a system privilege with the GRANT statement, one should:

    A
    Have been granted the GRANT ROLE PRIVILEGE system privilege

    B
    Have been granted the system privilege with the ADMIN OPTION

    C
    Have been granted the GRANT ANY PRIVILEGE system privilege

    D
    Have been granted the system privilege with the GRANT OPTION

    Note: not sure
    1. Report

  10. Question: Which two statements are true about rebuilding an index?

    A
    The resulting index may contain deleted entries

    B
    A new index is built using an existing index as the data source

    C
    Queries cannot use the existing index while the new index is being built

    D
    During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces

    Note: not sure
    1. Report
First23456Last
/7
Copyright © 2024. Powered by Intellect Software Ltd