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

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

Oracle Database 12c: Installation and Administration

Question No: 41

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEEDcontainer data files in separate directories.

You plan to create the database using SQL statements. Which three techniques can you use to achieve this?

  1. Use Oracle Managed Files (OMF).

  2. Specify the SEED FILE_NAME_CONVERT clause.

  3. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

  4. Specify the DB_FILE_NAMECONVERT initialization parameter.

  5. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

Answer: A,B,C Explanation:

You must specify the namesand locations of the seed#39;s files in one of the following ways:

  • (A) Oracle Managed Files


  • (C) The PDB_FILE_NAME_CONVERT Initialization Parameter

  • Question No: 42

    You have successfully taken a database backup by using the command: RMANgt;BACKUP AS BACKUPSET DATABASE;

    Now you execute this command:


    What is the outcome?

    1. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.

    2. It fails because an incremental level 0 backup does not exist.

    3. It takes a backup of blocks that have been formatted since the last full database backup.

    4. It takes an incremental level 0 backup of the database.

    5. It first takes an incremental level 0 backup and then an incremental level 1 backup.

    Answer: E Explanation:

    References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm (

    Question No: 43

    Which statement is true aboutusing the Database Upgrade Assistant (DBUA) to upgrade

    your database from Oracle Database 11g to Oracle Database 12c?

    1. It terminates if the SYSTEM tablespace in the source database is not autoextensible.

    2. It automatically makes necessary changes to Oracle environment variables.

    3. It automatically enables unified auditing in the upgraded database.

    4. It automatically adds new data files if there is not enough disk space to grow.

    Answer: D Explanation: References:


    Question No: 44

    Which three statements are true about space usage alerts?

    1. Alerts are issued only when the critical threshold for space available in a tablespace is breached.

    2. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

    3. Databasealerts can provide warnings about low space availability at both tablespace and segment levels.

    4. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.

    5. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

    Answer: A,D,E Explanation: References:


    Question No: 45

    The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:


    TOM then executes this command to grant privilegesto the user JIM: SQLgt; GRANT SELET ON hr.bonuses TO jim;

    Which statement is true?

    1. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.

    2. HR can revoke the SELECT ON HR.BINUSES privilege from JIM.

    3. JIM can grant the SELECT ON HR.BONUSESprivilege to other users, but cannot revoke the privilege from them.

    4. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

    Answer: B

    Question No: 46

    Examine the parameters for your database instance:

    Ensurepass 2018 PDF and VCE

    Which three statements are true about the process of automatic optimization by using cardinality feedback?

    1. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

    2. The optimizer can re optimize a query only once using cardinality feedback.

    3. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

    4. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

    5. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

    Answer: A,C,D Explanation:

    C:During the first execution of a SQL statement, an execution plan is generated as usual.

    D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.

    (not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.

    optimizer_dynamic_sampling optimizer_features_enable

    • dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.


    • OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.

      Range of values. 0 to 10

    • Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature isto automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.

    Question No: 47

    To implement Automatic Management (AMM), you set the following parameters:

    Ensurepass 2018 PDF and VCE

    When you try to start the database instance with these parameter settings, you receive the following error message:

    SQL gt; startup

    ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

    Identify the reason the instance failed to start.

    1. The PGA_AGGREGATE_TARGET parameter is set to zero.

    2. The STATISTICS_LEVEL parameter is set to BASIC.

    3. Both the SGA_TARGET and MEMORY_TARGET parametersare set.

    4. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

    Answer: B Explanation:

    Example: SQLgt;startup force

    ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings


    Question No: 48

    Which three operations can be performed as multipartitionoperations in Oracle?

    1. Merge partitions of a list partitioned table

    2. Drop partitions of a list partitioned table

    3. Coalesce partitions of a hash-partitioned global index.

    4. Move partitions of a range-partitioned table

    5. Rename partitions of a rangepartitioned table

    6. Merge partitions of a reference partitioned index

    Answer: A,B,F Explanation:

    Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.

    A: Merge Multiple Partitions:

    The new “ALTER TABLE … MERGE PARTITIONS ” help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.

    B: Drop Multiple Partitions:

    The new “ALTER TABLE … DROP PARTITIONS ” help drop multiple partitions or subpartitions with a single statement.


    view plaincopy to clipboardprint?


    Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7; Table altered


    Restrictions :

    • You can’t drop all partitions of the table.

    • If the table has a single partition, you will get the error: ORA-14083: cannot drop the only

    partition of a partitioned.

    Question No: 49

    Which two statements are true about Oracle Data Pump export and import operations?

    1. You cannot specify how partitioned tables shouldbe handled during an import operation.

    2. Only data can be compressed during an export operation.

    3. Existing dump files can be overwritten during an export operation.

    4. Tables cannot be renamed during an import operation.

    5. Metadata that is exported andimported can be filtered based on objects and object types.

    Answer: D,E

    Question No: 50

    An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.

    How would you guarantee that the blocks for the table never age out?

    1. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

    2. Increase the database buffer cache size.

    3. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.

    4. Configure Automata Shared Memory Management.

    5. Configure Automatic Memory Management-

    Answer: A Explanation:

    Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer poolsenable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.

    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 *