Logo
  • Home
  • All Courses
    • Amazon - AWS
    • Cisco
    • CompTIA
    • EC Council
    • Microsoft
    • Oracle
    • Salesforce
    • Snowflake
  • Testimonials
  • Blogs
  • Login
  • Register
  • Cart

Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 4

Question No : 46) Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

A. Parallelism is not enabled by default.

B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

C. Oracle Database Result Cache is enabled by default for all SQL statements.

D. You have direct access to the database node.


Question No : 47) What REST verb is used to create an Autonomous Database service using REST APIs?

A. An "INSERT" REST call

B. A "GET" REST call

C. A "POST" REST call

D. A "PUT" REST call


Question No : 48) Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

A. TPPERFORMANT

B. MEDIUM

C. HIGH

D. LOW

E. TPURGENT


Question No : 49) Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

A. Backup and recovery must be done using Recovery Manager(RMAN).

B. Select the snapshot of the backup.

C. Select the archived redo logs.

D. Select the backup from which restore needs to be done.

E. Specify the point in time (timestamp) to restore.


Question No : 50) While creating a business model what advanced options you can enable or disable? (Choose three)

A. Business Object Security Feature

B. Analytic View Transparency View

C. Autonomous Aggregate Cache

D. Display private tables

E. Analytic View Base Table Query Transformation


Question No : 51) You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:

• Autonomous Transaction Processing

• License Included

• Shared Infrastructure

Which parameter would you NOT use?

A. db-workload

B. is-dedicated

C. db-type

D. license-model


Question No : 52) Which three of the following data sources are available when using the Data Load page on Database Actions?

A. Files in Oracle Cloud Storage

B. Backup files in block storage

C. Local Files

D. Files in AWS S3 Storage

E. REST endpoints


Question No : 53) When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

A. Under Core Infrastructure then Compute then Autonomous Exadata

B. Under Solutions and Platform then Platform Services then Autonomous Exadata

C. Under Database then Autonomous Transaction Processing then Autonomous Exadata

D. Under Core Infrastructure then Autonomous Exadata


Question No : 54) You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

A. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database

B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"

C. Create a notification alert using DBMS_SNMP package

D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric


Question No : 55) Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

A. inside the Autonomous Database wallet

B. inside the backups of the container database

C. In a separate key vault external to the Exadata Infrastructure

D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted


Question No : 56) Which statement is FALSE about Oracle Data Safe?

A. It supports only Autonomous Databases.

B. It helps you assess the security of your cloud database configurations by analyzing database configurations.

C. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.

D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.

E. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.


Question No : 57) For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

A. SQLDEV_ADMIN.GRANT_SCHEMA

B. ORDS_ADMIN.ENABLE_SCHEMA

C. ORDS_ADMIN.GRANT_SCHEMA

D. ORDS_PRIV.ENABLE_SCHEMA


Question No : 58) Which statement is NOT correct when setting up compartment quotas?

A. There are three types of quota policy statements which are set, unset and zero.

B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

D. Compartment quotas are set by Oracle.


Question No : 59) Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

A. Admin page of the Cloud Service Console

B. OCI CLI

C. OS command line from the database server.

D. SQLDeveloper


Question No : 60) For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

B. Allow group ADB-Admins to manage autonomous-database in tenancy.

C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

 

1z0-931-24 Answers

 

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

Logo

Our goal is to help students clear their exam by providing them genuine questions which helps students to achieve their goal. Many students have cleared their exam by going through our courses. Are you ready to clear yours?


Site Secured

mcaafe-secure

Last Scanned: 08-05-2025

Links

  • FAQ
  • Money Back Guarantee
  • About Us
  • Privacy Policy
  • Terms & Conditions
  • Contact Us
  • Testimonials

Disclaimer

  • SAP, Microsoft, Google, Amazon, Qualtrics, and all other brands are Registered Trademarks of their respective companies.
  • Theexamquestions.com is no way affiliated With any brand hosted on this website.
  • Theexamquestions.com offers only probable exam questions and answers.
  • Theexamquestions.com offer learning materials and practice tests created by subject matter technology experts to assist and help learners prepare for those exams. Theexamquestions.com do not offer dumps or questions from the actual exam.
  • Theexamquestions.com does not own or claim any ownership on any of the brands.
  • All Certification Brands used on the website are owned by the respective brand owners.

All course contents, trademarks, service marks, trade names, product names and logos appearing on the site are the property of their respective owners. The website Theexamquestions.com is in no way affiliated with any of the certification providers. Copyright © 2025 www.theexamquestions.com. All rights reserved.