Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Oracle: Oracle Database 11g: Administration I

    Uploaded by

    vcv
    The document contains sample questions and answers from an Oracle Database 11g: Administration I certification exam. The questions cover topics like database privileges, indexes, tablespace management, initialization parameters, archived redo log files, PL/SQL procedures, and Oracle Data Pump exports.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oracle: Oracle Database 11g: Administration I

    Uploaded by

    vcv
    32 views8 pages
    The document contains sample questions and answers from an Oracle Database 11g: Administration I certification exam. The questions cover topics like database privileges, indexes, tablespace management, initialization parameters, archived redo log files, PL/SQL procedures, and Oracle Data Pump exports.

    Original Description:

    Dumps

    Original Title

    1Z0-052

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains sample questions and answers from an Oracle Database 11g: Administration I certification exam. The questions cover topics like database privileges, indexes, tablespace management, initialization parameters, archived redo log files, PL/SQL procedures, and Oracle Data Pump exports.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    32 views8 pages

    Oracle: Oracle Database 11g: Administration I

    Uploaded by

    vcv
    The document contains sample questions and answers from an Oracle Database 11g: Administration I certification exam. The questions cover topics like database privileges, indexes, tablespace management, initialization parameters, archived redo log files, PL/SQL procedures, and Oracle Data Pump exports.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 8

    Oracle

    1Z0-052
    Oracle Database 11g: Administration I

    Version: 25.7.3

    1 Sample
    QUESTION: 1 The user HR owns the EMP table. The user HR grants privileges to the user SCOTT
    by using this command:

    Which statement is true after HR issues the REVOKE command?

    A. The command fails because SCOTT still has privileges.


    B. The command succeeds and privileges are revoked from JIM.
    C. The command fails because HR cannot revoke the privileges from JIM.
    D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and
    UPDATE operations on the EMP table.

    Answer: C

    QUESTION: 2 Which statement describes the effect on an index, when the indexed column for the
    rows is updated in the base table?

    A. An update in a leaf row takes place.


    B. The index becomes invalid after the update.
    C. The leaf block containing the row to be updated is marked as invalid.
    D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is
    inserted.

    Answer: D

    QUESTION: 3 You are managing an Oracle Database 11g database running in ARCHIVELOG
    mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You
    notice this warning in the alert log file: ORA19815: WARNING: 104

    2 Sample
    db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes
    available. What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)

    A. Back up the Flash Recovery Area.


    B. Decrease the retention time for the database backup and flashback log files.
    C. Manually delete all the archived log files from the Flash Recovery Area by using operating system
    (OS) commands.
    D. Manually delete all the expired backup sets from the Flash Recovery Area by using operating system
    (OS) commands.

    Answer: A, B

    QUESTION: 4 View the Exhibit and examine the setting for a table.

    3 Sample
    Which statement is true about the PCTFREE setting for the table?

    A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other
    blocks.
    B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents
    inserts into the block.
    C. It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain
    the free block information.

    4 Sample
    D. It sets the minimum percentage of a block that can be used for row data plus overhead before new
    rows are added to the block.

    Answer: B

    QUESTION: 195 Which tablespaces are mandatory in an Oracle database for it to be operational?
    (Choose all that apply.)

    A. Undo tablespace
    B. USERS tablespace
    C. SYSAUX tablespace
    D. SYSTEM tablespace
    E. Temporary tablespace

    Answer: C, D

    QUESTION: 6 You executed the following commands in an RMAN session for your database
    instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following
    command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in
    the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE
    command. Which statement is true for the above ADVISE FAILURE command in this scenario?

    A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
    B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
    C. It produces advice only for new failures and the failures listed in the last LIST FAILURE
    command are ignored.
    D. It produces an error with recommendation to run the LIST FAILURE command before the
    ADVISE FAILURE command.

    Answer: A

    QUESTION: 7 View the Exhibit and examine the initialization parameter settings.

    5 Sample
    6 Sample
    Which three initialization parameters are to be set manually as they are not automatically tuned?
    (Choose three.)

    A. LOG_BUFFER
    B. SORT_AREA_SIZE
    C. JAVA_POOL_SIZE
    D. STREAMS_POOL_SIZE
    E. DB_16K_CACHE_SIZE
    F. DB_KEEP_CACHE_SIZE

    Answer: A, E, F

    QUESTION: 8 In your database, the current status of a PL/SQL procedure has become INVALID.
    Which action would fix the problem and make the PL/SQL procedure usable?

    A. Recompile the PL/SQL procedure.


    B. Modify the procedure to run with a definer's right.
    C. Modify the procedure to run with an invoker's right.
    D. Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.

    Answer: A

    QUESTION: 9 The database is running in ARCHIVELOG mode. Examine the initialization


    parameters and their values set to enable archiving on your database server:

    7 Sample
    Which statement is true regarding the archived redo log files?

    A. It will be created on the local file system.


    B. It will be created only in the Flash Recovery Area.
    C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the
    default location $ORACLE_HOME/dbs.
    D. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and
    location specified by the DB_RECOVERY_FILE_DEST parameter.

    Answer: A

    QUESTION: 10 In which situations does the Oracle Data Pump use external tables and not the
    direct path load while exporting a table? (Choose all that apply.)

    A. if a table is not in a cluster


    B. if a table has an active trigger
    C. if a table has an encrypted column
    D. if a table has a column of data type LONG defined on it
    E. if a table has a referential integrity constraint defined on it

    Answer: B, C, E

    8 Sample

    You might also like