oracle 1z0-931-21 practice test

Which native data type is used to store spatial information?

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

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

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

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.

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

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.

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

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.

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.

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

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

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.

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

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

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.

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.