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

Oracle Database 12c: Advanced Administration

Question No: 1

Examine the RMAN command:


Which type of encryption is used for the backup performed by using this command?

  1. password-mode encryption

  2. dual-mode encryption

  3. transparent encryption

  4. default encryption

Answer: A Reference: JABH(to make password -encrypted backups)

Question No: 2

Which two statements are true regarding SecureFile lobs?

  1. The amount of undo retained is user controlled.

  2. They can be used only for nonpartitioned tables.

  3. Fragmentation is minimized by using variable-sized chunks.

  4. They support random reads and writes of encrypted LOB data.

Answer: C,D Reference: LOB46113

Question No: 3

Which two statements are true about service creation for pluggable databases (PDBs)?

  1. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

  2. The defaultservice that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

  3. A database managed by Oracle Restart can have additional services created or existing services modified by usingthe srvctl utility for each PDB.

  4. Only a common user can create additional services for a PDB.

  5. When a PDB is created, a service with the same name as the PDB is created in the PDB.

Answer: C,D

Question No: 4

Which two are prerequisites for creating a backup-based duplicate database?

  1. connecting to the target database and a recovery catalog to execute the duplicate command

  2. creating a password file for an auxiliary instance

  3. connecting to an auxiliary instance

  4. matching the database identifier (DBID) of the source database and the duplicate database

  5. creating an SPFILE for the target database

Answer: A,B Reference: DEDFFH

Question No: 5

You must unload data from the orders, order_items, and products database tables to four filesusing the External Tables.

CREATE TABLE orders_ext

(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL



LOCATION (‘ordersl.dmp#39;,#39;orders2.dmp’,’orders3.dmp’,’lorders4.dmp#39;)


SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi

WHERE o.orderjd = i.order_id and i.product_id = p.product_id;

You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

  1. TYPE





Answer: C

Question No: 6

Examine the parameters for your database instance:



optimizer_adaptive_reporting_onlybooleanFALSE optimizer_capture_sql_plan_baselinesbooleanFALSE optimizer_dynamic_samplinginteger2


Which three statements are true about the process of automatic optimization by using statistics 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 doesnot 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 is toautomatically 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: 7

    You want to move your existing recovery catalog to another database.

    Examine the steps:

    1. Export the catalog data by using the Data Pump Export utility in the source database.

    2. Create a recovery catalog user and grant the necessary privileges in the target database.

    3. Create a recovery catalog by using the create catalog command.

    4. Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.

    5. Import the source recovery catalog schema by using the import catalog command. 6)Connect to the destination database.

    7) Connect as catalog to the destination recovery catalog schema.

    Identify the option with the correct sequence for moving the recovery catalog.

    A. 1, 6, 4

    B. 2, 3, 7, 5

    C. 1, 2, 6, 4

    D. 1, 2, 3, 6, 5

    Answer: C

    Question No: 8

    You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

    $ . oraenv

    ORACLE鈥SID = [oracle] ? cdb1

    The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is


    $ rman target /

    Recovery Manager : Release – production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.

    Connected to target database:CDB1 (DBID=782249327) RMANgt;SELECT name FROMv$tablespace;

    Which statement is true about the execution of the last command?

    1. It succeeds and displays all the tablespaces that belong to the root database.

    2. It fails and returns an error because a connection is not made by using the sysdba privilege.

    3. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

    4. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

    Answer: A

    Question No: 9

    Which three statements are true about persistent lightweight jobs?

    1. A user cannot set privileges on them.

    2. They generate large amounts of metadata.

    3. They may be created as fully self-contained jobs.

    4. They must reference an existing Scheduler Program.

    5. The are useful when users need to create a large number of jobs quickly.

    Answer: A,D,E

    Question No: 10

    Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

    1. A DBA can check specific tables with the DMU

    2. The database to be migrated must be opened read-only.

    3. The release of the database to be converted can be any release since

    4. The DMU can report columns that are too long in the converted characterset

    5. The DMU can report columns that are not represented in the converted characterset

    Answer: A,D,E

    Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps ofthe migration process.

    D: Exceed column limit

    The cell data will not fit into a column after conversion.

    E: Need conversion

    The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

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

    Latesttests 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 Latesttests IT Certification PDF and VCE