Free 1z0-931-25 Exam Dumps

Question 11

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database? (Choose two.)

A. Active transactions are terminated and rolled back
B. Scaling can happen while there are active transactions in the database
C. Active transactions continue running unaffected
D. Active transactions are paused

Correct Answer:BC

Question 12

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with a private endpoint? (Choose three.)

A. Network Security Group
B. VCN
C. Security List
D. Route Table
E. Subnet

Correct Answer:ABE

Question 13

Which three statements are true about procedures in the DBMS_CLOUD package?

A. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the clou
B. You can run queries on external data from the Autonomous Data Warehouse.
C. The DBMS_CLOUD.DELETE_FILE procedure removes the credential file from the Autonomous Data Warehouse.
D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores cloud object credentials in the Autonomous Data Warehouse.
E. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE validates the source file for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a bad file table in Autonomous Data Warehouse.
F. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from cloud object storage to the Autonomous Data Warehouse.

Correct Answer:ACD

Question 14

Which are the two restrictions for an Always Free Autonomous Database? (Choose two.)

A. Supports only ATP as a workload type
B. Maximum of two Always Free Databases per OCI tenancy
C. Oracle Application Express (APEX) not included
D. Maximum of one OCPU per Database

Correct Answer:BD

Question 15

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version. How can they achieve this?

A. Change the Automatic Maintenance Schedule to 'No Preference'
B. Change the Automatic Maintenance Schedule to 'None'
C. You cannot permanently disable scheduled Automatic Maintenance
D. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week, or day

Correct Answer:C