Oracle Real Dumps Practice Exam Questions by Dumpswarp

Oracle Autonomous Database Cloud 2023 Specialist Questions and Answers

Question 1

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.

Which statement is FALSE regarding the auto scaling feature?

Options:

For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.

The base number of OCPU cores allocated to a database is not guaranteed.

For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

Auto scaling is enabled by default and can be enabled or disabled at any time.

Question 2

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:

TPURGENT

MEDIUM

LOW

Question 3

What is the number of concurrent statements that can be handled by the medium database service name?

Options:

1-25 X OCPU

unlimited

20 X OCPU

Question 4

What are the two differentiators of Oracle Autonomous Data Base on Dedicated Infrastructure?

Options:

Users can customize the OS stack and add additional packages

Users have more control over the maintenance schedule

Users have OS access to the database machine

Users are offered greater reutral and isolation starting at the Exade Cloud infrastructure level

Users have SYS privileges in the database

Question 5

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

Options:

60 days

7 days

15 days

120 days

Question 6

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Options:

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.

Question 7

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

Options:

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.

Question 8

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

Options:

A Network Security Group is required within your Virtual Cloud Network before you can provision a

Shared Autonomous Database to use Private Endpoints

An Autonomous Database with private endpoints can be accessed from the public internet by

adding your ip address to an Access Control List.

Private Endpoints can be configured when you clone a Shared Autonomous Database that was

initially created with public endpoints.

You can configure Private Endpoints for an Always Free Autonomous Database

Question 9

Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?

Options:

Maximum Continuity

Maximum Availability

Maximum Performance

Maximum Protection

Question 10

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Options:

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

Allow group ADB-Admins to manage autonomous-database in tenancy.

Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

Question 11

Who, and in which order, provisions dedicated Exadata Infrastructure resources?

Options:

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

Question 12

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

Options:

Tablespaces

Reports

Schemas

Data

Question 13

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

Options:

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

Question 14

Which native data type is used to store spatial information?

Options:

SDO_RELATE

SDO_GEOMETRY

SDO_LOCATION

GEO_JSON

Question 15

Which option should you use to create a graph with Graph Studio?

Options:

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

Question 16

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

Options:

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.

Question 17

Which two statements are true about accessing Autonomous Database Tools?

Options:

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.

Question 18

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.

Which statement is FALSE?

Options:

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.

Question 19

What infrastructure does the Autonomous Database run on?

Options:

VM on Oracle Cloud Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Exadata on Oracle Cloud Infrastructure

Any Oracle Engineered system

Question 20

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:

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

Question 21

Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

Options:

Admin page of the Cloud Service Console

OCI CLI

OS command line from the database server.

SQLDeveloper

Question 22

Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)

Options:

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

Question 23

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

Options:

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;

Question 24

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

Options:

SQL Developer

the DBMS_CLOUD_ADMIN package

Oracle Cloud Infrastructure Console

Service Console

Question 25

Which statement is correct about managing and monitoring of Autonomous Database?

Options:

You can use Service console to move Autonomous DB between compartments.

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

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.

Question 26

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

Options:

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.

Question 27

Which statement is true when you provision an Autonomous Database using the cloning method?

Options:

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.

Question 28

Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

Options:

Oracle Cloud Infrastructure Object Storage Classic

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

Question 29

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:

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.

Question 30

What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

Options:

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.

Question 31

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

Options:

TPPERFORMANT

MEDIUM

HIGH

LOW

TPURGENT

Question 32

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

Options:

Network Security Group

Security List

VCN

Route Table

Subnet

Question 33

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

Options:

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.

Question 34

Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?

Options:

Manage Oracle Machine Learning users

Download the wallet

Rotate the wallet

Set resource management rules

Enable autoscaling

Question 35

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

Options:

the Oracle Cloud Infrastructure A. service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

Question 36

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

Options:

2 hours

30 minutes

1 hours

24 hours

Question 37

When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

Options:

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

Question 38

Which two statements are true about Data Insights?

Options:

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.

Question 39

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

Options:

1524

1522

1521

1523

1526

Question 40

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?

Options:

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

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

Question 41

Which two statements are true about Oracle Cloud Infrastructure (OCI)?

Options:

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

Question 42

Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

Options:

Parallelism

Storage

Concurency

Memory

Sessions

Question 43

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

Options:

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

Question 44

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:

900

1800

2700

1500

Question 45

When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?

Options:

They continue to work

They revert to pending

They are also rotated

They become invalid

Question 46

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

Options:

DOC

AVRO

JSON

DDL

Dcsv

Parquet

Question 47

Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?

Options:

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

Question 48

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

How can they achieve this?

Options:

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

Question 49

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

Options:

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

Question 50

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

Options:

VM on Oracle Cloud Infrastructure

Dedicated Exadata Infrastructure

Any Oracle Engineered System

Shared Exadata Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Question 51

Which workload is particularly suited to Oracle Autonomous JSON Database?

Options:

Data Lakes

Schemaless, document centric

Transactions

Data Marts

Load More 1z0-931-23 Questions

Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dumps65

Dumpswrap Top Menu

breadcrumb

Oracle 1z0-931-23 Dumps

1z0-931-23 Free PDF Questions

Oracle Autonomous Database Cloud 2023 Specialist Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation: