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-052

Oracle 1z0-052 Exam Practice Questions (P. 2)

  • Full Access (284 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 #6
You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?
  1. A
    ORACLE_HOME/dbs
  2. B
    ORACEL_HOME/rdbms
  3. C
    /u01/app/oracle/admin/orcl/adump
  4. D
    /u01/app/oracle/flash_recovery_area
  5. E
    ORACLE_BASE/diag/rdbms/orcl/alert
  6. F
    ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Correct Answer:
F

Question #7
See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)
  1. A
    A bitmap is used to record free extents
  2. B
    Free extents information is managed within the tablespace
  3. C
    Free extents information is managed in the SYSAUX tablespace
  4. D
    The data dictionary tables are updated when extents are allocated or deallocated

Correct Answer:
AB

Question #8
Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0 -

LOG_CHECKPOINT_INTERVAL=0 -
Which two will be the implications of these values in your database? (Choose two.)
  1. A
    The SGA advisor will be disabled
  2. B
    The MTTR advisor will be disabled
  3. C
    Automatic checkpoint tuning will be disabled
  4. D
    Checkpoint information will not be written to the alert log file

Correct Answer:
BC

Question #9
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?
  1. A
    Optimizer statistics are collected automatically.
  2. B
    Only timed operating system (OS) statistics and plan execution statistics are collected.
  3. C
    The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
  4. D
    Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
  5. E
    The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

Correct Answer:
C

Question #10
You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.
Which action would help to use the previous set of statistics on the objects?
  1. A
    Restore statistics from statistics history.
  2. B
    Reduce the optimizer statistics retention period by 2 days.
  3. C
    Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
  4. D
    Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

Correct Answer:
A

Previous Questions Next Questions

All Pages