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-931-23

Oracle 1z0-931-23 Exam Practice Questions (P. 1)

  • Full Access (87 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 vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?
  1. A
    Oracle Database Vault, Oracle Key Vault
  2. B
    Oracle Audit Vault, Oracle Key Vault
  3. C
    Oracle Cloud Infrastructure Vault, Oracle Database Vault
  4. D
    Oracle Key Vault, Oracle Cloud Infrastructure Vault

Correct Answer:
D

Question #2
Which two are ways Oracle Database can optimally access data in Object Storage? (Choose two.)
  1. A
    Scan avoidance using partitioned external tables
  2. B
    Optimized data archive using partitioned external tables
  3. C
    Optimized data archive using hybrid partitioned tables
  4. D
    Scan avoidance using columnar pruning for .csv files

Correct Answer:
AC

Question #3
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
  1. A
    It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
  2. B
    Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types.
  3. C
    Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority this scenario.
  4. D
    The application should be deployed on a Kubernetes Cluster because it needs to be highly available.

Correct Answer:
B

Question #4
Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?
  1. A
    You do not require sufficient access permissions on the compartment that the resource is being moved to.
  2. B
    Moving an Autonomous Database instance does not include its automatic backups.
  3. C
    Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.
  4. D
    Moving the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastructure.

Correct Answer:
C

Question #5
Which statement is true when the Autonomous Database has auto scaling enabled?
  1. A
    It scales the PGA and SGA size when needed for the workload.
  2. B
    Database concurrency is scaled up when needed by the workload.
  3. C
    It enables the database to use up to 3x OCPU/IO resources immediately when needed by the workload.
  4. D
    It increases the number of sessions available to the database.

Correct Answer:
C

Next Questions

All Pages