Download Oracle Database 11g: Administration I.1z0-052.PracticeTest.2018-01-05.215q.tqb

Vendor:	Oracle
Exam Code:	1z0-052
Exam Name:	Oracle Database 11g: Administration I
Date:	Jan 05, 2018
File Size:	7 MB

Download Exam

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

You notice that the performance of the database has degraded because of frequent checkpoints.

Which two actions resolve the issue? (Choose two.)

Disable automatic checkpoint tuning
Check the size of the redo log file size and increase the size if it is small
Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
Decrease the number of redo log members if there are more than one redo log members available in each redo log group

Correct answer: BC

Identify the memory component from which memory may be allocated for:

Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

Correct answer: A

You executed the following command to create a tablespace called SALES_DATA:

SQL> CREATE TABLESPACE sales_data

DATAFILE SIZE 100M

SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two)

The database automatically determines the extent-sizing policy for the tablespace.
The segments are automatically shrunk when the contents are removed from them.
The allocation of extents within the tablespace is managed through the dictionary tables.
The space utilization description of the data blocks in segments is recorded in bitmap blocks.
The space utilization description of the data blocks in segments is managed through free lists.

Correct answer: AD

CONNECT US

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset