Free 1Z0-931-25 Exam Dumps PDF Preview

Question 1

Single choice

DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backups of this database periodically.

What must be the name of the bucket that will be used to store manual backups?

A
backup_proddb
B
BACKUP_PRODDB
C
backup_dbsrv1
D
BACKUP_DBSRV1

Reveal answer details Close answer details

Correct answerD

Question 2

Multiple choice

Which are the two restrictions for an Always Free Autonomous Database? (Choose two.)

A
Supports only ATP as a workload type
B
Maximum of two Always Free Databases per OCI tenancy
C
Oracle Application Express (APEX) not included
D
Maximum of one OCPU per Database

Reveal answer details Close answer details

Correct answersB, D

Question 3

Multiple choice

Which four file formats are supported when loading data from Cloud Storage?

A
DDL
B
AVRO
C
Parquet
D
DOC
E
JSON
F
CSV

Reveal answer details Close answer details

Correct answersB, C, E, F

Question 4

Single choice

An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database.
Other than changing the shared user password, what can an administrator do to protect the instance?

A
Trust the user who left not to access the database
B
Delete the user
C
Rotate the instance wallet and share the new wallet with the remaining users
D
Shutdown and restart the instance

Reveal answer details Close answer details

Correct answerC

Question 5

Single choice

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 any more 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
ATP using 'tpurgent' and 'high' TNS services to separate connection types
B
Since the application needs to be highly available, it should be deployed on a Kubernetes Cluster
C
It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
D
ADW since operational reporting is a higher priority in this scenario

Reveal answer details Close answer details

Correct answerA

Question 6

Single choice

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.

What should they do to remove this bottleneck?

A
Remove any non-JSON data from the database.
B
Ask Support to migrate their setup to a node without noisy neighbors.
C
Increase the number of OCPUs allocated to the database.
D
Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Reveal answer details Close answer details

Correct answerC

Question 7

Single choice

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

A
Data formats supported include: text, CSV, JSON, Avro, and Parquet
B
Data can be loaded from a local data source
C
Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud, and Oracle Object Storage
D
You must first manually create your database credentials
usingDBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket
E
Data can be loaded from a remote database using Database Links (DBLinks)

Reveal answer details Close answer details

Correct answerD

Question 8

Single choice

Which statement is FALSE about Oracle Autonomous JSON Database?

A
It supports NoSQL-style, document-centric applications.
B
There is a 20 GB limit on JSON collection.
C
JSON data is stored natively in the database.
D
You can promote Autonomous JSON Database to Autonomous Transaction Processing.

Reveal answer details Close answer details

Correct answerB

Question 9

Single choice

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
ORDS_ADMIN.GRANT_SCHEMA
B
ORDS_ADMIN.ENABLE_SCHEMA
C
ORDS_PRIV.ENABLE_SCHEMA
D
SQLDEV_ADMIN.GRANT_SCHEMA

Reveal answer details Close answer details

Correct answerB

Question 10

Single choice

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance.

What should you do?

A
Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'
B
Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
C
Add a 'BEFORE SHUTDOWN ON DATABASE' trigger within the database
D
Create a notification alert using DBMS_SNMP package

Reveal answer details Close answer details

Correct answerA

Question 11

Single choice

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='OLTP'
B
Allow group adb-admins to manage autonomous-database-family in tenancy
C
Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='DW'
D
Allow group adb-admins to manage autonomous-database in tenancy

Reveal answer details Close answer details

Correct answerB

Question 12

Multiple choice

Which three statements are true about procedures in the DBMS_CLOUD package?

A
The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
B
The DBMS_CLOUD.DELETE_FILE procedure removes the credential file from the Autonomous Data Warehouse.
C
The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores cloud object credentials in the Autonomous Data Warehouse.
D
The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE validates the source file for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a bad file table in Autonomous Data Warehouse.
E
The DBMS_CLOUD.PUT_OBJECT procedure copies a file from cloud object storage to the Autonomous Data Warehouse.

Reveal answer details Close answer details

Correct answersA, C, D

Question 13

Single choice

Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?

A
Moving an Autonomous Database instance does not include its automatic backups.
B
You do not require sufficient access permissions on the compartment that the resource is being moved to.
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.
D
Moving the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastructure.

Reveal answer details Close answer details

Correct answerC

Question 14

Single choice

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance?

A
The IP Protocol is set to TCP
B
The destination port range is set to 1522
C
A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance
D
The source is set to the address range you want to allow to connect to your database

Reveal answer details Close answer details

Correct answerC

Question 15

Single choice

Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production.

How should the customer unplug their database to migrate to an Autonomous Database?

A
Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.
B
PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.
C
Create a database link from the source database to the Autonomous Database environment and clone the PDB.
D
Unplug into a PDB archive, which can be uploaded to Object Storage.

Reveal answer details Close answer details

Correct answerB

Question 16

Single choice

What is the correct way to list all files in the default data pump directory?

A
By executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
B
You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW)
C
By executing SELECT * FROM UTL_FILE.LIST('DATA_PUMP_DIR');
D
Log onto ADW server and issue ls -al on the command line

Reveal answer details Close answer details

Correct answerA

Question 17

Single choice

You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and would like to explore the Autonomous Database tables using Autonomous Database's Data Tools.

Which step should you perform to enable the new team member?

A
Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role.
B
Create a database user with the default privileges.
C
Create a database user with connect, resource, and object privileges.
D
Create an IDCS user and create a database user with connect, resource, and object privileges.

Reveal answer details Close answer details

Correct answerA

Question 18

Single choice

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

A
Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database,
Autonomous Database
B
Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
C
Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator,
Database Administrator
D
Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

Reveal answer details Close answer details

Correct answerA

Question 19

Single choice

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version.

How can they achieve this?

A
Change the Automatic Maintenance Schedule to 'No Preference'
B
Change the Automatic Maintenance Schedule to 'None'
C
You cannot permanently disable scheduled Automatic Maintenance
D
Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week, or day

Reveal answer details Close answer details

Correct answerC

Question 20

Single choice

Which of the following is not required for connecting to Autonomous Database (ADB) via SQL Developer?

A
Password
B
Service
C
Username
D
Database name
E
Connection Name

Reveal answer details Close answer details

Correct answerE

Question 21

Multiple choice

Which of the following two statements regarding Data Transforms are correct? (Choose two.)

A
Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition
B
Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows
C
Workflows for Data Transforms are only available on the ODI Web Edition
D
All capabilities to transform data in ODI Classic are available with ODI Web Edition

Reveal answer details Close answer details

Correct answersB, D

Question 22

Single choice

Who, and in which order, provisions dedicated Exadata Infrastructure resources?

A
The Fleet Administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB and then, the Database Administrator provisions the Autonomous DB
B
The Database Administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the Fleet Administrator provisions the Autonomous Exadata Infrastructure
C
The Database Administrator provisions the Autonomous Exadata Infrastructure. Then, the Fleet Administrator provisions the Autonomous Container DB and then the Autonomous DB
D
The Fleet Administrator provisions the Autonomous Exadata Infrastructure. Then, the Database Administrator provisions the Autonomous Container DB and then the Autonomous DB

Reveal answer details Close answer details

Correct answerA

Question 23

Multiple choice

Which three functions are provided by Spatial Studio? (Choose three.)

A
Map visualization
B
Custom SQL queries
C
Spatial analysis
D
Geocoding
E
Spatial data editing

Reveal answer details Close answer details

Correct answersA, C, E

Free 1Z0-931-25 Exam Dumps Preview

Oracle Autonomous Database Cloud 2025 Professional

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20

QUESTION 21

QUESTION 22

QUESTION 23

VOL	TYPE	QUESTIONS
1	Single choice	18
2	Multiple choice	5