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 3

Question No : 31) A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python?

A. SQL Developer

B. JAVA JDK

C. You can't use Python with ADB.

D. The Oracle Client and the cx_Oracle interface for Python


Question No : 32) Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

A. When you restore a database, the existing ACLs are not overwritten by the restore.

B. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

C. ACLs can only be used with private endpoints.

D. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.


Question No : 33) Which two are correct actions to take in order to Download the Autonomous Database Credentials?

A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.

B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.

C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).


Question No : 34) Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this?

A. Change the Automatic Maintenance Schedule to 'None’d.

B. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.

C. You cannot permanently disable scheduled Automatic Maintenance.

D. Change the Automatic Maintenance Schedule to 'No Preference'.


Question No : 35) Which three event types are supported for Autonomous Database?

A. Terminate End

B. Maintenance Begin

C. Change Compartment Begin

D. Change Autoscaling Configuration Compartment

E. Update IORM Begin


Question No : 36) 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?

A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.

B. ADW since operational reporting is a higher priority in this scenario.

C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.


Question No : 37) Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

A. Use SFTP to copy CSV files into Autonomous Database

B. Use Oracle Zero Downtime Migration (ZDM)

C. Use Recovery Manager (RMAN)

D. Use GoldenGate

E. Use Data Pump


Question No : 38) Which native data type is used to store spatial information?

A. SDO_RELATE

B. SDO_GEOMETRY

C. SDO_LOCATION

D. GEO_JSON


Question No : 39) Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

A. Transparent Data Encryption

B. Database Vault

C. Customer Managed Keys

D. Data Redaction

E. Audit Vault


Question No : 40) Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

A. Network Security Group

B. Security List

C. VCN

D. Route Table

E. Subnet


Question No : 41) Which statement is true when the Autonomous Database has auto scaling enabled?

A. Database concurrency is scaled up when needed by the workload.

B. Increases the number of sessions available to the database.

C. Scales the PGA and SGA size when needed for the workload.

D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.


Question No : 42) Which statement is not correct when the Autonomous Database is stopped?

A. In-flight transactions queries are stopped

B. Tools are no longer able to connect to a stopped instance

C. User with DWROLE can still access the database

D. CPU billing is halted


Question No : 43) When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

A. 2 hours

B. 30 minutes

C. 1 hours

D. 24 hours


Question No : 44) Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

A. through the Oracle Cloud Infrastructure service console

B. through SQL/Developer s

C. using DBMS_CLOUD_ADMIN package

D. through SQLPIus


Question No : 45) Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

A. RMAN Cross-Platform backup and restore

B. Golden Gate on-premise installation

C. PDB unplug / plug operation

D. Datapump export / import

E. Dataguard Physical Standby

F. Golden Gate Cloud service

 

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.