Oracle 10g Database Administration

  1. Question: Evaluate the following SQL: CREATE USER sam IDENTIFIED BY sam; GRANT CREATE ANY MATERIALIZED VIEW, CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE TO dw_manager WITH ADMIN OPTION; GRANT dw_manager TO sam WITH ADMIN OPTION; Which three actions among the following is the user SAM able to perform?

    A
    Select from a table

    B
    Create and drop a materialized view

    C
    Alter a materialized view that was created

    D
    Grant and revoke the role to and from other users

    E
    Enable the role and exercise any privileges in the role's privilege domain

    Note: Not available
    1. Report

  2. Question: A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?

    A
    BLOCKS

    B
    PCT_FREE

    C
    NEXT_EXTENT

    D
    PCT_INCREASE

    Note: Not available
    1. Report

  3. Question: Which of the following is a new initialization parameter for Oracle Database 10g?

    A
    UNDO_SUPPRESS_ERRORS

    B
    PARALLEL_AUTOMATIC_TUNING

    C
    RESUMABLE_TIMEOUT

    D
    SHARED_SERVER

    Note: Not available
    1. Report

  4. Question: Consider this SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?

    A
    The server process places the commit record in the redo log buffer

    B
    Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files

    C
    The user process notifies the server process that the transaction is complete

    D
    The user process notifies the server process that the resource locks can be released

    Note: Not available
    1. Report

  5. Question: For what purpose is the initialization parameter UNDO_RETENTION used?

    A
    To specify the length of time Oracle must retain undo data in the undo tablespace

    B
    To specify the length of time Oracle must retain undo data in the flash recovery area

    C
    To specify the length of time Oracle must retain undo data in the data files

    D
    To specify the length of time Oracle will retain undo data in the flashback database logs

    Note: Not available
    1. Report

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

    A
    SHARED_POOL

    B
    CURSOR_SPACE_FOR_TIME

    C
    DB_NAME

    D
    CURSOR_SHARING

    Note: Not available
    1. Report

  7. Question: An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator.Which of the following index will be used for this criteria?

    A
    Bitmap

    B
    Unique

    C
    Partitioned

    D
    Reverse key

    Note: Not available
    1. Report

  8. Question: Where is the free space managed, for a tablespace created with automatic segment-space management?

    A
    In the extent

    B
    In the control file

    C
    In the data dictionary

    D
    In the undo tablespace

    Note: not sure
    1. Report

  9. Question: Which three out of the following are the physical structures that constitute the Oracle database?

    A
    Segment

    B
    Data file

    C
    Log file

    D
    Tablespace

    E
    Control file

    Note: not sure
    1. Report

  10. Question: When there is a monotonically increasing sequence number as an indexed column, which of the following is true?

    A
    Hash-partitioned global indexes are useful

    B
    Range-partitioned global indexes are better

    C
    Hash-partitioned local indexes are better

    D
    Range-partitioned local indexes are better

    Note: Not available
    1. Report
First123Last
/7
Copyright © 2024. Powered by Intellect Software Ltd