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

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

  • Full Access (60 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
Which two statements are true about using an Autonomous Database with Private Endpoints? (Choose two.)
  1. A
    Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
  2. B
    You can configure Private Endpoints for an Always Free Autonomous Database.
  3. C
    A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.
  4. D
    An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

Correct Answer:
CD

Question #22
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
  1. A
    The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
  2. B
    The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
  3. C
    The target table will be created in Autonomous Database if it does not already exist.
  4. D
    The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
  5. E
    A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

Correct Answer:
BE

Question #23
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? (Choose the best answer.)
  1. A
    Execute alter tablespace DATA set quota = 10G;
  2. B
    Execute alter tablespace for user MTHEO tablespace DATA quota = 10G;
  3. C
    Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO',tablespace_quota => 'UNLIMITED');
  4. D
    Execute alter user MTHEO quota unlimited on tablespace DATA;

Correct Answer:
C

Question #24
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 non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA
Manager does not want to add anymore admin responsibility to the team and is 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? (Choose the best answer.)
  1. A
    Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
  2. B
    ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
  3. C
    It is best to build a Separate data warehouse, and move the OLTP data on a nightly basis.
  4. D
    ADW since operational reporting is a higher priority in this scenario.

Correct Answer:
B

Question #25
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance? (Choose the best answer.)
  1. A
    Delete the user.
  2. B
    Rotate the instance wallet and share the new wallet with the remaining users.
  3. C
    Shutdown and restart the instance.
  4. D
    Trust the user who left to not access the database.

Correct Answer:
B

Previous Questions Next Questions

All Pages