Oracle 10g
 

  1. Question: Where is the trace file generated when a deadlock shutdown is detected by Oracle?

    A
    SQL_TRACE

    B
    TRACE_DEST

    C
    USER_DUMP_DEST

    D
    CORE_DUMP_DEST

    Note: not sure
    1. Report

  2. Question: Which of the following initialization parameters belong to the basic group of parameters?

    A
    SHARED_POOL

    B
    CURSOR_SPACE_FOR_TIME

    C
    DB_NAME

    D
    CURSOR_SHARING

    Note: not sure
    1. Report

  3. Question: Which of the following views provides the names of all the data dictionary views?

    A
    DBA_NAMES

    B
    DBA_TABLES

    C
    DICTIONARY

    D
    DBA_DICTIONARY

    Note: not sure
    1. Report

  4. Question: What will happen if you set the value of the SGA_TARGET parameter higher than the value of the SGA_MAX_ SIZE parameter at instance startup?

    A
    The instance will not start

    B
    SGA_TARGET will become equal to the SGA_MAX_SIZE value

    C
    The database will ignore the SGA_TARGET parameter

    D
    SGA_MAX_SIZE is automatically raised, so it is equal to the SGA_TARGET value

    Note: not sure
    1. Report

  5. Question: Which of the following constitute the 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: Which of the following commands are used to apply incremental backups?

    A
    RECOVER BACKUP OF DATABASE

    B
    RECOVER DATAFILE

    C
    RECOVER COPY OF DATAFILE

    D
    RECOVER COPY OF DATABASE

    Note: not sure
    1. Report

  7. Question: Which of the following physical structures constitute the Oracle database?

    A
    Segment

    B
    Data file

    C
    Log file

    D
    Tablespace

    E
    Control file

    Note: not sure
    1. Report

  8. Question: Which of the following statements are correct for using the RESETLOGS option?

    A
    You don't need to back up the database

    B
    You must back up the database right away

    C
    You can use archive redo logs from an older incarnation of the database

    D
    You cannot use archive redo logs from an older incarnation of the database

    Note: not sure
    1. Report

  9. Question: Which of the following initialization parameters specifies the location of the alert log file?

    A
    UTL_FILE_DIR

    B
    USER_DUMP_DEST

    C
    LOG_ARCHIVE_DEST

    D
    BACKGROUND_DUMP_DEST

    Note: not sure
    1. Report

  10. Question: Which of the following commands revokes the ROLE_DATA role from all the 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
First12345Last
/5
Copyright © 2024. Powered by Intellect Software Ltd