oracle 1z0-931-21 practice test

Oracle Autonomous Database Cloud 2021 Specialist Exam

Last exam update: May 08 ,2025
Page 1 out of 7. Viewing questions 1-15 out of 112

Question 1

Which native data type is used to store spatial information?

  • A. SDO_RELATE
  • B. SDO_GEOMETRY
  • C. SDO_LOCATION
  • D. GEO_JSON
Answer:

B


User Votes:
A
50%
B 1 votes
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

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

  • A. DOC
  • B. AVRO
  • C. JSON
  • D. DDL
  • E. Dcsv
  • F. Parquet
Answer:

B, C, E, F


User Votes:
A 1 votes
50%
B 1 votes
50%
C 1 votes
50%
D 1 votes
50%
E
50%
F 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000
rehansiddiq
1 year, 7 months ago

Answer E is Correct but it should be
E: CSV

0

Question 3

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary
database indicates that it is
stopped.
Which statement is true?

  • A. The standby database is terminated.
  • B. The standby database is also stopped.
  • C. Switchover is automatically initiated.
  • D. Failover is automatically initiated.
Answer:

B


User Votes:
A 1 votes
50%
B 1 votes
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

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

  • A. RMAN
  • B. Logs
  • C. OCI Metrics
  • D. Performance Hub
  • E. Enterprise Manager Cloud Control
Answer:

C, D, E


User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D 1 votes
50%
E 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 5

Which two statements are true about Data Insights?

  • A. You can retrieve previously executed Data Insights searches.
  • B. Data Insights is available with on-premises deployments of Oracle Database.
  • C. Data Insights is an additional priced option.
  • D. You can search for Data Insights against a base table or business model.
Answer:

A, D


User Votes:
A 1 votes
50%
B
50%
C
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

Which two cloud services are supported to import Data Pump files to Autonomous Database on
Dedicated Infrastructure?

  • A. Oracle Cloud Infrastructure Object Storage Classic
  • B. Oracle Cloud Infrastructure Object Storage
  • C. Google Cloud Storage
  • D. Amazon S3
  • E. Azure Blob Storage
Answer:

A, B


User Votes:
A 2 votes
50%
B 2 votes
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 7

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.
Answer:

A


User Votes:
A 1 votes
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction
Processing (ATP) databases?

  • A. Only ATP manages optimizer statistics.
  • B. Only ATP supports automatic backups.
  • C. Only ADW uses columnar compression by default.
  • D. Only ADW supports autoscaling.
Answer:

C


User Votes:
A
50%
B
50%
C 1 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

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
Answer:

C


User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
cesar.arias
11 months ago

The customer-managed encryption key is stored in Oracle Cloud Infrastructure Vault, external to the database host

0
cesar.arias
11 months ago

Must be D, "Encryption Key
By default, Autonomous
Database creates and manages
all the master encryption keys
used to protect your data, storing
them in a secure PKCS 12
keystore on the same Exadata
systems where the databases
reside.
If your company security policies
require, Autonomous Database
can instead use keys you create
and manage."

0

Question 10

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

  • A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
  • B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
  • C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
  • D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
Answer:

C


User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

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. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
  • B. Remove any non-JSON data from the database.
  • C. Increase the number of OCPUs allocated to the database.
  • D. Ask Support to migrate their setup to a node without noisy neighbors.
Answer:

D


User Votes:
A
50%
B
50%
C 1 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

Which three options are available to access data in an Autonomous JSON Database?

  • A. Oracle Cloud Infrastructure console using the JSON Online Developer tool
  • B. Oracle JSON Developer tool downloaded from OTN
  • C. NOSQL statements using Oracle SODA drivers
  • D. REST API calls to the database (not enabled by default)
  • E. Regular Oracle SQL statements using a connection through the listener
Answer:

A, C, D


User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D 1 votes
50%
E 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 13

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on
Dedicated Infrastructure?

  • A. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
  • B. CPU Utilization, Storage Utilization
  • C. Query Latency, User Calls, Execute Count
  • D. Transaction Count, Sessions, Running Statements
Answer:

B


User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
KP
1 year, 5 months ago

Answer is A

0

Question 14

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.
Answer:

E


User Votes:
A 1 votes
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000
KP
1 year, 5 months ago

Answer is A

0

Question 15

Which two options are available to restore an Oracle Autonomous Database?

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

A. B


User Votes:
A 1 votes
50%
B 1 votes
50%
C 1 votes
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000
To page 2