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-20 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
(Choose three.)

A Security List
B Route Table
C Subnet
D VCN
E Network Security Group

Question 4

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

A Select the snapshot of the backup.
B Select the backup from which restore needs to be done.
C Backup and recovery must be done using Recovery Manager (RMAN).
D Select the archived redo logs.
E Specify the point in time (timestamp) to restore.

Question 5

Which three event types are supported for Autonomous Database? (Choose three.)

A Update IORM Begin
B Maintenance Begin
C Terminate End
D Change Autoscaling Configuration Compartment
E Change Compartment Begin

Question 6

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
(Choose the best answer.)

A Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
B Autonomous Data Warehouse workloads are optimized for mixed workloads.
C Autonomous Transaction Processing memory Usage optimizes workloads for parallel joins and aggregations.
D Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Question 7

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX? (Choose the best answer.)

A Create a new developer account.
B Access the APEX Administration Services and create the workspace for the developer.
C Create a database user with the APEX role.
D Create an IDCS user with the APEX role.

Question 8

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)

A Users have OS access to the database machine.
B It offers greater control and isolation starting at the Exadata cloud infrastructure level.
C Users can customize the OS stack and add additional packages.
D Users have SYS privileges in the database.
E Users can customize the maintenance schedule.

Question 9

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE? (Choose the best answer.)

A Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
B Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
C Oracle Data Safe only supports Autonomous Databases.
D Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

Question 10

Which statement is true when you provision an Autonomous Database using the cloning method? (Choose the best answer.)

A A clone database source can be a running database instance.
B A clone database source can be from a point-in-time backup that is less than 2 hours old.
C When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
D After an Autonomous database is created using a clone, the network access option can be changed.

Question 11

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

A through SQLPlus
B through SQL/Developer
C through the Oracle Cloud Infrastructure service console
D using DBMS_CLOUD_ADMIN Package

Question 12

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? (Choose the best answer.)

A SSH keys are not required in Oracle Cloud Infrastructure.
B SSH keys cannot be added from console. They have to be added using REST APIs only.
C On the Autonomous Database Console.
D Navigate to Identity, select Users panel on the console and select ג€Add Public Keyג€.

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 60

1 2 3

→

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

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

A DBNAME_MEDIUM
B DBNAME_HIGH
C DBNAME_CONCURRENT
D DBNAME_LOW

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding
Subnets, Compartments and User Groups.
Which statement is true? (Choose the best answer.)

A Create at least 2 of each resource.
B Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
C Only 1 of each is allowed to be allocated per environment.
D Create a Separate VCN that contains only public subnets.