1z0-931-25 Oracle Exam Questions and Free Practice Test

Question 7

While provisioning a dedicated Autonomous Container Database, which backup retention period CANNOT be implemented?

A. 120 days

B. 7 days

C. 60 days

D. 15 days

Correct Answer:A

Question 8

How many Network Security Groups (NSGs) can you configure for an Autonomous Database?

A. 3

B. 9

C. 7

D. 5

Correct Answer:D

Question 9

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 10

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 11

How do you change the tablespace quota for user MTHEO on an Autonomous Database on Shared Infrastructure?

A. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');

B. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;

C. Execute ALTER TABLESPACE DATA SET QUOTA = 10G;

D. Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;

Correct Answer:B

Question 12

Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)

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 private endpoints can be accessed from the public internet by adding your IP address to an Access Control List (ACL).

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

Correct Answer:AC

START 1z0-931-25 EXAM