Latest [Jul 26, 2022] Real Oracle 1z0-931-22 Exam Dumps Questions [Q65-Q82]

July 26, 2022 1z0-931-22, Oracle 0 Comments

Latest [Jul 26, 2022] Real Oracle 1z0-931-22 Exam Dumps Questions [Q65-Q82]

4/5 - (1 vote)

Latest [Jul 26, 2022] Real Oracle 1z0-931-22 Exam Dumps Questions

1z0-931-22 Dumps To Pass Oracle Autonomous Database Exam in One Day (Updated 115 Questions)

QUESTION 65
While creating a business model what advanced options you can enable or disable? (Choose three)

Business Object Security Feature

Analytic View Transparency View

Autonomous Aggregate Cache

Display private tables

Analytic View Base Table Query Transformation

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

SDO_RELATE

SDO_GEOMETRY

SDO_LOCATION

GEO_JSON

QUESTION 68
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure

service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

QUESTION 69
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

Add a “BEFORE SHUTDOWN ON DATABASE” trigger within the database

Create a rule for the Oracle Cloud Infrastructure Event for “Autonomous Database STOP END”

Create a notification alert using DBMS_SNMP package

Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

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

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.

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

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

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.

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

2 hours

30 minutes

1 hours

24 hours

Clone Sources
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.
Note When you create a clone from a backup, you must select a backup that is at least two hours old.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm

QUESTION 72
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;

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0

QUESTION 73
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python?

SQL Developer

JAVA JDK

You can’t use Python with ADB.

The Oracle Client and the cx_Oracle interface for Python

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53
https://developer.oracle.com/databases/database-for-python-developers-1.html

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

SQLDEV_ADMIN.GRANT_SCHEMA

ORDS_ADMIN.ENABLE_SCHEMA

ORDS_ADMIN.GRANT_SCHEMA

ORDS_PRIV.ENABLE_SCHEMA

As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA

QUESTION 75
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

60 days

7 days

15 days

120 days

QUESTION 76
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

https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm

QUESTION 77
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

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

QUESTION 78
Which statement is correct about the Service console in an 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

You can use Service console to move Autonomous DB between compartments

You can use Service console to create manual backups of Autonomous database

QUESTION 79
Which statement is true when the Autonomous Database has auto scaling enabled?

Database concurrency is scaled up when needed by the workload.

Increases the number of sessions available to the database.

Scales the PGA and SGA size when needed for the workload.

Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

QUESTION 80
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 81
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 82
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Backup and recovery must be done using Recovery Manager(RMAN).

Select the snapshot of the backup.

Select the archived redo logs.

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C