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

15 days

1 day

7 days

30 days

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

Business Models

Data Load

SQL Developer Web

APEX

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

DBNAME_MEDIUM

DBNAME_HIGH

DBNAME_CONCURRENT

DBNAME_LOW

It supports only Autonomous Databases.

It helps you assess the security of your cloud database configurations by analyzing database configurations.

It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.

It evaluates user types, how users are authenticated, and the password policies assigned to each user.

It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.

2 hours

30 minutes

1 hours

24 hours

TPURGENT

TP

MEDIUM

LOW

alter database set application_continuity=true

alter session set application_continuity=true

exec dbms_cloucl_admin. enable_app_cont ( ' ' ) ;

alter system set application_continuity=true

SQL*Loader

Oracle Data Pump

Database Actions

Transportable Tablespace

Oracle GoldenGate

RMAN Restore

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.

DOC

AVRO

JSON

DDL

Dcsv

Parquet

In-flight transactions queries are stopped

Tools are no longer able to connect to a stopped instance

User with DWROLE can still access the database

CPU billing is halted

Oracle Data Safe only supports Autonomous Databases.

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

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

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

Suppress alarms during investigations.

Create multiple alarm metrics.

Create a single alarm for each metric.

Select the correct alarm interval for your metric.

Routinely tune your alarms.

Use a single interval for all alarms.

SQLDEV_ADMIN.GRANT_SCHEMA

ORDS_ADMIN.ENABLE_SCHEMA

ORDS_ADMIN.GRANT_SCHEMA

ORDS_PRIV.ENABLE_SCHEMA

1-25 X OCPU

OS

unlimited

20 X OCPU

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

alter system set application_continuity=true

alter session set application_continuity-true

exec dbms_cloud admin.enable_app_cont('');

alter database set application_continuity=true

Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator

Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

24 hrs

2 hrs

5 min

1 day

You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket

Data can be loaded from a remote database using Database Links (DBLinks)

Data can be loaded from a local data source

Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage

Data formats supported include: text, csv, json, avro and parquet

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Remove any non-JSON data from the database.

Increase the number of OCPUs allocated to the database.

Ask Support to migrate their setup to a node without noisy neighbors.

the Oracle Cloud Infrastructure A. service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

The OCI compute instance does not support connecting to a Shared Autonomous Database.

The Autonomous Database must belong to a Network Security Group (NSG).

The OCI compute instance can be used with an Always-Free Autonomous Database account.

A Private Endpoint is required to connect to the Shared-Autonomous Database.

creating and scaling an Autonomous Database service

configuring virtual cloud networks (VCNS)

monitoring Autonomous Databases for usage and query performance

using a wizard to download connection wallet for connection from desktop tools

starting and stopping an instance

SQL Developer

JAVA JDK

You can't use Python with ADB.

The Oracle Client and the cx_Oracle interface for Python

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

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.

After an Autonomous database is created using a clone, the network access option can be changed.

A clone database source can be a running database instance.

A clone database source can be from a point-in-time backup that is less than 2 hours old.

When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Start

Update License Type

Update Network Access

Change Administrator Password

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;

JDBC only

SQL*Net only

new ADB-specific protocols

any protocol supported by Oracle Net Services

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.

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

Tablespaces

Reports

Schemas

Data

When you restore a database, the existing ACLs are not overwritten by the restore.

An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

ACLs can only be used with private endpoints.

An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.

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

Use SFTP to copy CSV files into Autonomous Database

Use Oracle Zero Downtime Migration (ZDM)

Use Recovery Manager (RMAN)

Use GoldenGate

Use Data Pump

An "INSERT" REST call

A "GET" REST call

A "POST" REST call

A "PUT" REST call

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 Job

Service Gateway

Auth Token

Object Storage Bucket

Storage Gateway

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

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

Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints

An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL)

A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints

You can configure private endpoints for an Always Free Autonomous Database

Create a single alarm for each metric

Suppress alarms during investigations

Tune your alarms routinely

Select the correct alarm interval for your metric

Use a single interval for all alarms

Create multiple alarm metrics

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

db-workload

is-dedicated

db-type

license-model

through the Oracle Cloud Infrastructure service console

through SQL/Developer s

using DBMS_CLOUD_ADMIN package

through SQLPIus