1z0-931-22 Oracle Autonomous Database Cloud 2022 Professional Question and Answers

Parallelism is not enabled by default.

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

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

You have direct access tothe database node.

Current settings for ACLs are cloned.

Clone can be in a different region.

All OML notebooks are cloned.

All underlying data for OML notebooks is cloned.

All resource management rules are cloned.

For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meethigh-load demands.

The base number of OCPU cores allocated to a database is not guaranteed.

For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

Auto scaling is enabled by default and can be enabled or disabled at any time.

Quotas set on a parent compartment override quotas set on childcompartments.

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.

Create a separate VCN that contains only public subnets

Only 1 of each is allowed to be allocated per environment.

Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

Create at least 2 of each resource

1524

1522

1521

1523

1526

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

You cannot list files in the default data pumpdirectory 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 ' ) ;

Use SFTP to copy CSV files into Autonomous Database

Use Oracle Zero Downtime Migration (ZDM)

Use Recovery Manager (RMAN)

Use GoldenGate

Use Data Pump

Trust the user who left to not access the database.

Shutdown and restart the instance.

Rotate the instance wallet and share the new wallet with the remaining users.

Delete the user.

Network Security Group

Security List

VCN

Route Table

Subnet

24hrs

2 hrs

5 min

1 day

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

The source files can reside inOracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

The target table will be created in Autonomous Database if it does not already exist.

Suppress alarms during investigations.

Create multiple alarm metrics.

Create a single alarm for each metric.

Select the correct alarm interval for your metric.

Routinelytune your alarms.

Use a single interval for all alarms.