Vendor: Oracle
Exam Code: 1Z0-052 dumps
Exam Name: Oracle Database 11g: Administrator I
Version: Demo
Question No : 1
You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)
A. Disable automatic checkpoint tuning
B. Check the size of the redo log file size and increase the size if it is small
C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group
Answer: B,C
Question No : 2
Identify the memory component from which memory may be 1z0-052 allocated for: Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)
Answer: A
Question No : 3
You executed the following command to 1z0-052 pdf create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
