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

You can use Service console to enable or disable auto scaling of Autonomous DB

You can use Service console to manage runaway SQL statements on Autonomous DB

You can use Service console to move Autonomous DB between compartments

You can use Service console to create manual backups of Autonomous database

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.

Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.

You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

Active transactions in Autonomous Data Warehouse are paused

Active transactions continue running unaffected

Active transactions are paused

Active transactions are terminated and rolled back

Scaling can happen while there are active transactions in the database

Exadata

Active Data Guard

RAC, but only when scaling beyond 16 OCPUs

Transparent Data Encryption

Multitenant

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

Backup and recovery must be done using Recovery Manager(RMAN).

Select the snapshot of the backup.

Select the archived redo logs.

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Regular Oracle SQL statements using a connection string to the database

Oracle Cloud Infrastructure console using the JSON Developer tool

REST API calls to the database

O NoSQL statements using Simple Oracle Document Access (SODA) drivers

The standby database is started readwrite

The standby database is transformed in a refreshable clone

The standby database is terminated

The standby database is started read only

Parallelism settings

Amount of storage

Number of OCPUS displayed in the console

Level of concurrency

I/O resources

Use SFTP to copy CSV files into Autonomous Database

Use Oracle Zero Downtime Migration (ZDM)

Use Recovery Manager (RMAN)

Use GoldenGate

Use Data Pump

supports only ATP as a workload type

maximum of two Always Free Databases per OCI tenancy

Oracle Application Express (APEX) not included

maximum of one OCPU per Database

Network Security Group

Security List

VCN

Route Table

Subnet

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 Endpoint networking.

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

Change the Automatic Maintenance Schedule to 'None’d.

Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.

You cannot permanently disable scheduled Automatic Maintenance.

Change the Automatic Maintenance Schedule to 'No Preference'.

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

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

The SQL statement completed its execution.

The SQL statement is executing.

The SQL statement is queued.

The SQL statement did not complete either due to an error.

Oracle Machine Learning notebook

Compartment quotas

Resource Manager settings

SQL Developer Web Console

Execute alter database for user MTHEO tablespace DATA quota = 10G;

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

Execute alter tablespace DATA set quota = 10G;

Autonomous Exadata infrastructure maintenance takes place at least once each quarter

Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching

You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter

If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter

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.

Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

Fleet Administrators are responsible for patching and backups of all container databases.

Fleet Administrators create, monitor and manage Autonomous Databases.

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

The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure

The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB

The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB

The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB

Manage Oracle Machine Learning users

Download the wallet

Rotate the wallet

Set resource management rules

Enable autoscaling

You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

You can retrieve previously executed Data Insights searches.

Data Insights is available with on-premises deployments of Oracle Database.

Data Insights is an additional priced option.

You can search for Data Insights against a base table or business model.

Click Scale Up/Down and select the Auto Scaling checkbox

Use a REST call to enable Auto Scaling

Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST all to restart the instance

Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance

MODIFY_BACELINE_WINDOW_SIZE

UPDATE_OBJECT_INFO

CREATE_BASELINE_TEMPLATE

MODIFY_SNAPSHOT_SETTINGS

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

Analytic View Base Table Query Transformation

Analytic View Transparency Views

Autonomous Aggregate Cache

Business Object Security Feature

Display Private Tables

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

Oracle Cloud Infrastructure Object Storage Classic

Data Insights displays information about patterns and anomalies in the data of entities in your Oracle Autonomous Database

The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard

Data insights are automatically generated by various analytic functions built into the database

Data Insights provides a wide range of graphical data presentation capabilities

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

inside the Autonomous Database wallet

inside the backups of the container database

In a separate key vault external to the Exadata Infrastructure

on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

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.

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Terminate End

Maintenance Begin

Change Compartment Begin

Change Autoscaling Configuration Compartment

Update IORM Begin

Under Core Infrastructure then Compute then Autonomous Exadata

Under Solutions and Platform then Platform Services then Autonomous Exadata

Under Database then Autonomous Transaction Processing then Autonomous Exadata

Under Core Infrastructure then Autonomous Exadata

Business Models

APEX

SQL Developer Web

Data Load

Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

It is enabled by default.

You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

The indexing feature is implemented as an automatic task that runs at a fixed interval.

Autonomous Data Guard automatically reverts to the primary database when it becomes available again

Autonomous Data Guard automatically creates a new standby database

A new wallet is required to connect to the standby database

The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary

Oracle Machine Learning Notebooks created in the primary database are available in the standby database

RMAN Cross-Platform backup and restore

Golden Gate on-premise installation

PDB unplug / plug operation

Datapump export / import

Dataguard Physical Standby

Golden Gate Cloud service

Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Autonomous Data Warehouse workloads are optimized for mixed workloads.

Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations

Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user

Oracle Data Safe only supports Autonomous Databases

Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary

ADMIN

ADBDEV

ADWC

DWROLE

Automatic online scaling of OCPU

Manual online scaling of OCPU

Manual offline scaling of Storage and OCPU

Manual online scaling of Storage

Automatic online scaling of Storage

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 to the database node.

24 hrs

2 hrs

5 min

1 day

3-D modelling

Churn analysis

Pattern matching

Facial recognition

Clustering