Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 101:

  You are administering a multitenant container database (CDB) that contains multiple pluggable databases

  (PDBs). You are connected to cdb$root as the sys user. You execute the commands:

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

  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 statement is true about the c##connect role?

  A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

  B. It is granted to the c##admin user only in the CDB.

  C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

  D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

  Correct Answer: D

• Question 102:

  Examine the RMAN command:

  RMAN> BACKUP VALIDATE DATABASE; Which statement is true about the execution of the command?

  A. Block change tracking must be enabled before executing this command.

  B. The database must be running in archivelog mode for the successful execution of this command.

  C. A complete database backup must exist before executing this command.

  D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

  E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

  Correct Answer: D

• Question 103:

  Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)

  A. A base recovery catalog should exist.

  B. The owner of VPC cannot own recovery catalog.

  C. At least one target database should be registered in the recovery catalog.

  D. The register database privilege should be granted to the virtual catalog owner.

  E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

  Correct Answer: ADE

• Question 104:

  Which two statements are true regarding SecureFile lobs? (Choose two.)

  A. The amount of undo retained is user controlled.

  B. They can be used only for nonpartitioned tables.

  C. Fragmentation is minimized by using variable-sized chunks.

  D. They support random reads and writes of encrypted LOB data.

  Correct Answer: CD

  Reference: http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46113

• Question 105:

  Which three statements are true about compression of backup sets? (Choose three.)

  A. Compressed backups can only be written to media.

  B. Binary compression creates performance overhead during a backup operation.

  C. Unused blocks below the high-water mark are not backed up.

  D. Compressed backups cannot have section size defined during a backup operation

  E. It works only for locally managed tablespaces.

  Correct Answer: BCE

• Question 106:

  You create two Resource Manager plans, one for night time workloads, the other for day time.

  How would you make the plans switch automatically?

  A. Use job classes.

  B. Use scheduler windows.

  C. Use the mapping rule for the consumer groups.

  D. Set the switch_time plan directive for both plans.

  E. Use scheduler schedules.

  Correct Answer: B

• Question 107:

  Which two statements are true about Flashback Version Query? (Choose two.)

  A. The result of a query can be used as part of a DML statement.

  B. It can be used to create views.

  C. It can be used only if Flashback Data Archive is enabled for a table.

  D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

  E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

  Correct Answer: DE

• Question 108:

  Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

  A. The PDB must be open in read only mode.

  B. The PDB must be dosed.

  C. The unplugged PDB becomes a non-CDB.

  D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

  E. The unplugged PDB can be plugged into another CDB.

  F. The PDB data files are automatically removed from disk.

  Correct Answer: BDE

  B (not A): The PDB must be closed before unplugging it.

  D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference. E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place. Reference: Oracle White Paper, Oracle Multitenant

• Question 109:

  You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

  Which method or feature should you use?

  A. Compare Period ADDM report

  B. AWR Compare Period report

  C. Active Session History (ASH) report

  D. Taking a new snapshot and comparing it with a preserved snapshot

  Correct Answer: B

  The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin directory.

  Incorrect Answers:

  A: Compare Period ADDM is used to perform a high-level comparison of one workload replay to its capture or to another replay of the same capture. Only workload replays that contain at least 5 minutes of database time can be compared using this report.

• Question 110:

  Which parameter must be set to which value to implement 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.

  Correct Answer: C

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11233