[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-062 Dumps with VCE and PDF 61-70

2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c: Installation and Administration

Question No: 61

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:

$ make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME Which two steps should you perform before executing this command?

  1. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.

  2. Drop any existing fine-grained audit (FGA) policies.

  3. Stop the listener.

  4. Shit down the database instance.

  5. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

Answer: C,E Explanation:

References: https://blogs.oracle.com/UPGRADE/entry/unified_auditing_is_it_on

Question No: 62

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.

You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2′

How should the DB_FLASH_CACHE_SIZE be configured to use both devices?


  2. Set DB_FLASH_CACHE_ZISE = 64G, 64G

  3. Set DB_FLASH_CACHE_ZISE = 128G.

  4. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Answer: B Explanation:

  • Smart Flash Cache concept is not newin Oracle 12C – DB Smart Flash Cache in Oracle 11g.

    In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” area.In previous releases only one file|device could be defined.

    DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G

    So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”

    /dev/sda – size 32G

    /dev/sdb – size 32G

    /dev/sdc – size 64G

    New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency

    Question No: 63

    You areadministering a database that supports an OLTP workload.

    The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.

    The user SCOTT queries a large table during peak activity.

    Thequery runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old

    Which is possible reason for this?

    1. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

    2. The query is unable to place data blocks in the UNDO tablespace.

    3. The flashback data archive is not enabled for the table on which the query is issued.

    4. There is not enough space in Fast Recovery Area.

    5. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

    Answer: A

    Question No: 64

    Which two statements are true about using SQL *Loader?

    1. It can load data from external files by using the direct path only.

    2. It can load data into multiple tables using the same load statement.

    3. It can load data into one table ata time.

    4. It can generate unique sequential key values in specified columns.

    5. It can load data from external files by using the conventional path only.

    Answer: A,D Explanation:

    References: https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm (sql*loader features)

    Question No: 65

    Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

    1. shutting down the database instance that is being upgraded

    2. executing the catctl.pl script to run the upgrade processes in parallel

    3. running the Pre-Upgrade Information Tool

    4. copying thelistener.ora file to the new ORACLE_HOME

    Answer: C Explanation: References:

    Question No: 66

    You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:

    • Long-running queries are not affected.

    • No extra space is used.

    • Data manipulation language (DML) operations on the table succeed at all times throughout the process.

    • Unused space is reclaimed both above and below the high water mark. Which ALTER TABLE option would you recommend?





      Answer: C Explanation:

      References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

      Question No: 67

      Flashback is enabled for your multitenant containerdatabase (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.

      You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:


      SQL gt;FLASHBACK DATABASE to TIME “TO_DATE (’08/20/12′ , ‘MM/DD/YY’)”;

      Examine following commands:




        Which command or commands should you execute next to allow updates to the flashback back schema?

        1. Only 1

        2. Only 2

        3. Only 3

        4. 3 and 1

        5. 1 and 2

          Answer: D

          Question No: 68

          A userestablishes a connection to a database instance by using an Oracle Net. You want to ensure that:

          1. The user account must be locked after five consecutive unsuccessful login attempts.

          2. Data read per session must be limited for the user.

          3. The user cannot have more than three simultaneous sessions.

          4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.

            Which two would you do to implement this?

            1. by alerting the appropriate user attributes with an ALTERUSER command

            2. by using appropriate PASSWORD parameters set in the profile assigned to the user

            3. by implementing Database Resource Manager and assign it a profile for the user

            4. by implementing Database Resource Manager and assign it a role for the user

            5. by using appropriate KERNEL parameters set in the profile assigned to the user

    Answer: C

    Question No: 69

    Which two statements are true?

    1. A role cannot be assigned external authentication.

    2. Arole can be granted to other roles.

    3. A role can contain both system and object privileges.

    4. The predefined resource role includes the unlimited_tablespace privilege.

    5. All roles are owned by the sys user.

    6. The predefined connect role is always automatically granted to all new users at the time of their creation.

    Answer: B,C Explanation: References:

    Question No: 70

    Which three statements are true about automated maintenance tasks?

    1. They run at predefined time intervals that are intended to occur during a period of low system load.

    2. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

    3. A maintenance window is automatically extended untilall the maintenance tasks defined are completed.

    4. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

    5. Predefined maintenance tasks consist of automatic optimizer statistics collection, running AutomaticSegment Advisor, and running Automatic SQL Tuning Advisor.

    Answer: A,B,E

    100% Free Download!
    Download Free Demo:1z0-062 Demo PDF
    100% Pass Guaranteed!
    Download 2018 EnsurePass 1z0-062 Full Exam PDF and VCE

    EnsurePass ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

    2018 EnsurePass IT Certification PDF and VCE

  • Leave a Comment


    Your email address will not be published. Required fields are marked *