[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-063 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-063
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-063.html

Oracle Database 12c: Advanced Administration

Question No: 11

In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS.

You rename the undotbs undo tablespace:

ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?

  1. The tablespace will be renamed but the data file headers will not be updated.

  2. The statement will fail because you cannot rename an undo tablespace.

  3. The tablespace will be renamed and all the changes will be logged in the alert log.

  4. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

  5. You must set the undo_tablespace parameter to some other tablespace name before

renaming undotbs.

Answer: C

Question No: 12

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.

Examine the command executed to back up pdb2_1: RMANgt; BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

  1. It fails because archive log files cannot be backed up using a connection to a PDB.

  2. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.

  3. It succeeds andall data files belonging to PD32_i are backed up along with the archive log files.

  4. It fails because the pluggable clause is missing.

Answer: C

Question No: 13

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.

Which step should you perform next to start the upgrade of the database?

  1. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files duringthe upgrade.

  2. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

  3. Start up the database instance by using theSTARTUP UPGRADE command and gather

    fixed object statistics to minimize the time needed for recompilation.

  4. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Answer: C

Question No: 14

You create two Resource Manager plans, one for night time workloads, the other for day time.

How would you make the plans switch automatically?

  1. Use job classes.

  2. Use scheduler windows.

  3. Use the mapping rule for the consumer groups.

  4. Set the switch_time plan directive for both plans.

  5. Use scheduler schedules.

Answer: B

Question No: 15

Evaluate these statements:

CREATE TABLE purchase_orders (po_idNUMBER(4), po_dateTIMESTAMP, supplier_idNUM8ER(6),

po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITIONBYRANGE(po_date)

(PARTITIONQ1 VALUESLESSTHAN (TO_DATE(#39;01-apr-2007#39;,#39;dd-mon-yyyy#39;)), PARTITIONQ2VALUESLESSTHAN(TO_DATE(#39;01-jul-2007#39;,#39;dd-mon-yyyy#39;)), PARTITIONQ3VALUESLESSTHAN (TO~DATE(#39;01-oct-2007#39;,#39;dd-non-yyyy#39;)), PARTITIONQ4VALUESLESSTHAN (TO_DATE(#39;Ol-jan-2008#39;,#39;dd-non-yyyy#39; )));

CREATETABLEpurchase_order_items (po_idNUM3ER(4)NOTNULL,

product_idNUMBER(6)NOTNULL, unit_prlceNUMBER(8,2),

quantity NUMBER(8), CONSTRAINTpo_items_f k

FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) ) PARTITIONBYREFERENCE(po_items_fk);

Which two statements are true?

  1. Partitions of purchase_order_items are assigned unique names based on a sequence.

  2. The purchase_orders and purchase_order_items tables are created with four partitioneach.

  3. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.

  4. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

  5. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Answer: C,E

Question No: 16

Your database is running in archivelog modeand Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

  1. Enable minimal supplemental logging.

  2. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

  3. Enable the recyclebin.

  4. Enable undo retention guarantee.

  5. Enable Fast Recovery Area.

Answer: A,C

Question No: 17

You execute the RMAN commands:

RMANgt; BACKUP VALIDATE DATABASE; RMANgt; RECOVER CORRUPTION LIST;

Which task is performed by these commands?

  1. Corrupted blocks, if any, are repaired in the backup created.

  2. Only those data files that have corrupted blocks are backed up.

  3. Corrupted blocks in the data files are checked and repaired before performing the database backup.

  4. The database is checked for physicallycorrupt blocks and any corrupted blocks are repaired.

    Answer: C

    Question No: 18

    Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

    1. Create a policy to capture the privileges used by a user for privilege analysis.

    2. Generate a report with the data captured for a specified privilege capture. 3.Start analyzing the data captured by the policy.

  1. Revoke the unused privileges.

  2. Compare the used and unused privileges#39; lists.

  3. Stop analyzing the data.

Identify the correct sequence of steps.

A. 1, 3, 5, 6, 2, 4

B. 1, 3, 6, 2, 5, 4

C. 1, 3, 2, 5, 6, 4

D. 1, 3, 5, 2, 6, 4

Answer: B

Explanation: 1. Create a policy to capture the privilege used by a user for privilege analysis.

3. Start analyzing the data captured by the policy.

6. Stop analyzing the data.

2. Generate a report with the data captured for a specified privilege capture.

5. Compare the used and unused privileges’ lists.

  1. Revoke the unused privileges.

    Question No: 19

    Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.

    Which method would you use to recover the data file?

    1. Shut downthe instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.

    2. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.

    3. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

    4. Mount the database, restore all data files belongingto the system tablespace from the last backup, and open the database.

Answer: C

Question No: 20

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

SQLgt; SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

Ensurepass 2018 PDF and VCE

Which two statements are true?

  1. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

  2. An attempt to start a new session by a user belonging to OTHE_GROUPS fails withan error.

  3. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

  4. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

  5. A user belonging to the DSS QUERIES resource consumer group can create a new session but the session will be queued.

Answer: C,E

100% Ensurepass Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-063 Dumps

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

Leave a Reply

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