Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-034

Oracle 1z0-034 Exam Practice Questions (P. 1)

  • Full Access (148 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
  1. A
    The MTTR advisor will be disabled.
  2. B
    Automatic checkpoint tuning will be enabled.
  3. C
    The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
  4. 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

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?
  1. A
    DATE
  2. B
    TIMESTAMP
  3. C
    INTERVAL YEAR TO MONTH
  4. D
    INTERVAL DAY TO SECOND
  5. E
    TIMESTAMP WITH LOCAL TIME ZONE

Correct Answer:
BE

Question #3
Which two statements are true regarding the functionality of the remap command in ASMCMD?
  1. A
    It repairs blocks that have read disk I/O errors.
  2. B
    It checks whether the alias metadata directory and the file directory are linked correctly.
  3. C
    It repairs blocks by always reading them from the mirror copy and writing them to the original location.
  4. 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

Correct Answer:
AD

Question #4
What happens when you run the SQL Tuning Advisor with limited scope?
  1. A
    Access path analysis is not performed for SQL statements.
  2. B
    SQL structure analysis is not performed for SQL statements.
  3. C
    SQL Profile recommendations are not generated for SQL statements.
  4. D
    Staleness and absence of statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

Correct Answer:
C

Question #5
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in
ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)
  1. A
    setting the FAST_START_MTTR_TARGET to set the mean time to recover
  2. B
    setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
  3. C
    using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
  4. D
    using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.

Correct Answer:
CD

Next Questions

All Pages