1z0-931-23 Exam Dumps - Oracle Autonomous Database Questions and Answers

On the Autonomous Database Console.

SSH keys are not required in Oracle Cloud Infrastructure.

SSH keys cannot be added from console. They have to be added using REST APIs only.

Navigate to Identity, select Users panel on the console and select "Add Public Key".

Exadata

Active Data Guard

RAC, but only when scaling beyond 16 OCPUs

Transparent Data Encryption

Multitenant

It cannot be done.

Using Database Configuration Assistant (DBCA) on the database server.

Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Connecting to the Cloud Infrastructure Command console via SSH wallet.

Increasing OCPUs will automatically increase storage

OCPUs and storage must remain in sync

OCPUs and storage can be scaled independently

Use auto scaling to increase storage

Week of the Quarter, Day of the Week, Start Hour

Month of the Year, Week of the Month, Day of the Week, Start Hour

Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour

Month of the Quarter, Week of the Month, Day of the Week, Start Hour

An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region

A single fault domain can be associated with multiple regions and availability domains

Regions are dependent on other regions and must be located within five thousand kilometers of each other

Because availability domains do not share infrastructure, such as power or cooling, or the Internal availability domain network, a failure at one availability domain within a region is u likely to impact the availability of the there within the same region

Quotas set on a parent compartment override quotas set on child compartments.

Compartment quotas cannot be set on the root compartment.

Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.

By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Log onto ADW server and issue is -al on the command line.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Only ATP manages optimizer statistics.

Only ATP supports automatic backups.

Only ADW uses columnar compression by default.

Only ADW supports autoscaling.

Shared Exadata Infrastructure

Dedicated Exadata Infrastructure

Exadata Cloud Service

Oracle Cloud Infrastructure Virtual Machines