1Z0-063 free samples(111 to 118) for consumer: Sep 2016 Edition

Want to know {brand} 1Z0-063 Exam practice test features? Want to lear more about Oracle Oracle Database 12c: Advanced Administration certification experience? Study Validated Oracle 1Z0-063 answers to Avant-garde 1Z0-063 questions at {brand}. Gat a success with an absolute guarantee to pass Oracle 1Z0-063 (Oracle Database 12c: Advanced Administration) test on your first attempt.

2016 Sep 1Z0-063 Study Guide Questions:

Q111. Yourdatabase is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost. 

Examine the steps to restore the SPFILE and the control file to mount the database: 

1. Set D3ID of the target database in RMAN. 

2.Start the database instance by using the startup force nomount command in RMAN. 

3.Restore the control files from the backup. 

4.Mount the database. 

5.Restore theSPFILE from the autobackup. 

6.Create a PFILE from the recovered SPFILE. 

7.Restart the instance in nomount state. 

Identify the required steps in the correct order. 

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

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

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

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

Answer: C 

104. 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 


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 

Q112. You restore and recover your database to anew host by using an existing RMAN open database backup. 

Which step must you perform next? 

A. Execute catproc.sqi to recompile invalid PL/SQL modules. 

B. Open the database with the resetlogs option. 

C. Set a new database identifier (DBID) for the newly restored database. 

D. Use the RMAN set newname and switch commands to switch to new files. 

Answer: A 

1Z0-063  practice exam

Renewal 1Z0-063 vce:

Q113. You are administering a multitenant container database (CDB) cdb1 that is running in 

archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. 

While opening pdb_1, you get an error: 

SQL> alter pluggable database pdb_1 open; 


ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf' 

To repair the failure, you open an RMAN session for the target database CDBSROOT. You 

execute the following as the first command: 


Which statement describes the consequence of the command? 

A. The command performs the recovery and closes the failure. 

B. The command produces an error because RMAN is not connected to the target database pdb_1. 

C. The command produces an errorbecause the advise failure command was not executed before the REPAIRFAILUER command. 

D. The command executes successfully, performs recovery, and opens PDB_1. 

Answer: D 

Q114. View the SPFILE parameter settings in the Exhibit. 

You issue this command and get errors: 

SQL> startup 

ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation 

Why did the instance fail to start? 

A. because pga_aggregate_target is not set 

B. because statistics_level is set to basic 

C. because memory_target and memory_max_target cannot be equal 

D. because sga_target and memory_target are both set 

Answer: B 

1Z0-063  practice exam

Tested 1Z0-063 :

Q115. You created a tablespace with this statement: 


DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; 

The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table. 

Which two alter statements will achieve this? 




D. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG; 


Answer: A,C 

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php 

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

A. stored scripts in the recovery catalog 

B. available archived redo log files 

C. backup sets and image copies that are obsolete 

D. backups of tablespaces 

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

Answer: A,B,D 



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 

Q117. On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: 

S>sqlldrhr/hr@pdb table=employees 

Which two statements are true about the command? 

A. It succeeds with default settings if the employees table exists in the hr schema. 

B. It fails because no SQL*Loader data file location is specified. 

C. It fails if the hr user does not have the create any directory privilege. 

D. It fails because no SQL*Loader control file location is specified. 

E. It succeeds and creates the employees table in the HR schema. 

Answer: B,D 

Q118. 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. 

8.Restore the data file. 

9.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 

About 1Z0-063 Information: 1Z0-063 Dumps