CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-931-23 Dumps Questions Answers

Page: 1 / 12
Total 180 questions
Get 1z0-931-23 Full Access Download 1z0-931-23 PDF

Oracle Autonomous Database Cloud 2023 Specialist Questions and Answers

Question 1

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

Options:

A.

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

B.

The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

C.

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

D.

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

E.

The target table will be created in Autonomous Database if it does not already exist.

Buy Now
Question 2

You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and could like to explore the Autonomous Database tables using Autonomous Database's Data Tools.

Which step should you to perform to enable the new team member?

Options:

A.

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

B.

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

C.

Create a database user with the default privileges

D.

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

Question 3

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Options:

A.

Users have OS access to the database machine.

B.

Users can customize the maintenance schedule.

C.

It offers greater control and isolation starting at the Exadata cloud infrastructure level.

D.

Users have SYS privileges in the database.

E.

Users can customize the OS stack and add additional packages

Question 4

Which statement is FALSE about Oracle Text?

Options:

A.

It provides indexing, word and theme searches

B.

It is suited to search document collections

C.

It requires an Oracle Text license for Autonomous Database

D.

t uses standard SQL queries

Question 5

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

Options:

A.

RMAN Cross-Platform backup and restore

B.

Golden Gate on-premise installation

C.

PDB unplug / plug operation

D.

Datapump export / import

E.

Dataguard Physical Standby

F.

Golden Gate Cloud service

Question 6

What happened with the standby database when disabling Autonomous Data Guard?

Options:

A.

The standby database is started readwrite

B.

The standby database is transformed in a refreshable clone

C.

The standby database is terminated

D.

The standby database is started read only

Question 7

When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

Options:

A.

2 hours

B.

30 minutes

C.

1 hours

D.

24 hours

Question 8

Which two options are available to restore an Oracle Autonomous Database?

Options:

A.

Select the backup from which restore needs to be done.

B.

Specify the point in time (timestamp) to restore.

C.

Select the snapshot of the backup.

D.

Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

E.

Specify the archived custom image.

Question 9

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).

How can they achieve this?

Options:

A.

Change the Automatic Maintenance Schedule to 'None’d.

B.

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

C.

You cannot permanently disable scheduled Automatic Maintenance.

D.

Change the Automatic Maintenance Schedule to 'No Preference'.

Question 10

Which two actions can be performed when an Autonomous Database is stopped?

Options:

A.

Start

B.

Update License Type

C.

Update Network Access

D.

Change Administrator Password

Question 11

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

Options:

A.

Autonomous Transaction Processing only

B.

ATP and ADW

C.

Autonomous Data Warehouse only

D.

Hybrid Columnar compression

Question 12

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.

How should the customer unplug their database to migrate to Autonomous Database (ADB)?

Options:

A.

Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

B.

Create a database link from source database to the ADB environment and clone the PDB.

C.

Unplug to an xml file so database files and xml file can be uploaded to object storage.

D.

Unplug into a pdb archive which can be uploaded to object storage.

Question 13

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database Instance?

Options:

A.

The IP Protocol is set to TCP

B.

A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance

C.

The source is set to the address range you want to allow to connect to your database

D.

The destination port range is set to 1522

Question 14

Which three options are available to access data in an Autonomous JSON Database?

Options:

A.

Oracle Cloud Infrastructure console using the JSON Online Developer tool

B.

Oracle JSON Developer tool downloaded from OTN

C.

NOSQL statements using Oracle SODA drivers

D.

REST API calls to the database (not enabled by default)

E.

Regular Oracle SQL statements using a connection through the listener

Question 15

What is the correct way to list all files in the default data pump directory?

Options:

A.

By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

B.

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

C.

Log onto ADW server and issue is -al on the command line.

D.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Question 16

Which statement is FALSE about Oracle Autonomous JSON Database?

Options:

A.

JSON data is stored natively in the database

B.

You can promote Autonomous JSON Database to Autonomous Transaction /Processing

C.

It supports NoSQL-style, document-centric application

D.

There is a 20 GB limit on JSON collection

Question 17

Which three are use cases for Graph Studio? (Choose three.)

Options:

A.

3-D modelling

B.

Churn analysis

C.

Pattern matching

D.

Facial recognition

E.

Clustering

Question 18

When enabling auto-scaling, which three options do not change?

Options:

A.

Number of OCPUs displayed in the console.

B.

Amount of storage

C.

I/O resources

D.

parallelism settings

E.

Level of concurrency

Question 19

When integrating object storage with autonomous database how effectively oracle uses the files in the

object storage?

Options:

A.

Scan partition tables

B.

scan hybrid partition tables

C.

prun column in parquet files

D.

prun columns in csv files

Question 20

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

Options:

A.

IOPS, Storage Space Used By Tablespace, Apply and Transport Lag

B.

CPU Utilization, Storage Utilization

C.

Query Latency, User Calls, Execute Count

D.

Transaction Count, Sessions, Running Statements

Question 21

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

Options:

A.

through the Oracle Cloud Infrastructure service console

B.

through SQL/Developer s

C.

using DBMS_CLOUD_ADMIN package

D.

through SQLPIus

Question 22

Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

Options:

A.

Only ATP manages optimizer statistics.

B.

Only ATP supports automatic backups.

C.

Only ADW uses columnar compression by default.

D.

Only ADW supports autoscaling.

Question 23

What is the default port number for accessing a newly created Autonomous Database?

Options:

A.

1524

B.

1522

C.

1521

D.

1523

E.

1526

Question 24

Which three operations are available for a quarterly maintenance update on Autonomous Container Database?

Options:

A.

Reschedule patching

B.

Skip patching

C.

Apply a partial patch

D.

Patch immediately

E.

Reschedule and patch immediately

Question 25

In Graph Studio which you can use to create a graph?

Options:

A.

A graph license key

B.

Tables in an Autonomous Database instance

C.

NoSQL configuration

D.

Graph analytics algorithms

E.

Graph created by a special tool downloaded from Oracle.com

Question 26

What are three methods to load data into the Autonomous Database?

Options:

A.

Oracle GoldenGate

B.

Transportable Tablespace

C.

RMAN Restore

D.

Oracle Data Pump

E.

SQL*Loader

Question 27

You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?

Options:

A.

Click Scale Up/Down and select the Auto Scaling checkbox

B.

Use a REST call to enable Auto Scaling

C.

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

D.

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

Question 28

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

Options:

A.

TPPERFORMANT

B.

MEDIUM

C.

HIGH

D.

LOW

E.

TPURGENT

Question 29

Which two methods can you use to create database users and grant roles in Autonomous Database services?

Options:

A.

the Oracle Cloud Infrastructure A. service console

B.

SQL Developer

C.

the DBMS_CLOUD_ADMIN package

D.

SQL *Plus

Question 30

Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?

Options:

A.

RPO is adjustable, but RTO I always 5 minutes

B.

RTO and RPO are adjustable through the OCI console

C.

RTO and RPO are 0 minutes for manual failovers

D.

RTO is 2 minutes for an automatic failover

E.

RPO is 0 minutes for an automatic failover

Question 31

Which statement is true when the Autonomous Database has auto scaling enabled?

Options:

A.

Database concurrency is scaled up when needed by the workload.

B.

Increases the number of sessions available to the database.

C.

Scales the PGA and SGA size when needed for the workload.

D.

Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Question 32

An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.

Other than changing the shared user password, what can the admin do to protect the instance?

Options:

A.

Trust the user who left to not access the database.

B.

Shutdown and restart the instance.

C.

Rotate the instance wallet and share the new wallet with the remaining users.

D.

Delete the user.

Question 33

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

Options:

A.

User's OCID

B.

Tenancy's OCID

C.

Database ADMIN password

D.

Fingerprint of the public key

Question 34

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.

Which statement is true?

Options:

A.

Create a separate VCN that contains only public subnets

B.

Only 1 of each is allowed to be allocated per environment.

C.

Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

D.

Create at least 2 of each resource

Question 35

What are four methods to load data into an Autonomous Database?

Options:

A.

SQL*Loader

B.

Oracle Data Pump

C.

Database Actions

D.

Transportable Tablespace

E.

Oracle GoldenGate

F.

RMAN Restore

Question 36

Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

Options:

A.

Oracle Cloud Infrastructure Object Storage

B.

Google Cloud Storage

C.

Amazon S3

D.

Oracle Cloud Infrastructure Object Storage Classic

Question 37

Which statement is correct about the Service console in an Autonomous Database?

Options:

A.

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

B.

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

C.

You can use Service console to move Autonomous DB between compartments

D.

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

Question 38

Which statement is FALSE about Oracle Data Safe?

Options:

A.

It supports only Autonomous Databases.

B.

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

C.

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

D.

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

E.

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

Question 39

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.

Which service will you need to connect to?

Options:

A.

TPURGENT

B.

TP

C.

MEDIUM

D.

LOW

Question 40

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.

The load on the database increases from three OCPUs to nine OCPUs.

What is the total number of concurrent statements that the TPURGENT service can support?

Options:

A.

900

B.

1800

C.

2700

D.

1500

Question 41

Which two methods can you use to define Oracle Machine Learning users?

Options:

A.

SQL Developer

B.

the DBMS_CLOUD_ADMIN package

C.

Oracle Cloud Infrastructure Console

D.

Service Console

Question 42

Which three are Oracle-recommended best practices for Autonomous Database alarms?

Options:

A.

Create a single alarm for each metric

B.

Suppress alarms during investigations

C.

Tune your alarms routinely

D.

Select the correct alarm interval for your metric

E.

Use a single interval for all alarms

F.

Create multiple alarm metrics

Question 43

Which four file formats are supported when loading data from Cloud Storage?

Options:

A.

Parquet

B.

DOC

C.

DDL

D.

JSON

E.

CSV

F.

AVRO

Question 44

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

Options:

A.

Use SFTP to copy CSV files into Autonomous Database

B.

Use Oracle Zero Downtime Migration (ZDM)

C.

Use Recovery Manager (RMAN)

D.

Use GoldenGate

E.

Use Data Pump

Question 45

Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?

Options:

A.

Tablespaces

B.

Reports

C.

Schemas

D.

Data

Question 46

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.

What steps do you need to take?

Options:

A.

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.

B.

Create a database user with the default privileges.

C.

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

D.

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

Question 47

Which four file formats are supported when loading data from Cloud Storage?

Options:

A.

DOC

B.

AVRO

C.

JSON

D.

DDL

E.

Dcsv

F.

Parquet

Question 48

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

Options:

A.

Parallelism is not enabled by default.

B.

Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

C.

Oracle Database Result Cache is enabled by default for all SQL statements.

D.

You have direct access to the database node.

Question 49

What are the two supported infrastructure options for deploying an Autonomous Database?

Options:

A.

VM on Oracle Cloud Infrastructure

B.

Dedicated Exadata Infrastructure

C.

Any Oracle Engineered System

D.

Shared Exadata Infrastructure

E.

Bare-metal on Oracle Cloud Infrastructure

Exam Detail
Vendor: Oracle
Certification: Oracle Autonomous Database
Exam Code: 1z0-931-23
Exam Name: Oracle Autonomous Database Cloud 2023 Specialist
Last Update: Dec 22, 2024
1z0-931-23 Question Answers
Page: 1 / 12
Total 180 questions
Get 1z0-931-23 Full Access Download 1z0-931-23 PDF