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

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 are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.

One of the data files is corrupted and the current online redo log file is lost because of a media failure.

You want to recover the data file.

Examine the steps involved in the recovery process: 1.Shut down the database instance.

2.Start up the database instance in nomount state. 3.Mount the database.

4.Take the data file offline. 5.Put the data file online. 6.Restore the control file. 7.Restore the database.

  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

For which three pieces of information can you use the RMAN list command?

  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 and proxy copies of a database, tablespace, datafile, archived redo log, or control file

-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?

  1. The script is executed and both DC1 and chi channels are used for script execution.

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

  3. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.

  4. The new channel, chi, is ignored because a channel has been configured already.

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% Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-063 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
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 *