oracle 1z0-931-21 practice test

Oracle Autonomous Database Cloud 2021 Specialist Exam

Last exam update: Sep 29 ,2024
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 ago

Answer E is Correct but it should be
E: CSV


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
3 months, 3 weeks ago

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

cesar.arias
3 months, 3 weeks 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."


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
10 months, 2 weeks ago

Answer is A


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
10 months, 2 weeks ago

Answer is A


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