1Z0-931-21 Online Practice Questions and Answers

Which two statements are true about accessing Autonomous Database Tools?

A. Access to Database Actions is available for all users of Autonomous Database.

B. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

C. SQL Developer Web is available exclusively on the Autonomous Database.

D. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpointnetworking.

E. Oracle APEX can be accessed only from the Developer menu in the Service Console.

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

B. The source files can reside inOracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

E. The target table will be created in Autonomous Database if it does not already exist.

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.

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

A. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

B. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

C. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB - >Database Administrator -> Autonomous DB

D. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

Which three are use cases for Graph Studio? (Choose three.)

A. 3-D modelling

B. Churn analysis

C. Pattern matching

D. Facial recognition

E. Clustering

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A. The Autonomous Database must belong to a Network Security Group (NSG).

B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.

C. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

D. The marketplace OCI image can be used with an Always Free Autonomous Database account.

E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

A. alter database set application_continuity=true

B. alter session set application_continuity=true

C. exec dbms_cloucl_admin. enable_app_cont ( ' ' ) ;

D. alter system set application_continuity=true

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

A. Use SFTP to copy CSV files into Autonomous Database

B. Use Oracle Zero Downtime Migration (ZDM)

C. Use Recovery Manager (RMAN)

D. Use GoldenGate

E. Use Data Pump

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

What is the correct way to list all files in the default data pump directory?

A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

B. You cannot list files in the default data pumpdirectory from Autonomous Data Warehouse (ADW).

C. Log onto ADW server and issue is -al on the command line.

D. By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;