Download Oracle.1z0-052.PracticeTest.2018-04-09.284q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-052 |
| Exam Name: | Oracle Database 11g: Administration I |
| Date: | Apr 09, 2018 |
| File Size: | 8 MB |
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
