1Z0-931-21 Online Practice Questions and Answers

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

D. Fleet Administrator, Database Administrator, Database User, 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 theydo 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 two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

A. Exadata

B. Active Data Guard

C. RAC, but only when scaling beyond 16 OCPUs

D. Transparent Data Encryption

E. Multitenant

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?

A. Oracle Data Safe only supports Autonomous Databases.

B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.

C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

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

When enabling auto-scaling, which three options do not change?

A. Number of OCPUs displayed in the console.

B. Amount of storage

C. I/O resources

D. parallelism settings

E. Level of concurrency

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 ZeppelinNotebook, 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

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

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

What happened with the standby database when disabling Autonomous Data Guard?

A. The standby database is started readwrite

B. The standby database is transformed in a refreshable clone

C. The standby database is terminated

D. Thestandby database is started read only

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = `DW'

B. Allow group ADB-Admins to manage autonomous-database in tenancy.

C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).

How can they achieve this?

A. Change the Automatic Maintenance Schedule to'None'd.

B. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.

C. You cannot permanently disable scheduled Automatic Maintenance.

D. Change the Automatic Maintenance Schedule to 'No Preference'.

Which statement is FALSE about Oracle Autonomous JSON Database?

A. JSON data is stored natively in the database

B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing

C. It supports NoSQL-style, document-centric application

D. There is a 20 GB limit on JSON collection

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints

B. An Autonomous Database with privateendpoints can be accessed from the public internet by adding your ip address to an Access Control List.

C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.

D. You can configure Private Endpoints for an Always Free Autonomous Database

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

A. Autonomous Transaction Processing

B. Autonomous Data Warehouse

C. Neither service ignores hints by default

D. Both services ignore hints by default

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

A. User's OCID

B. Tenancy's OCID

C. Database ADMIN password

D. Fingerprint of the public key