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

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

  • Full Access (192 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 observed that some of the queries are performing poorly on the SALES_RECORDS table in your database.
On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table are transferred to the SALES table and deleted from the
SALES_RECORDS table. The deleted operations cause the table to be sparsely populated. You decided to use the ALTER TABLE...SHRINK SPACE COMPACT command to shrink the table. Why would you choose this method? (Choose all that apply.)
  1. A
    because it can be used during peak hours
  2. B
    because it avoids unnecessary cursor invalidation
  3. C
    because it adjusts the high-water mark (HWM) immediately
  4. D
    because you have long-running queries that might span the shrink operation
  5. E
    because it does not allow any data manipulation language (DML) operations, thereby making the shrink operation faster

Correct Answer:
ABD

Question #7
View the Exhibit and examine a portion of the output obtained from the following query:

SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)
  1. A
    DB time includes the wait time of all the nonidle and idle user sessions.
  2. B
    SQL execute elapsed time includes the time spent in performing fetches of query results.
  3. C
    DB CPU includes the CPU time spent on database user-level calls and background CPU time.
  4. D
    SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.
  5. E
    DB time includes the connection management call elapsed time excluding the background process time.

Correct Answer:
BDE

Question #8
A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at
2 AM. To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to execute the awrddrpt.sql script to produce a
Compare Periods report. Which two statements are true about the report produced by this script? (Choose two.)
  1. A
    It is refreshed automatically based on the moving window baseline.
  2. B
    It compares details between any two selected time periods of the same duration.
  3. C
    It normalizes the statistics by the amount of time spent on the database for each time period.
  4. D
    It compares details between two consecutive time periods of the same or different durations and is refreshed every 60 minutes.

Correct Answer:
BC

Question #9
You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase the window size of the default moving window baseline for all metric observations and comparisons in your database. The following error occurs when you try to increase the window size through Enterprise Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention (1036800) ORA-06512: at
"SYS.DBMS_WORKLOAD_REPOSITORY", line 601 ORA-06512: at line 2 Which action would allow you to perform the preceding task successfully?
  1. A
    increasing the flashback retention period
  2. B
    increasing the retention period for SQL Management Base
  3. C
    increasing the undo retention period for the database instance
  4. D
    increasing the Automatic Workload Repository (AWR) retention period

Correct Answer:
D

Question #10
Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
  1. A
    A part of SGA memory is used to store ASH data as rolling buffer.
  2. B
    The ASH data can be analyzed between any two small time intervals.
  3. C
    All ASH data in memory are flushed to disk by MMON in every 3 seconds.
  4. D
    All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

Correct Answer:
AB

Previous Questions Next Questions

All Pages