1Z0-063 Guide

Far out 1Z0-063 exam price Guide

Act now and download your Oracle 1Z0-063 test today! Do not waste time for the worthless Oracle 1Z0-063 tutorials. Download Regenerate Oracle Oracle Database 12c: Advanced Administration exam with real questions and answers and begin to learn Oracle 1Z0-063 with a classic professional.

Q41. 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:


Q42. Which parameter must be set to which value toimplement automatic PGA memory management? 

A. Set memory_target to zero. 

B. Set STATISTICS_LEVEL to BASIC. 

C. Set pga_aggregate_target to a nonzero value. 

D. Set pga_aggregate_target and sga_target to the same value. 

E. Set sgajtarget to zero. 

Answer:

rence:http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11 


Q43. In which situation can you use Flashback Database? 

A. whenundoing a shrink data file operation 

B. when retrieving a dropped tablespace 

C. when returning to a point in time before the restoration or re-creation of a control file 

D. when returning to a point in time before the most recent open resetlogs operation 

Answer:

Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm(pre requisites, thirdpara) 

http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194 


Q44. user_data is a nonencryptedtablespace containing tables with data. 

You must encrypt ail data in this tablespace. 

Which three methods can do this? 

A. Use Data Pump. 

B. Use ALTERTABLE. . .MOVE 

C. Use CREATE TABLE AS SELECT 

D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its 

E. Use altertablespace to encrypt thetablespace. 

Answer: A,B,C 


Q45. Examine the RMAN command: 

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG; 

Which prerequisitemust be met before accomplishing the backup? 

A. The password for the encryption must be set up. 

B. Oracle wallet for the encryption must be set up. 

C. All the tablespaces in the database must be encrypted. 

D. Oracle Database Vault must be enabled. 

Answer:

Reference:configuration encryption will use by Transparent encryption, For transparent encryption, you will need to create a wallet, and it must be open. 

Transparent encryption will then occur automatically after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command. 

http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH 

QUESTIONNO: 15 

A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command: 

RMAN> BACKUP 

AS COMPRESSED BACKUPSET 

SECTION SIZE 1024M 

DATABASE; 

Which statement is true about the execution of the command? 

A.The backup succeeds only if all the tablespaces are locally managed. 

B.The backup succeeds only if the RMAN default device for backup is set to disk. 

C.The backup fails because you cannot specify section size for a compressed backup. 

D.The backup succeeds and only the used blocks are backed up with a maximum backup 

piece size of 1024 MB. 

Answer:


Q46. The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. 

The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user. 

A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open. 

In the CATDB12c database, you execute the commands: 

Srman 

RMAN> CONNECT CATALOG rc12c/pass12c8catdbI2c 

RMAN> IMPOST CATALOG rc1l/pwdcatl19catdbl1 DBID=I423241; 

What is the outcome of the import? 

A. It fails because the target database and recovery catalog database are of different versions. 

B. It succeeds and all global scripts in the sc:: catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed. 

C. It succeeds but the database is not automatically registered in the Rc12c catalog. 

D. It fails because RMAN is not connected to the target database with DBID=1423241. 

Answer:


Q47. Examine the command: 

$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull 

Which statement is true about the execution of the command? 

A. It fails because the log file parameter is not specified. 

B. It fails because no absolutepath is specified for the log file and dump file. 

C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations. 

D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three. 

Answer:


Q48. Which two statements are true abouta multitenant architecture? 

A. Each pluggable database (PDB) has its own initialization parameter file. 

B. A PDB can have a private undo tablespace. 

C. Log switches occur only at the container database level. 

D. A PDB can have a private temporary tablespace. 

E. Each PDB has a private control file. 

Answer: C,D 


Q49. You created a tablespace with this statement: 

CREATE BIGFILE TABLESPACE adtbs 

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? 

A. ALTER TA3LESPACE adtbs RESI2E 20G; 

B. ALTER TA3LESPACE adtbs ADD DATAFILE; 

C. ALTER TABLESPACE adtbs AUTOEXTEND ON; 

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

E. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON; 

Answer: A,C 

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


Q50. Which three statements are true about a job chain? 

A. It can contain a nested chain of jobs. 

B. It can be used to implement dependency-based scheduling. 

C. It cannot invoke the same program or nested chain in multiple steps in the chain. 

D. It cannot have more than one dependency. 

E. It can be executed using event-based or time-based schedules. 

Answer: A,B,E 

Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#AD 

MIN12459 


To know more about the 1Z0-063, click here.

Tagged as : Oracle 1Z0-063 Dumps, Download 1Z0-063 pdf, 1Z0-063 VCE, 1Z0-063 pass4sure, examcollection 1Z0-063