[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 301-310

Get Full Version of the Exam

Question No.301

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

  1. Archived redo log files that have multiple copies in a different archive location

  2. user-managed backups of data files and control files

  3. RMAN backups that are obsolete

  4. flashback logs

Correct Answer: CD

Question No.302

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

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

  2. Consumer groups are associated with windows

  3. Windows work with job classes to control resource allocation

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

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

Correct Answer: ACE

Question No.303

Identify three uses of the CROSSCHECK command? (Choose three.)

  1. to validate the database backup

  2. to synchronize logical backup records with physical files in backup storage

  3. to check the obsolete backups that can be deleted from the file system

  4. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file

  5. to update the recovery catalog or control file if archived log files are deleted with operating system commands

Correct Answer: BDE

Question No.304

Examine the following command:

SQLgt; DBMS_STATS. SET_TABLE_PREFS (#39;SH#39;, #39;CUSTOMERS#39;, #39;PUBLISH#39;, #39;false#39;);

What is the effect of executing this command?

  1. Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

  2. Automatic statistics collection is stopped for the CUSTOMERS table.

  3. Statistics for the CUSTOMERS table are locked and cannot be overwritten.

  4. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.

Correct Answer: D

Question No.305

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

  1. The ability of users to audit their own schema objects is not available in the post-migrated database.

  2. Operating system audit trail is available in the post-migrated database.

  3. Network auditing is available in the post-migrated database.

  4. Mandatory auditing of audit administrative actions is available in the post-migrated database.

Correct Answer: AD



Question No.306

When does a database checkpoint occur?

  1. When there is an online redo log switch.

  2. When a user session terminates abnormally.

  3. When a server process terminates abnormally.

  4. When the SHUTDOWN ABORT command is issued.

Correct Answer: A

Question No.307

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

  1. You cannot specify how partitioned tables should be handled during an import operation.

  2. Only data can be compressed during an export operation.

  3. Existing dump files can be overwritten during an export operation.

  4. Tables cannot be renamed during an import operation.

  5. Metadata that is exported and imported can be filtered based on objects and object types.

Correct Answer: AE



Question No.308

You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has

Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

  1. Oracle CSSD services

  2. the database whose instance is running

  3. Oracle Notification services

  4. Oracle Healthcheck services

  5. Oracle Net Listener

Correct Answer: AC

Question No.309

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

  1. It mounts databases and diskgroups to make ASM files available to database instances.

  2. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.

  3. It automatically places each disk from an external redundancy diskgroup in its own failure group.

  4. It divides files into extents and allows an extent to span disks.

  5. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

Correct Answer: BC

Question No.310

You want to create a database with a block size other than the default 8 kilobytes (KB) by using the Database Configuration Assistant (DBCA). Which option should you use?

  1. Automatic Storage Management (ASM) for storage of data files

  2. a file system for storage of data files

  3. a Data Warehouse database template

  4. a custom database template

Correct Answer: D

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF