File Info
| Exam | Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP |
| Number | 1z0-034 |
| File Name | Oracle.1z0-034.PracticeTest.2018-02-12.148q.tqb |
| Size | 4 MB |
| Posted | Feb 12, 2018 |
| Download | Oracle.1z0-034.PracticeTest.2018-02-12.148q.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
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
- The MTTR advisor will be disabled.
- Automatic checkpoint tuning will be enabled.
- The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
- The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.
Correct answer: BC
Question 2
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
- DATE
- TIMESTAMP
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
- TIMESTAMP WITH LOCAL TIME ZONE
Correct answer: BE
Question 3
Which two statements are true regarding the functionality of the remap command in ASMCMD?
- It repairs blocks that have read disk I/O errors.
- It checks whether the alias metadata directory and the file directory are linked correctly.
- It repairs blocks by always reading them from the mirror copy and writing them to the original location.
- It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Correct answer: AD
