Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 201:

  Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).

  It was started up by using the command which executed successfully with no errors:

  SQL> STARTUP MOUNT

  Which two statements are true? (Choose two.)

  A. All redo logs are opened.

  B. All control files are opened.

  C. All tempfiles are opened.

  D. CDB$ROOT is opened.

  E. The SPFILE is opened.

  Correct Answer: AD

• Question 202:

  Which three are true about Transparent Data Encryption (TDE)? (Choose three.)

  A. It stores the current and all past master keys in the keystore.

  B. It replaces secure application roles.

  C. Master encryption keys are managed by Oracle Database Vault.

  D. It can encrypt data at the column level.

  E. It uses a single master key for a database.

  F. It encrypts only data on the client.

  Correct Answer: ACD

  Reference: https://docs.oracle.com/database/121/ASOAG/introduction-to-transparent-dataencryption.htm#ASOAG10117

• Question 203:

  You plan to create a new PDB by copying PDB$SEED.

  Which two requirements ensure a successful creation? (Choose two.)

  A. The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.

  B. A default service for the new PDB name must already exist.

  C. A PDB local administrative user must be granted the DBA role when creating the PDB.

  D. A PDB local administrative user must be specified when creating the PDB.

  E. The CDB, which will contain the PDB, must be in READ WRITE mode.

  F. The CDB must use Oracle Managed Files.

  Correct Answer: CE

• Question 204:

  You issued these commands for one of your databases:

  RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

  RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING

  FILE `/mydir/rman_change_track.f';

  RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

  Which two are true? (Choose two.)

  A. The cumulative incremental level 1 database backup ignores the block change tracking file.

  B. Future cumulative incremental level 1 database backups will reference the block change tracking file.

  C. Future incremental level 0 database backups will reference the block change tracking file.

  D. The cumulative incremental level 1 database backup fails.

  E. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.

  Correct Answer: BE

  Reference: https://docs.oracle.com/database/121/ADMQS/GUID-3BAA0D48-CA35-4CD7-810E50C703DC6FEB.htm

• Question 205:

  Which two result in an inconsistent backup? (Choose two.)

  A. an RMAN backup taken for an open database in ARCHIVELOG mode

  B. a differential incremental backup

  C. a backup taken immediately after a SHUTDOWN ABORT command

  D. a user-managed backup taken for a closed database in NOARCHIVELOG mode

  E. an RMAN full backup taken for a database in NOARCHIVELOG mode

  Correct Answer: CE

• Question 206:

  Which three RMAN persistent settings can be set explicitly? (Choose three.)

  A. archivelog deletion policy

  B. SPFILE backup duplexing

  C. image copy duplexing

  D. archivelog backup duplexing

  E. redo log backup duplexing

  F. controlfile autobackup formats

  Correct Answer: ACF

• Question 207:

  One of your database suffered an instance failure.

  At the next startup, from which point in the redo logs does instance recovery begin?

  A. from a point corresponding to the most recent successful transaction commit

  B. from a point corresponding to the most recent log instance checkpoint

  C. from a point corresponding to the most recent incremental checkpoint

  D. from a point corresponding to the most recent checkpoint of any kind

  E. from a point corresponding to the most recent log switch checkpoint

  Correct Answer: A

  Reference: http://www.cs.kent.edu/~wfan/link/dbapre/dbatest/54913f.htm

• Question 208:

  One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.

  The USERS and IDX tablespaces are missing due to storage array errors.

  Which four actions would recover the tablespaces and their contents while the database remains open? (Choose four.)

  A. Bring both tablespaces ONLINE.

  B. Recover both tablespaces.

  C. Take both tablespaces OFFLINE NORMAL.

  D. Take both tablespaces OFFLINE IMMEDIATE.

  E. Restore both tablespaces from the most recent backup.

  F. Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace.

  Correct Answer: ABDE

• Question 209:

  Your database is on ARCHIVELOG mode and an incremental backup exists. A media failure in the loss of a data file and an online redo log.

  Examine these commands:

  1.

  STARTUP NOMOUNT

  2.

  STARTUP MOUNT

  3.

  RESTORE DATABASE

  4.

  RECOVER DATABASE

  5.

  RECOVER DATABASE UNTIL CANCEL

  6.

  ALTER DATABASE OPEN

  7.

  ALTER DATABASE OPEN RESETLOGS

  Which commands are required to recover your database?

  A. 2, 3, 5, and 6

  B. 2, 3, and 4

  C. 2, 3, 5, and 7

  D. 1, 3, 5, and 6

  E. 1, 3, and 4

  Correct Answer: E

  Reference: https://docs.oracle.com/cd/E25178_01/backup.1111/e10642/rcmadvre.htm

• Question 210:

  One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.

  You connect to PDB2 as a common user with DBA privileges.

  The STATISTICS_LEVEL parameter is PDB modifiable.

  As the user SYS, you execute this command successfully on PDB2: SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;

  Which two statements are true about the result of this command?

  A. The data dictionary in PDB2 is updated.

  B. The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.

  C. The SPFILE is updated.

  D. The data dictionary in CDB$ROOT is updated.

  E. The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs.

  Correct Answer: B