Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 161:

  Which three are true about RMAN duplexed backup sets or image copies? (Choose three.)

  A. A backup set may be duplexed with both copies written to disk.

  B. An image copy on sbt can be copied to disk.

  C. A backup set may be duplexed with both copies written to sbt.

  D. An image copy on disk can be copied to sbt.

  E. An image copy on disk can be copied to disk.

  F. A backup set may be duplexed so that one copy is written to sbt and the other to disk.

  Correct Answer: ACF

• Question 162:

  Examine this command:

  RMAN> BACKUP VALIDATE DATABASE;

  Which three statements are true? (Choose three.)

  A. The command checks for blocks containing all zeros.

  B. The command checks for blocks containing an invalid checksum.

  C. The command checks for blocks containing a corrupt block header.

  D. The command checks for blocks that contain invalid column lengths.

  E. The command backs up the database regardless of the state of the blocks.

  F. The command backs up the database only if all blocks are valid.

  Correct Answer: ABC

  Reference https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmvalid.htm#BRADV90065

• Question 163:

  One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You

  connect to CDB$ROOT as SYS and execute these commands successfully:

  SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;

  SQL> CREATE ROLE C##CONNECT;

  SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

  SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

  Which three are true? (Choose three.)

  A. The C##CONNECT role can be granted different roles and privileges in each PDB.

  B. C##ADMIN has the orcl123 password in all PDBs.

  C. The C##CONNECT role is granted to the C##ADMIN user in all PDBs.

  D. CREATE SESSION is granted to the C##ADMIN user in all PDBs.

  E. The C##CONNECT role is a local role defined only in CDB$ROOT.

  Correct Answer: ACE

• Question 164:

  You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your

  database server that is running on Oracle Linux.

  You have set the db_smart_flash_file parameter:

  DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2`

  How should the D3_flash_cache_size be configured to use both devices?

  A. Set DB_FLASH_CACHE_SIZE=64G.

  B. Set D3_FLASH_CACHE_SIZE=64G, 64G.

  C. Set D3_FLASK_CACKE_SI2E=128G.

  D. db_flash_cache_SI2E is automatically configured by the instance at startup.

  Correct Answer: B

  * Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g. In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database Smart Flash Cache" area. In previous releases only one file| device could be defined. DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G So above settings defines 3 devices which will be in use by "DB Smart Flash Cache" /dev/sda ?size 32G /dev/sdb ?size 32G /dev/sdc ?size 64G New view V$FLASHFILESTAT ?it's used to determine the cumulative latency and read counts of each file| device and compute the average latency

• Question 165:

  Which three statements are true about using RMAN without a recovery catalog? (Choose three.)

  A. No archive log deletion policies will be possible.

  B. The REPORT SCHEMA command will report only the current database schema.

  C. CONTROL_FILE_RECORD_KEEP_TIME may need to be increased.

  D. The RMAN backup retention can only be configured to use a redundancy based policy.

  E. Database duplication will require a connection to the target.

  F. CONTROL_FILE_RECORD_KEEP_TIME may need to be decreased.

  Correct Answer: BCD

• Question 166:

  A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.

  

  Examine the possible steps that are in random order:

  1. Shut down the database instance.

  2.Issue ALTER SYSTEM SET CONTROL_FILES= `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/

  app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/ control03.ctl'

  SCOPE=SPFILE;.

  3.

  Issue ALTER SYSTEM SET CONTROL_FILES=

  `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/

  app/oracle/oradata/cdb1/disk3/control03.ctl';.

  4.

  Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.

  5.

  Mount the database.

  6.

  Open the database.

  Identify the required steps in the correct order to accomplish the task.

  A. 3, 4

  B. 2, 6

  C. 3, 1, 4, 6

  D. 1, 5, 2, 4, 6

  E. 2, 1, 4, 6

  Correct Answer: E

• Question 167:

  You want to duplicate one of your databases when connected to the target database and to the recovery catalog.

  Which three are true about this type of database duplication? (Choose three.)

  A. The duplication process can create backup sets or image copies.

  B. The target database must be open.

  C. The duplication process pushes image copies to the auxiliary instance.

  D. The duplication process can use existing backup sets or image copies.

  E. The duplication process pushes backup sets to the auxiliary instance.

  F. The target database must be in mount state.

  Correct Answer: BEF

  Reference https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/DUPLICATE.html#GUIDE13D8A02-80F9-49A2-9C31-92DD3A795CE4

• Question 168:

  You plan to upgrade a production database running in NOARCHIVELOG mode that has no Fast Recovery

  Area configured.

  The upgrade must be reversable within as quickly as possible with the smallest overhead.

  Which three steps must you perform before you start the upgrade? (Choose three.)

  A. Configure a flashback retention target and the Fast Recovery Area.

  B. Configure the Fast Recovery Area.

  C. Configure the database in ARCHIVELOG mode.

  D. Create a normal restore point.

  E. Take a database backup.

  F. Create a guaranteed restore point.

  Correct Answer: ABC

• Question 169:

  Examine these actions:

  1.

  Log in to CDB$ROOT as a user with the SYSDBA privilege.

  2.

  Log in to the PDB as a user with the SYSKM privilege.

  3.

  Ensure that the CD keystore is open.

  4.

  Ensure that the CDB keystore is closed.

  5.

  Export the PDB key information.

  6.

  Export the CDB key information.

  7.

  Shut down the CDB.

  8.

  Shut down the PDB.

  9.

  Unplug the PDB.

  Which of these are required to unplug an encrypted PDB?

  A. 2, 3, 6, 8

  B. 2, 4, 5, 7

  C. l, 3, 5, 7, 9

  D. 1, 4, 5, 7, 9

  E. 1, 3, 5, 9

  F. 1, 3, 5, 8, 9

  Correct Answer: C

  Reference https://blog.dbi-services.com/unplug-an-encrypted-pdb-ora-46680-master-keys-of-thecontainer-database-must-be-exported/

• Question 170:

  Which two components are contained only in CDB$ROOT? (Choose two.)

  A. the unified audit trail

  B. database links between PDBs in the CDB

  C. PDB service names

  D. resource manager plans for each PDB in the CDB

  E. the default TEMP tablespace for the entire CDB

  Correct Answer: CE

  Reference https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268