Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-931-23 by Oracle - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 56

1 2 3

→

Know a question that should be here? Contribute to this exam

Which two options are available for restoring an Autonomous Database? (Choose two.)

A Selecting the snapshot of the backup.
B Specifying the archived custom image.
C Using Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
D Selecting the backup from which restore needs to be done.
E Specifying the point in time (timestamp) to restore.

Which two of the following data sources are available when using the Data Load page on Database Actions? (Choose two.)

A Backup files in block storage
B REST endpoints
C Local Files
D Files in Oracle Cloud Storage

Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database? (Choose two.)

A Active Data Guard
B Exadata
C Multitenant
D Transparent Data Encryption (TDE)
E Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs

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

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 source is set to the address range you want to allow to connect to your database.
C A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.
D The destination port range is set to 1522.

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.)

A Memory Usage
B Backup Retention
C Undo Management
D Data Organization

Which statement is FALSE about Data Insights?

A Data Insights provides a wide range of graphical data presentation capabilities.
B Data insights are automatically generated by various analytic functions built into the database.
C The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard.
D Data Insights displays information about patterns and anomalies in the data of entities in your Oracle Autonomous Database.

Which four resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user? (Choose four.)

A Oracle Database licenses
B Identity and Access Management (IAM) policy rules that allow access to the database
C Autonomous Database instance
D Network Security Group(s)
E Autonomous Exadata Infrastructure
F Autonomous Container Database

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure? (Choose three.)

A Enterprise Manager Cloud Control
B RMAN
C Logs
D OCI Metrics
E Performance Hub

Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?

A Oracle Database Vault, Oracle Key Vault
B Oracle Audit Vault, Oracle Key Vault
C Oracle Cloud Infrastructure Vault, Oracle Database Vault
D Oracle Key Vault, Oracle Cloud Infrastructure Vault

Which two are ways Oracle Database can optimally access data in Object Storage? (Choose two.)

A Scan avoidance using partitioned external tables
B Optimized data archive using partitioned external tables
C Optimized data archive using hybrid partitioned tables
D Scan avoidance using columnar pruning for .csv files

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?

A It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
B Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types.
C Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority this scenario.
D The application should be deployed on a Kubernetes Cluster because it needs to be highly available.