Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

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

Go to page:
Question # 41

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

A.

Parallelism is not enabled by default.

B.

Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

C.

Oracle Database Result Cache is enabled by default for all SQL statements.

D.

You have direct access to the database node.

Full Access
Question # 42

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?

A.

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

B.

Create a database user with the default privileges.

C.

Create a database user with connect, resource, and object privileges.

D.

Create an IDCS user. Create a database user with connect, resource, and object privileges.

Full Access
Question # 43

When running lots of high concurrent queries in Autonomous Database, you should use which

predefined service connection? (Choose the best answer.)

A.

DBNAME_MEDIUM

B.

DBNAME_HIGH

C.

DBNAME_CONCURRENT

D.

DBNAME_LOW

Full Access
Question # 44

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

A.

The standby database is started readwrite

B.

The standby database is transformed in a refreshable clone

C.

The standby database is terminated

D.

The standby database is started read only

Full Access
Question # 45

What infrastructure does the Autonomous Database run on?

A.

VM on Oracle Cloud Infrastructure

B.

Bare-metal on Oracle Cloud Infrastructure

C.

Exadata on Oracle Cloud Infrastructure

D.

Any Oracle Engineered system

Full Access
Question # 46

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

A.

Files in Oracle Cloud Storage

B.

Backup files in block storage

C.

Local Files

D.

Files in AWS S3 Storage

E.

REST endpoints

Full Access
Question # 47

Which native data type is used to store spatial information?

A.

SDO_RELATE

B.

SDO_GEOMETRY

C.

SDO_LOCATION

D.

GEO_JSON

Full Access
Question # 48

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

A.

User's OCID

B.

Tenancy's OCID

C.

Database ADMIN password

D.

Fingerprint of the public key

Full Access
Go to page: