Oracle Autonomous Database Cloud 2023 Specialist

Question 1

Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure?

A. View Apply Lag

B. Switchover

C. Change Protection Mode

D. Reinstate

E. Failover

Correct Answer: B,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

Which two actions can be performed when an Autonomous Database is stopped?

A. Change Administrator Password

B. Update License Type

C. Update Network Access

D. Start

Correct Answer: B,D

Question 3

You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure.
Which three statements are true about the standby database after a failover?

A. A new wallet is required to connect to the standby database

B. Oracle Machine Learning Notebooks created in the primary database are available in the standby database

C. The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary

D. Autonomous Data Guard automatically creates a new standby database

E. Autonomous Data Guard automatically reverts to the primary database when it becomes available again

Correct Answer: B,C,D

Question 4

Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?

A. Java

B. SQL*Plus

C. You cannot use .NET with ADB.

D. Oracle Data Access Components for Windows

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

Which two methods can you use to define Oracle Machine Learning users?

A. SQL Developer

B. Service Console

C. the DBMS_CLOUD_ADMIN package

D. Oracle Cloud Infrastructure Console

Correct Answer: D

Question 6

What are the two differentiators of Oracle Autonomous Data Base on Dedicated Infrastructure?

A. Users are offered greater reutral and isolation starting at the Exade Cloud infrastructure level

B. Users have more control over the maintenance schedule

C. Users have OS access to the database machine

D. Users have SYS privileges in the database

E. Users can customize the OS stack and add additional packages

Correct Answer: A,D

Question 7

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

A. The standby database is terminated

B. The standby database is started readwrite

C. The standby database is started read only

D. The standby database is transformed in a refreshable clone

Correct Answer: A

Question 8

Which two are ways Oracle Database can optimally access data in Object Storage?

A. Optimized data archive using hybrid partitioned tables

B. Scan avoidance using partitioned external tables

C. Optimized data archive using partitioned external tables

D. Scan avoidance using columnar pruning for .csv files

Correct Answer: A,B

Question 9

Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

A. Oracle Cloud Infrastructure Object Storage Classic

B. Azure Blob Storage

C. Amazon S3

D. Oracle Cloud Infrastructure Object Storage

E. Google Cloud Storage

Correct Answer: A,D

Oracle Autonomous Database Cloud 2023 Specialist - 1z0-931-23 Exam Practice Test

Latest Update

Useful Links

Contact Us