1. Question: Examine the following SQL statement: CREATE TABLESPACE userdata DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

    A
    Extent

    B
    Segment

    C
    Oracle block

    D
    Operating system block

    Note: not sure
    1. Report
  2. Question: What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE?

    A
    The TIMED_STATISTICS parameter is set to TRUE

    B
    The hit percentage in the buffer cache is at least 95%

    C
    The OPEN_CURSOR parameter is set to at least twice the default value

    D
    The value in the RELOADS column of V$LIBRARYCACHE is consistently zero

    Note: not sure
    1. Report
  3. Question: What will happen if the value of the SGA_TARGET parameter is set 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
  4. Question: Which of the following is mandatory when using the easy connect naming method?

    A
    Host name

    B
    Database name

    C
    Service name

    D
    Port number

    Note: not sure
    1. Report
  5. Question: For which two types of tablespaces can proactive tablespace alerts be set?

    A
    Locally managed

    B
    Dictionary-managed

    C
    Read-only

    D
    Online

    Note: not sure
    1. Report
  6. Question: Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified?

    A
    Oracle no longer performs any checkpoint for the online datafiles in the tablespace

    B
    Oracle performs a checkpoint for all online datafiles in the tablespace

    C
    Oracle does not ensure that all files are written

    D
    The offline files may require media recovery before the tablespace is brought online

    E
    The offline files may require media recovery after the tablespace is brought online

    Note: not sure
    1. Report
  7. Question: Where can a SQL Tuning Set(STS) be created from?

    A
    Several SQLs statements from the AWR

    B
    One or more other STSs

    C
    A single SQL statement

    D
    Only the most high-load SQL statements in the database

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