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

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.231

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

image

What happens when the FAILGRP1 failure group is corrupted?

  1. Mirroring of allocation units occurs within the FAILGRP2 failure group.

  2. Transactions that are using the diskgroup fail.

  3. ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.

  4. Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.

Correct Answer: D

Question No.232

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance. Which tool would you use to get advice on how to improve performance?

  1. Memory Advisor for the PGA

  2. SQL Access Advisor

  3. Memory Advisor for the shared pool

  4. SQL Tuning Advisor

Correct Answer: C

Explanation:

http://docs.oracle.com/cd/E25178_01/server.1111/e10897/montune.htm#CHDGFCFJ

Question No.233

Backup requirements for a database:

image

Level 0 backup on Sunday

image

image

Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday Differential incremental level 1 backup on Tuesday, Thursday, and Friday

Which three statements are true about the strategy? (Choose three.)

  1. Level 0 backup on Sunday contains all the blocks that have been formatted.

  2. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.

  3. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.

  4. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.

  5. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed

since the last level 0 backup.

Correct Answer: ACD

Question No.234

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  1. It calls SQL advisors automatically if required.

  2. It provides recommendations only for poorly performing SQL statements.

  3. Its results are stored in AWR.

  4. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.

  5. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

Correct Answer: CE

Question No.235

Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the following command:

SQLgt; ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

  1. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

  2. It fails because DB_CACHE_SIZE is a static initialization parameter.

  3. It fails because ASMM is enabled and individual SGA components cannot be sized.

  4. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.

Correct Answer: A

Question No.236

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

  1. Backup retention policy

  2. Default backup device type

  3. Default destinations for backups

  4. Multiple backup device types for single backup

  5. Default section size for backups

Correct Answer: ABC

Explanation:

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

Question No.237

You executed the following query:

SELECT oldest_flashback_scn, oldest_flashback_time

FROM V$FLASHBACK_DATABASE_LOG;

Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

  1. The time when the last flashback operation in your database was performed

  2. The time when the first flashback operation in our database was performed

  3. The approximate time and the lowest system change number (SCN) to which you can flash back your database

  4. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

Correct Answer: C

Question No.238

What is a requirement for creating a remote database scheduler job?

  1. The remote database job must run as a user that is valid on the target remote database.

  2. A private database link must be created from the originating database to the target remote database.

  3. The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later.

  4. The target remote database must be on a different host form the originating scheduler database host.

Correct Answer: A

Question No.239

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

  1. An SPFILE can be created from a PFILE or from memory.

  2. A PFILE can be used to start up a database instance even if an SPFILE exists.

  3. An SPFILE must reside in the ORACLE_HOME/dbs directory.

  4. An SPFILE can be created only before a database instance is started.

  5. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.

Correct Answer: AB

Question No.240

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

  1. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)

  2. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

  3. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM

  4. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

Correct Answer: D

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

Leave a Reply