1z0-931-22 Practice Exam Questions with Answers Oracle Autonomous Database Cloud 2022 Professional Certification

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 ' ) ;

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.

The standby database is started readwrite

The standby database is transformed in a refreshable clone

The standby database is terminated

Thestandby database is started read only

There are three types of quota policy statements which are set, unset and zero.

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

Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

Compartment quotas are set by Oracle.

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

Create an IDCS user with the APEX role.

Access the APEX Administration Services and create the workspace for the developer.

Create a new developer account.

Create a database user with the APEX role.

JSON data is stored natively in the database

You can promote Autonomous JSON Database to Autonomous Transaction /Processing

It supports NoSQL-style, document-centric application

There is a 20 GB limit on JSON collection

A graph license key

Tables in an Autonomous Database instance

NoSQL configuration

Graph analytics algorithms

Graph created by a special tool downloaded from Oracle.com

Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database

Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"

Create a notification alert using DBMS_SNMP package

Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

The standby database is terminated.

The standby database is also stopped.

Switchover is automatically initiated.

Failover is automatically initiated.

Access to Database Actions is available for all users of Autonomous Database.

Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

SQL Developer Web is available exclusively on the Autonomous Database.

Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpointnetworking.

Oracle APEX can be accessed only from the Developer menu in the Service Console.