Summer Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Question # 4

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

A.

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

B.

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

C.

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

D.

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

E.

the Listener endpoint where the Autonomous Database should register on

Full Access
Question # 5

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

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.

Full Access
Question # 6

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

A.

DOC

B.

AVRO

C.

JSON

D.

DDL

E.

Dcsv

F.

Parquet

Full Access
Question # 7

You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance.

Which tool would you use to automate data exploration and create pivot tables?

A.

Business Models

B.

APEX

C.

SQL Developer Web

D.

Data Load

Full Access
Question # 8

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?

A.

900

B.

1800

C.

2700

D.

1500

Full Access
Question # 9

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

A.

Autonomous Transaction Processing only

B.

ATP and ADW

C.

Autonomous Data Warehouse only

D.

Hybrid Columnar compression

Full Access
Question # 10

Which two are ways Oracle Database can optimally access data in Object Storage?

A.

Optimized data archive using hybrid partitioned tables

B.

Optimized data archive using partitioned external tables

C.

Scan avoidance using partitioned external tables

D.

Scan avoidance using columnar pruning for .csv files

Full Access
Question # 11

On which two infrastructure classes can the Autonomous Database service be deployed?

A.

Shared Exadata Infrastructure

B.

Dedicated Exadata Infrastructure

C.

Exadata Cloud Service

D.

Oracle Cloud Infrastructure Virtual Machines

Full Access
Question # 12

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

A.

Number of OCPUs displayed in the console.

B.

Amount of storage

C.

I/O resources

D.

parallelism settings

E.

Level of concurrency

Full Access
Question # 13

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

A.

Admin page of the Cloud Service Console

B.

OCI CLI

C.

OS command line from the database server.

D.

SQLDeveloper

Full Access
Question # 14

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?

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.

Full Access
Question # 15

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

A.

alter database set application_continuity=true

B.

alter session set application_continuity=true

C.

exec dbms_cloucl_admin. enable_app_cont ( ' ' ) ;

D.

alter system set application_continuity=true

Full Access
Question # 16

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

A.

Parallelism

B.

Storage

C.

Concurency

D.

Memory

E.

Sessions

Full Access
Question # 17

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.

Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 18

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

A.

Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

B.

You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

C.

It is enabled by default.

D.

You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

E.

The indexing feature is implemented as an automatic task that runs at a fixed interval.

Full Access
Question # 19

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

A.

The SQL statement completed its execution.

B.

The SQL statement is executing.

C.

The SQL statement is queued.

D.

The SQL statement did not complete either due to an error.

Full Access
Question # 20

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

A.

Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB

Connection button, then Download the Wallet.

B.

Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then

Download the Wallet.

C.

Click the Compute section of the menu, then choose Instance Configurations, then Download

Wallet.

D.

Click on the Object Storage and find your Autonomous Bucket and Download the Wallet

Credentials.

E.

Find the Service Console for your Autonomous Database, then pick Administration, then Download

the Client Credentials (Wallet).

Full Access
Question # 21

A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.

When restoring/cloning the ADB, you must select a backup which is atleast___

hours/minutes old.

A.

24 hrs

B.

2 hrs

C.

5 min

D.

1 day

Full Access
Question # 22

Which statement is not correct when the Autonomous Database is stopped?

A.

In-flight transactions queries are stopped

B.

Tools are no longer able to connect to a stopped instance

C.

User with DWROLE can still access the database

D.

CPU billing is halted

Full Access
Question # 23

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A.

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

B.

A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.

C.

The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

D.

The marketplace OCI image can be used with an Always Free Autonomous Database account.

E.

The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

Full Access
Question # 24

You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements:

* Autonomous Transaction Processing

* Licence Tracluded

* Shared Infrastructure

Which parameter would you NOT use?

A.

licence-model

B.

db-workload

C.

is-dedicaced

D.

db-type

Full Access
Question # 25

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

A.

1-25 X OCPU

B.

OS

C.

unlimited

D.

20 X OCPU

Full Access
Question # 26

Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?

A.

Increasing OCPUs will automatically increase storage

B.

OCPUs and storage must remain in sync

C.

OCPUs and storage can be scaled independently

D.

Use auto scaling to increase storage

Full Access
Question # 27

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

A.

Data Insights

B.

JSON

C.

Catalog

D.

Data Load

Full Access
Question # 28

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.

What should they do to remove this bottleneck?

A.

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

B.

Remove any non-JSON data from the database.

C.

Increase the number of OCPUs allocated to the database.

D.

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

Full Access
Question # 29

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

A.

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

B.

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

C.

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

D.

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

Full Access
Question # 30

Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?

A.

You can set a maintenance window for each individual Autonomous Container Database

B.

You, as the customer, are responsible for all patching operations

C.

You can set a maintenance window for an Autonomous Exadata Infrastructure

D.

Patching occurs on the first Sunday of each quarter

Full Access
Question # 31

Which three event types are supported for Autonomous Database?

A.

Terminate End

B.

Maintenance Begin

C.

Change Compartment Begin

D.

Change Autoscaling Configuration Compartment

E.

Update IORM Begin

Full Access
Question # 32

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

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

Full Access
Question # 33

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

A.

Tablespaces

B.

Reports

C.

Schemas

D.

Data

Full Access
Question # 34

Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

A.

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.

B.

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

C.

You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

D.

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.

Full Access
Question # 35

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

A.

Oracle GoldenGate

B.

Transportable Tablespace

C.

RMAN Restore

D.

Oracle Data Pump

E.

SQL*Loader

Full Access
Question # 36

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

A.

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

B.

Execute alter user MTHEO quota unlimited on tablespace DATA;

C.

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

D.

Execute alter tablespace DATA det quota = 10G;

Full Access
Question # 37

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

A.

through the Oracle Cloud Infrastructure service console

B.

through SQL/Developer s

C.

using DBMS_CLOUD_ADMIN package

D.

through SQLPIus

Full Access
Question # 38

Which are the two restrictions for an Always Free Autonomous Database?

A.

supports only ATP as a workload type

B.

maximum of two Always Free Databases per OCI tenancy

C.

Oracle Application Express (APEX) not included

D.

maximum of one OCPU per Database

Full Access
Question # 39

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

A.

Parquet

B.

DOC

C.

DDL

D.

JSON

E.

CSV

F.

AVRO

Full Access
Question # 40

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

A.

SQLDEV_ADMIN.GRANT_SCHEMA

B.

ORDS_ADMIN.ENABLE_SCHEMA

C.

ORDS_ADMIN.GRANT_SCHEMA

D.

ORDS_PRIV.ENABLE_SCHEMA

Full Access
Question # 41

Which two actions are available to perform when an Autonomous Database is stopped?

A.

Start

B.

Update Network Access

C.

Change administrator password

D.

Update License Type

Full Access
Question # 42

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

A.

2 hours

B.

30 minutes

C.

1 hours

D.

24 hours

Full Access
Question # 43

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

A.

A graph license key

B.

NoSQL configuration

C.

Graph created by a special tool downloaded from oracle.com

D.

Graph analytics algorithms

E.

Tables in an Autonomous Database instance

Full Access
Question # 44

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 45

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

A.

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

B.

Execute alter user MTHEO quota unlimited on tablespace DATA;

C.

Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

D.

Execute alter tablespace DATA set quota = 10G;

Full Access
Question # 46

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

A.

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

B.

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

C.

Oracle Data Safe only supports Autonomous Databases

D.

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

Full Access
Question # 47

Which three of the following data sources are available when using the Data Load page on Database Actions?

A.

Files in Oracle Cloud Storage

B.

Backup files in block storage

C.

Local Files

D.

Files in AWS S3 Storage

E.

REST endpoints

Full Access
Question # 48

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

A.

Exadata

B.

Active Data Guard

C.

RAC, but only when scaling beyond 16 OCPUs

D.

Transparent Data Encryption

E.

Multitenant

Full Access