Latest Oracle 1Z0-931-21 Free Certification Exam Material with 114 Q&As [Q60-Q83]

5/5 - (1 vote)

Latest Oracle 1Z0-931-21 Free Certification Exam Material with 114 Q&As

UPDATED 1Z0-931-21 Exam Questions Certification Test Engine to PDF

Oracle 1Z0-931-21 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe the options and considerations for migrating to ADB Articulate the key features of Autonomous Database
Topic 2	Describe ADB Dedicated and ADB Cloud@Customer resources, workflows and functionality Describe the Different Autonomous Database offerings
Topic 3	Configure Disaster Recovery (Data Guard) – both Shared and Dedicated Describe Autonomous Database architecture, integrations and license types
Topic 4	Manage ADB Backups and Restores, Patching and upgrading Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Topic 5	Provision Dedicated ADB (ADB, Exadata, Container DB, VM Cluster for Cloud @ Customer) Autonomous Database Dedicated & Autonomous Database Cloud @ Customer
Topic 6	Migrating to Autonomous Database Autonomous Database Technical Overview Manage maintenance scheduling (patching)
Topic 7	Developing on Autonomous Database Use ADB connectivity: Wallets, service handles
Topic 8	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 9	Monitor ADB performance and set up service notifications Managing and Maintaining Autonomous Database
Topic 10	Incorporate Location-based analysis (Autonomous Spatial) Understand the Oracle Cloud Infrastructure

QUESTION 60
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Autonomous Transaction Processing

Autonomous Data Warehouse

Neither service ignores hints by default

Both services ignore hints by default

QUESTION 61
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)?

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

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

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

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

QUESTION 62
Which statement is NOT correct when setting up compartment quotas?

Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

Compartment quotas are set by Oracle.

Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

There are three types of quota policy statements which are set, unset and zero.

QUESTION 63
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?

Create an IDCS user with the APEX role.

Access the APEX Administration Services and create the workspace for the developer.

Create a new developer account.

Create a database user with the APEX role.

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

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

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

the ‘High Availability Container Database’ in which the Autonomous instance should run

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

the Listener endpoint where the Autonomous Database should register on

QUESTION 65
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 66
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

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 67
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

QUESTION 68
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 69
Which three of the following data sources are available when using the Data Load page on Database Actions?

Files in Oracle Cloud Storage

Backup files in block storage

Local Files

Files in AWS S3 Storage

REST endpoints

QUESTION 70
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 71
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

Use SFTP to copy CSV files into Autonomous Database

Use Oracle Zero Downtime Migration (ZDM)

Use Recovery Manager (RMAN)

Use GoldenGate

Use Data Pump

QUESTION 72
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 73
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 74
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Oracle Cloud Infrastructure Object Storage Classic

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

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 76
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

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

through the Oracle Cloud Infrastructure service console

through SQL/Developer s

using DBMS_CLOUD_ADMIN package

through SQLPIus

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

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 79
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

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 80
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

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 81
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?

db-workload

is-dedicated

db-type

license-model

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

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 83
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.

Moving an Autonomous Database instance does not include its automatic backups.

You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.