[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-063 Dumps with VCE and PDF 101-110

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

Oracle Database 12c: Advanced Administration

Question No: 101

What can be automatically implemented after the SQL Tuning Advisoris run as part of the Automated Maintenance Task?

  1. statistics recommendations

  2. SQL profile recommendations

  3. SQL statement restructure recommendations

  4. creation of materialized views to improve query performance

Answer: C Reference:http://docs.oracle.com/cd/E11882_01/server.112/e16638/sql_tune.htm#PFGRF 028

Question No: 102

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

  1. to store backup information of multiple databases in one place

  2. to restrict the amount of space that is used by backups

  3. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

  4. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog

  5. to automatically delete obsolete backups after a specified period of time

Answer: A,C,D

Question No: 103



You want to recover the data file.




  1. Restore the data file.

  2. Open the database with the resetlog option. 10.Recover the database withthe noredo option. 11.Recover the data file with the noredo option.

Identify the required steps in the correct order.

A. 4, 8, 11, 5

B. 1, 3, 8, 11, 9

C. 1, 2, 6, 3, 7, 10, 9

D. 1, 3, 7, 10, 9

E. 1, 2, 6, 3, 8, 11, 9

Answer: C

Question No: 104

Which three statements are true about Consolidated Database Replay?

  1. The workload capture and replay systems must have the same operating system (OS).

  2. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).

  3. A subset of the captured workload can be replayed.

  4. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

  5. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: B,C,E

Question No: 105


  1. stored scripts in the recovery catalog

  2. available archived redo log files

  3. backup sets and image copies that are obsolete

  4. backups of tablespaces

  5. backups that are marked obsolete according to the current retention policy

Answer: A,B,D

Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585

The primary purpose of the LIST command is to list backup andcopies. For example, you can list:


-Backups that have expired

-Backups restricted by time, path name, device type, tag, or recoverability

-Archived redolog files and disk copies

Question No: 106

When is the UNDO_RETENTION parameter value ignored by a transaction?

  1. when the data file of the undo tablespace is autoextensible

  2. when there are multiple undotablespaces available in a database

  3. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  4. when Flashback Database is enabled

Answer: C Reference:http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm(undo retention, see the bullets)

Question No: 107

Examine the following set of RMAN commands:




EXECUTE SCRIPT arc_backup;


Which statement is true about the RMAN run block execution?


  2. The execution of the script fails because multiple channels cannot exist simultaneously.



Answer: C

Question No: 108

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

  1. whenthe duplicate … from active database command contains the section size clause

  2. when you perform active database duplication on a database with flashback disabled

  3. when you specify set encryption before the duplicate … from active database command

  4. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

  5. when you perform active database duplication on a database that has read- onlytablespaces

Answer: A,C,D


Question No: 109

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.

After a few days, you want to alter the EMPLOYEES table by executing the command: SQLgt; ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

  1. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

  2. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

  3. It executes successfully and continues to store metadata related to the EMPLOYEES table.

  4. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Answer: C

Question No: 110

Examine the output:


Database log modeArchive Mode Automatic archivalEnabled

Archive DestinationUSE_DB_RECOVERY_FILE_DEST Oldest online log sequence376

Next log sequence to archive378 Current log sequence378

Which three types of files are automatically placed in the fast recovery area?

  1. Flashback data archives (FDA)

  2. Archived redo log files

  3. Control file autobackups

  4. Server parameter file (SPFILE)

  5. Recovery Manager (RMAN) backup pieces

Answer: B,C,E Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV 526

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
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

