Free 1Z0-063 Exam Dumps

Question 21

- (Exam Topic 1)
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1 is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database mounted.

Correct Answer:ABE

Question 22

- (Exam Topic 1)
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed. Which backup strategy satisfies the requirements?

A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Correct Answer:A

Question 23

- (Exam Topic 1)
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

A. The backup must be performed in MOUNT state.
B. The tablespace must be taken offline.
C. All files must be backed up as backup sets.
D. The database must be backed up as an image copy.

Correct Answer:C

Question 24

- (Exam Topic 2)
What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

A. It generates a log file containing the fixes that can be made to the source database.
B. It recompiles all invalid PLSQL and Java code.
C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
D. It provides a summary of the upgrade results.
E. It generates fixup scripts to be run on the source database before upgrade.

Correct Answer:C

Question 25

- (Exam Topic 1)
Examine the command used to perform an incremental level-0 backup: RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command: RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation? (Choose two.)

A. The block change tracking data is used only from the next incremental backup.
B. The incremental level 1 backup fails because a block change tracking file is created after the level 0 backup.
C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Correct Answer:CE