Practice Free 1z0-931-23 Oracle Autonomous Database Cloud 2023 Specialist Exam Questions Answers With Explanation

REST

Python

Java

PL/SQL Gremlin

Parallelism settings

Amount of storage

Number of OCPUS displayed in the console

Level of concurrency

I/O resources

Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.

Create a database user with the default privileges.

Create a database user with connect, resource, and object privileges.

Create an IDCS user. Create a database user with connect, resource, and object privileges.

Oracle Cloud Infrastructure Object Storage Classic

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

A graph license key

NoSQL configuration

Graph created by a special tool downloaded from oracle.com

Graph analytics algorithms

Tables in an Autonomous Database instance

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.

Shared Exadata Infrastructure

Dedicated Exadata Infrastructure

Exadata Cloud Service

Oracle Cloud Infrastructure Virtual Machines

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

Change the Automatic Maintenance Schedule to "No Preference"

You cannot permanently disable scheduled automatic maintenance

Change the Automatic Maintenance Schedule to "None"

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

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.

Manage Oracle Machine Learning users

Download the wallet

Rotate the wallet

Set resource management rules

Enable autoscaling

Tablespaces

Reports

Schemas

Data

Parallelism

Storage

Concurency

Memory

Sessions

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

Spatial analysis

Geocoding

Custom SQL queries

Map visualization

Spatial data editing

900

1800

2700

1500

Oracle Key Vault, Oracle Cloud Infrastructure Vault

Oracle Database Vault, Oracle Key Vault

Oracle Audit Vault, Oracle Key Vault

Oracle Cloud Infrastructure Vault, Oracle Database Vault

licence-model

db-workload

is-dedicaced

db-type

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

DBNAME_MEDIUM

DBNAME_HIGH

DBNAME_CONCURRENT

DBNAME_LOW

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.

Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB

Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

User's OCID

Tenancy's OCID

Database ADMIN password

Fingerprint of the public key

Oracle Machine Learning notebook

Compartment quotas

Resource Manager settings

SQL Developer Web Console

SQL Developer

the DBMS_CLOUD_ADMIN package

Oracle Cloud Infrastructure Console

Service Console

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

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 skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed

You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure

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;

Create an IDCS user Create a database user with connect, resource, and object privileges

Create a database user with connect, resource, and object privileges

Create a database user with the default privileges

Create a REST-enabled database user (with connect and object privileges) and grant the U DWROLE role

db-workload

is-dedicated

db-type

license-model

SQL Developer

JAVA JDK

You can't use Python with ADB.

The Oracle Client and the cx_Oracle interface for Python

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

Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.

ADW since operational reporting is a higher priority in this scenario.

It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

RMAN backup & restore

Physical migration methods, such as database cloning

Orace Zero Downtime Migration (ZDM)

Original imp/exp tools

Oracle Data Pump

Oracle Golden Gate

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.

2 hours

30 minutes

1 hours

24 hours

Analytic View Base Table Query Transformation

Analytic View Transparency Views

Autonomous Aggregate Cache

Business Object Security Feature

Display Private Tables

Admin page of the Cloud Service Console

OCI CLI

OS command line from the database server.

SQLDeveloper

Release Update (RU)

Prior Release Update Revision (PRUR)

Prior Release Update (PRU)

Quarterly Bundle Patch (QBP)

MEDIUM

HIGH

TP

TPURGENT

Scripting language

Run key-value queries

Object-oriented language

Ability to specify patterns

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.

Oracle GoldenGate

Transportable Tablespace

RMAN Restore

Oracle Data Pump

SQL*Loader

Transparent Data Encryption

Database Vault

Customer Managed Keys

Data Redaction

Audit Vault

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

Number of OCPUs displayed in the console.

Amount of storage

I/O resources

parallelism settings

Level of concurrency

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

TPPERFORMANT

MEDIUM

HIGH

LOW

TPURGENT

Switchover

Reinstate

Change Protection Mode

View Apply Lag

Failover