Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 71:

  To enable faster incremental backups, you enabled block change tracking for the database.

  Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.

  B. The change tracking file must be created after the first level 0 backup.

  C. RMAN does not support backup and recovery of the change tracking file.

  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

  Correct Answer: CD

• Question 72:

  Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

  A. Backup retention policy

  B. Default backup device type

  C. Default destinations for backups

  D. Multiple backup device types for single backup

  E. Default section size for backups

  Correct Answer: ABC

  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV89399

• Question 73:

  Which three statements are true about windows? (Choose three.)

  A. Only one window can be open at any given time

  B. Consumer groups are associated with windows

  C. Windows work with job classes to control resource allocation

  D. The database service name must be provided during windows creation

  E. Windows can automatically start job or change resource allocation among jobs for various time periods

  Correct Answer: ACE

• Question 74:

  Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

  A. It clears all user recycle bins in a database and releases their storage space.

  B. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table.

  C. It evaluates the dependencies of network utility packages.

  D. It identifies any deprecated and unsupported parameters.

  E. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.

  Correct Answer: BCD

• Question 75:

  Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

  A. Put all readonly tablespaces in read write mode

  B. Recompile all invalid objects

  C. Set the compatible parameter to 12.1.0.1

  D. Gather dictionary statistics

  E. Empty all user recycle bins

  Correct Answer: BE

• Question 76:

  Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

  A. An Oracle database instance can support only one DBaaS instance.

  B. A DBaaS instance can support only one Oracle database instance.

  C. An Oracle database instance can support multiple DBaaS instances.

  D. A DBaaS instance can support multiple Oracle database instances.

  E. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).

  Correct Answer: D

• Question 77:

  Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

  A. PMON

  B. SMON

  C. MMNL

  D. MMAN

  E. MMON

  Correct Answer: D

• Question 78:

  You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?

  A. RBAL

  B. CKPT

  C. SMON

  D. PMON

  E. MMON

  F. CTWR

  G. DBWR

  Correct Answer: F

• Question 79:

  You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

  A. backup pieces

  B. copies of all parameter files

  C. trace file generated using BACKUP CONTROLFILE TO TRACE

  D. control file autobackups

  Correct Answer: AD

• Question 80:

  Examine the following ALTER command:

  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

  What is the purpose of the command?

  A. It cancels all pending disk drops within the disk group

  B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

  C. It mounts disks in the disk group for which the drop-disk operation has already been completed

  D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed

  E. It adds previously dropped disks back into the disk group

  Correct Answer: A