Oracle 1z0-034 Exam Actual Questions

The questions for 1z0-034 were last updated on Nov. 12, 2024.

Viewing page 1 out of 37 pages.
Viewing questions 1-4 out of 148 questions

Topic 1 - Single Topic

Question #1 Topic 1

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

A. The MTTR advisor will be disabled.
B. Automatic checkpoint tuning will be enabled.
C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
D. 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

Reveal Solution Discussion 1

Correct Answer: BC 🗳️

Question #2 Topic 1

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?

A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE

Reveal Solution Discussion

Correct Answer: BE 🗳️

Question #3 Topic 1

Which two statements are true regarding the functionality of the remap command in ASMCMD?

A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. 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

Reveal Solution Discussion

Correct Answer: AD 🗳️

Question #4 Topic 1

What happens when you run the SQL Tuning Advisor with limited scope?

A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

Reveal Solution Discussion

Correct Answer: C 🗳️