Online 1Z0-931-25 Practice Test

Question 1

Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure?

Options :

A :

You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available

B :

You can skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed

C : You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure

D :

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure

Answer: C

Question 2

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.)

Options :

A : Memory Usage

B : Data Organization

C : Backup Retention

D : Undo Management

Answer: A,B

Question 3

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

Options :

A : Quarterly Bundle Patch (QBP)

B : Prior Release Update Revision (PRUR)

C : Prior Release Update (PRU)

D : Release Update (RU)

Answer: D

Question 4

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?

Options :

A : Create a database user with connect, resource, and object privileges

B : Create a database user with the default privileges

C :

Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL

D : Create an IDCS user, create a database user with connect, resource, and object privileges

Answer: C

Question 5

Which three of the following data sources are available when using the Data Load page on Database Actions?

Options :

A : Local Files

B : Files in Oracle Cloud Storage

C : REST endpoints

D : Files in AWS S3 Storage

E : Backup files in block storage

Answer: A,B,D

EXPERTY DESIGNED 1Z0-931-25 PRACTICE TEST