CertsTopics Logo

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

1z0-931-23 Oracle Exam Lab Questions

Page: 12 / 12
Total 180 questions
Get 1z0-931-23 Full Access Download 1z0-931-23 PDF

Oracle Autonomous Database Cloud 2023 Specialist Questions and Answers

Question 45

Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?

Options:

A.

Tablespaces

B.

Reports

C.

Schemas

D.

Data

Question 46

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, 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.

Question 47

Which four file formats are supported when loading data from Cloud Storage?

Options:

A.

DOC

B.

AVRO

C.

JSON

D.

DDL

E.

Dcsv

F.

Parquet

Question 48

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

Options:

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.

Page: 12 / 12
Total 180 questions
Get 1z0-931-23 Full Access Download 1z0-931-23 PDF