View All 1Z0-931-21 Actual Exam Questions, Answers and Explanations for Free [Q16-Q37] : Exams Labs Braindumps : http://blog.examslabs.com

QUESTION 16
Where can a user’s public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

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

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

Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.

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

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

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

Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

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

Parallelism

Storage

Concurency

Memory

Sessions

QUESTION 19
Which two statements are true about accessing Autonomous Database Tools?

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 20
Which statement is true when you provision an Autonomous Database using the cloning method?

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 21
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

alter database set application_continuity=true

alter session set application_continuity=true

exec dbms_cloucl_admin. enable_app_cont ( ‘ <service_name> ‘ ) ;

alter system set application_continuity=true

QUESTION 22
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

Change the Automatic Maintenance Schedule to ‘None’d.

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

You cannot permanently disable scheduled Automatic Maintenance.

Change the Automatic Maintenance Schedule to ‘No Preference’.

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

Oracle GoldenGate

Transportable Tablespace

RMAN Restore

Oracle Data Pump

SQL*Loader

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

Admin page of the Cloud Service Console

OCI CLI

OS command line from the database server.

SQLDeveloper

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

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.

QUESTION 26
Which native data type is used to store spatial information?

SDO_RELATE

SDO_GEOMETRY

SDO_LOCATION

GEO_JSON

QUESTION 27
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?

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 28
Which three event types are supported for Autonomous Database?

Terminate End

Maintenance Begin

Change Compartment Begin

Change Autoscaling Configuration Compartment

Update IORM Begin

QUESTION 29
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

Oracle Machine Learning notebook

Compartment quotas

Resource Manager settings

SQL Developer Web Console

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

1524

1522

1521

1523

1526

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

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 32
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

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 33
Which four file formats are supported when loading data from Cloud Storage?

DOC

AVRO

JSON

DDL

Dcsv

Parquet

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

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 35
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

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 36
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

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 37
Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

When you restore a database, the existing ACLs are not overwritten by the restore.

An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

ACLs can only be used with private endpoints.

An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.

View All 1Z0-931-21 Actual Exam Questions, Answers and Explanations for Free [Q16-Q37]

Oracle 1Z0-931-21 Exam Syllabus Topics: