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

Oracle 1z0-083 Exam Practice Questions (P. 5)

  • Full Access (181 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 #21
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?
  1. A
    V$SESSION_EVENT
  2. B
    V$SESSTAT
  3. C
    V$SESSION_WAIT
  4. D
    V$SESSION_WAIT_CLASS
  5. E
    V$SESSION

Correct Answer:
D
Reference:
https://docs.oracle.com/cd/E29597_01/server.1111/e16638/instance_tune.htm

Question #22
Which two are true about gathering optimizer statistics? (Choose two.)
  1. A
    Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
  2. B
    Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
  3. C
    Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
  4. D
    System statistics can be gathered only while connected to CDB$ROOT.
  5. E
    Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Correct Answer:
CE
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html

Question #23
Examine this output:

Which two are true? (Choose two.)
  1. A
    Any PDB not specified in the plan will be unable to execute statements in parallel.
  2. B
    PDB3 can use all available parallel execution processes at times.
  3. C
    PDB1 is always limited to 40% of the available system resources regardless of demand.
  4. D
    Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
  5. E
    PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
  6. F
    PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Correct Answer:
AE

Question #24
Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
  1. A
    orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
  2. B
    root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
  3. C
    The sudo password can be specified in a response file.
  4. D
    root.sh can be executed automatically by the Database installer only by using sudo credentials.
  5. E
    The sudo password must be specified in a response file.
  6. F
    The root password cannot be specified in a response file.

Correct Answer:
AF
chatbot-img GPT-4o - Answer
The correct understanding around executing OS scripts from Oracle Database 19c revolves around automation options and security practices. The script orainstRoot.sh can be automated by Oracle Universal Installer (OUI) using either sudo or root credentials, which caters to various system administration policies. Additionally, it’s crucial to note that specifying root or sudo passwords directly in a response file isn't allowed, enhancing security by requiring these sensitive credentials be supplied at runtime. This ensures that root passwords remain protected and are not exposed in configuration files.

Question #25
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?
  1. A
    Run the SQL Access Advisor.
  2. B
    Run the Memory Advisor for the shared pool.
  3. C
    Run the SQL Tuning Advisor.
  4. D
    Run the Memory Advisor for the Program Global Area.
  5. E
    Run the Memory Advisor for the System Global Area.

Correct Answer:
B
chatbot-img GPT-4o - Answer
The Memory Advisor for the shared pool is indeed the appropriate tool to address excessive hard parse activity that degrades performance. This advisor helps analyze and recommend optimal sizes for the shared pool, directly impacting how SQL statements are parsed and managed. When Automatic Shared Memory Management is disabled, focusing specifically on the shared pool to manage parse-related memory issues becomes crucial as manually adjusting memory allocations can directly improve parsing performance and reduce latch contention. Thus, using the Memory Advisor for the shared pool is a targeted action to mitigate the observed issue.

Previous Questions Next Questions

All Pages