ExamTopics Logo
Mail Us[email protected]
Menu
 

1z0-034 Actual Exam Questions

Last updated on Dec. 5, 2024.
Vendor:Oracle
Exam Code:1z0-034
Exam Name:Upgrade Oracle9i10g OCA to Oracle Database 11g OCP
Exam Questions:148
97% Passed the exam with this material
 

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 Hide 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 Hide 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 Hide 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 Hide Solution   Discussion  

Correct Answer: C 🗳️

file Viewing page 1 out of 37 pages.
Viewing questions 1-4 out of 148 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago