[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 461-470

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 461 – (Topic 13)

Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

  1. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.

  2. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.

  3. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

  4. Health Monitor checks are always initiated manually when there is some critical error.

Answer: A,B

Topic 14, Managing Memory

Question No: 462 – (Topic 14)

Observe the structure of the table employees: The table contains 8475 records.

Ensurepass 2018 PDF and VCE

One of the employees wants to know the names of all employees of the company. For this, he fires the following query:

SELECT * FROM EMPLOYEES ORDER BY emp_fname;

Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.

Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?

  1. Rollback segment

  2. Temporary segment

  3. Data segment

  4. Index segment

Answer: B

Question No: 463 – (Topic 14)

Examine the parameter setting in your database:

Ensurepass 2018 PDF and VCE

Which statement is correct about the database?

  1. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

  2. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

  3. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

  4. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

Answer: D

Question No: 464 – (Topic 14)

Which statement about Automatic Memory Management with Oracle 11g is true?

  1. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

  2. Oracle can reallocate memory between the SGA and PGA automatically as needed.

  3. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

  4. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

Answer: B

Question No: 465 – (Topic 14)

View the Exhibit.

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.

Which background process performs this activity?

Ensurepass 2018 PDF and VCE

  1. CKPT

  2. SMON

  3. MMON

  4. DBWR

Answer: C

Question No: 466 – (Topic 14)

Evaluate the following function code:

Ensurepass 2018 PDF and VCE

Which statement is true regarding the above function?

  1. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

  2. If the function execution results in an unhandled exception, the exception result is also stored in the cache.

  3. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.

  4. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.

Answer: A

Question No: 467 – (Topic 14)

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

  1. MMON

  2. LGWR

  3. ARCH

  4. ARWR

  5. COPY

Answer: C

Question No: 468 – (Topic 14)

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

  1. Automatic PGA Memory Management

  2. Automatic SGA Memory Management

  3. Automatic Shared Memory Management

  4. Automatic Memory Management

  5. Manual SGA Memory Management

  6. None of the above

Answer: C

Question No: 469 – (Topic 14)

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?

  1. Set MEMORY_TARGET to zero

  2. Set the STATISTICS_LEVEL parameter to BASIC

  3. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

  4. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

Answer: D

Question No: 470 – (Topic 14)

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)

  1. DB_CACHE_SIZE

  2. SHARED_POOL_SIZE

  3. LARGE_POOL_SIZE

  4. JAVA_POOL_SIZE

  5. SGA_MAX_SIZE

  6. SORT_AREA_SIZE

Answer: A,B

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *