1z0-931-23 Practice Exam Questions with Answers Oracle Autonomous Database Cloud 2023 Specialist Certification

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

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.

60 days

7 days

15 days

120 days

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.

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

Oracle Cloud Infrastructure Object Storage Classic

optimized data archive using partitioned external tables

optimized data archive using hybrid partitioned tables

scan avoidance using block skipping when reading parquet and ore files

scan avoidance using columnar pruning for columnar stores like parquet and orc

scan avoidance using partitioned external tables

scan avoidance using columnar pruning for .csv files

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".

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.

Oracle Database licenses

Autonomous Container Database

Network Security Group(s)

Virtual Cloud Network and Subnet

Identity and Access Management (IAM) policy rules that allow access to the database

Autonomous Exadata Infrastructure

Autonomous Database instance

3-D modelling

Churn analysis

Pattern matching

Facial recognition

Clustering

VM on Oracle Cloud Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Exadata on Oracle Cloud Infrastructure

Any Oracle Engineered system

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

RPO is adjustable, but RTO I always 5 minutes

RTO and RPO are adjustable through the OCI console

RTO and RPO are 0 minutes for manual failovers

RTO is 2 minutes for an automatic failover

RPO is 0 minutes for an automatic failover

900

1800

2700

1500

Data Lakes

Schemaless, document centric

Transactions

Data Marts

JDBC only

SQL*Net only

new ADB-specific protocols

any protocol supported by Oracle Net Services

Transparent Data Encryption

Database Vault

Customer Managed Keys

Data Redaction

Audit Vault

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

DBNAME_MEDIUM

DBNAME_HIGH

DBNAME_CONCURRENT

DBNAME_LOW

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.

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.

the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

the Client Credentials wallet which is used to connect to the Autonomous Database

the 'High Availability Container Database' in which the Autonomous instance should run

the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

the Listener endpoint where the Autonomous Database should register on

Spatial analysis

Geocoding

Custom SQL queries

Map visualization

Spatial data editing

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

Use SFTP to copy CSV files into Autonomous Database

Use Oracle Zero Downtime Migration (ZDM)

Use Recovery Manager (RMAN)

Use GoldenGate

Use Data Pump

Manage Oracle Machine Learning users

Download the wallet

Rotate the wallet

Set resource management rules

Enable autoscaling

Data Pump Export File

Avro

Parquet

Text

JSON

Microsoft SQL Server (.mdf)

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

VM on Oracle Cloud Infrastructure

Dedicated Exadata Infrastructure

Any Oracle Engineered System

Shared Exadata Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Network Security Group

Security List

VCN

Route Table

Subnet

Oracle Cloud Infrastructure Object Storage Classic

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

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

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO', V U tablespace_quota -> UNLIMITED');

Execute alter tablespace DATA det quota = 10G;

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.

Reschedule patching

Skip patching

Apply a partial patch

Patch immediately

Reschedule and patch immediately

SQL Developer

the DBMS_CLOUD_ADMIN package

Oracle Cloud Infrastructure Console

Service Console

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.

MEDIUM

HIGH

TP

TPURGENT

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

Parallelism

Storage

Concurency

Memory

Sessions

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.

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

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

Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition

All capabilities to transform data in ODI Classic are available with ODI Web Edition

Workflows for data transforms is only available on the ODI Web Edition

Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows