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

November 13, 2022 1Z0-931-21, Oracle 0 Comments

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

5/5 - (1 vote)

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

1Z0-931-21 Exam Free Practice Test with100% Accurate Answers

Oracle 1Z0-931-21 Exam Syllabus Topics:

Topic	Details
Topic 1	Monitor ADB performance and set up service notifications Managing and Maintaining Autonomous Database
Topic 2	Use Autonomous Database with Oracle Machine Learning, APEX and SQL Developer Web (Database actions) Use services in ADB: auto indexing, data safe, compartment quotas
Topic 3	Provision Dedicated ADB (ADB, Exadata, Container DB, VM Cluster for Cloud @ Customer) Autonomous Database Dedicated & Autonomous Database Cloud @ Customer
Topic 4	Migrating to Autonomous Database Autonomous Database Technical Overview Manage maintenance scheduling (patching)
Topic 5	Manage ADB Backups and Restores, Patching and upgrading Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Topic 6	Incorporate Location-based analysis (Autonomous Spatial) Understand the Oracle Cloud Infrastructure
Topic 7	Describe ADB Dedicated and ADB Cloud@Customer resources, workflows and functionality Describe the Different Autonomous Database offerings
Topic 8	Developing on Autonomous Database Use ADB connectivity: Wallets, service handles
Topic 9	Configure Disaster Recovery (Data Guard) – both Shared and Dedicated Describe Autonomous Database architecture, integrations and license types

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

– In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user’s name to view the details.
-Click Add Public Key.
– Paste the key’s value into the window and click Add.

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

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1

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

Parallelism

Storage

Concurency

Memory

Sessions

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

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

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( ‘databaseid_tpurgent.adb.oraclecloud.com’, ‘LEVEL1’, 600);

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

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3

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.

https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm

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

https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm

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

https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf

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’

https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm

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.

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706

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

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/network-private-endpoint-change.html#GUID-9F76DD5E-85A3-4F5E-A88D-3D4D131FC2CA Enabling a private endpoint for an Autonomous Database ensures that the only access path to the database is via a VCN inside your Oracle Cloud Infrastructure tenancy.
This network configuration completely blocks access to the database from public endpoints

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.

Loading …

1Z0-931-21 dumps Free Test Engine Verified By It Certified Experts: https://www.examslabs.com/Oracle/Oracle-Autonomous-Database/best-1Z0-931-21-exam-dumps.html

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

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

Oracle 1Z0-931-21 Exam Syllabus Topics:

Written by:

admin

Leave a Reply Cancel reply

1Z0-931-21 Practice Tests

Related Certifications

Recent Posts

Recent Comments

Archives

Categories