File Info
| Exam | Oracle Database 11g: Administration I |
| Number | 1z0-052 |
| File Name | Oracle.1z0-052.ExamLabs.2019-03-06.284q.tqb |
| Size | 9 MB |
| Posted | Mar 06, 2019 |
| Download | Oracle.1z0-052.ExamLabs.2019-03-06.284q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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
Question 2
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
- Large Pool
- Redo Log Buffer
- Database Buffer Cache
- Program Global Area (PGA)
Correct answer: A
Question 3
You executed the following command to create a tablespace called SALES_DATA:
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
