Dec-2023 Oracle 1z0-931-22 Certification Real 2023 Mock Exam [Q32-Q54]

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

Oracle Cloud Infrastructure Object Storage Classic

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

QUESTION 33
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 34
Which native data type is used to store spatial information?

SDO_RELATE

SDO_GEOMETRY

SDO_LOCATION

GEO_JSON

QUESTION 35
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.

QUESTION 36
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 37
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 38
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 39
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

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

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

It is enabled by default.

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

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

QUESTION 40
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

It cannot be done.

Using Database Configuration Assistant (DBCA) on the database server.

Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Connecting to the Cloud Infrastructure Command console via SSH wallet.

QUESTION 41
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 42
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 43
Which two statements are true about Data Insights?

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 44
Which statement is not correct when the Autonomous Database is stopped?

In-flight transactions queries are stopped

Tools are no longer able to connect to a stopped instance

User with DWROLE can still access the database

CPU billing is halted

QUESTION 45
What is the correct way to list all files in the default data pump directory?

By executing select * from DBMS_CLOUD.LIST_FILES(‘DATA_PUMP_DIR’);

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Log onto ADW server and issue is -al on the command line.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ‘ ) ;

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

Trust the user who left to not access the database.

Shutdown and restart the instance.

Rotate the instance wallet and share the new wallet with the remaining users.

Delete the user.

QUESTION 47
Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?

The standby database is terminated.

The standby database is also stopped.

Switchover is automatically initiated.

Failover is automatically initiated.

QUESTION 48
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

Release Update (RU)

Prior Release Update Revision (PRUR)

Prior Release Update (PRU)

Quarterly Bundle Patch (QBP)

QUESTION 49
Which two options are available to restore an Oracle Autonomous Database?

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Select the snapshot of the backup.

Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

Specify the archived custom image.

QUESTION 50
Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects.

Data Load

Catalog

JSON

Data Insight

QUESTION 51
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 52
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

The target table will be created in Autonomous Database if it does not already exist.

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

900

1800

2700

1500