Top Tips Of Down To Date 1z0-931-20 Free Samples

NEW QUESTION 1
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

• A. alter database set application_continuity=true
• B. alter session set application_continuity=true
• C. exec dbms_cloucl_admi
• D. enable_app_cont ( ' <service_name> ' ) ;
• E. alter system set application_continuity=true

Answer: D

NEW QUESTION 2
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

• A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’
• B. Allow group ADB-Admins to manage autonomous-database in tenancy.
• C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
• D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

Answer: D

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

• A. The SQL statement completed its execution.
• B. The SQL statement is executing.
• C. The SQL statement is queued.
• D. The SQL statement did not complete either due to an error.

Answer: C

NEW QUESTION 4
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?

• A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
• B. the Client Credentials wallet which is used to connect to the Autonomous Database
• C. the 'High Availability Container Database' in which the Autonomous instance should run
• D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
• E. the Listener endpoint where the Autonomous Database should register on

Answer: B

NEW QUESTION 5
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?

• A. 900
• B. 1800
• C. 2700
• D. 1500

Answer: C

NEW QUESTION 6
What REST verb is used to create an Autonomous Database service using REST APIs?

• A. An "INSERT" REST call
• B. A "GET" REST call
• C. A "POST" REST call
• D. A "PUT" REST call

Answer: C

Explanation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html

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

• A. 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.
• B. The base number of OCPU cores allocated to a database is not guaranteed.
• C. 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.
• D. Auto scaling is enabled by default and can be enabled or disabled at any time.

Answer: A

NEW QUESTION 8
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?

• A. Trust the user who left to not access the database.
• B. Shutdown and restart the instance.
• C. Rotate the instance wallet and share the new wallet with the remaining users.
• D. Delete the user.

Answer: B

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

• A. You can use Service console to move Autonomous DB between compartments.
• B. You can use Service console to create manual backups of Autonomous database.
• C. You can use Service console to enable or disable auto scaling of Autonomous DB.
• D. You can use Service console to manage runaway SQL statements on Autonomous DB.

Answer: A

NEW QUESTION 10
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

• A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
• B. ADW since operational reporting is a higher priority in this scenario.
• C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
• D. AT
• E. Using 'tpurgent' and 'high' TNS services to separate connection types.

Answer: D

Explanation:
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.

NEW QUESTION 11
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

• A. Under Core Infrastructure then Compute then Autonomous Exadata
• B. Under Solutions and Platform then Platform Services then Autonomous Exadata
• C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
• D. Under Core Infrastructure then Autonomous Exadata

Answer: A

NEW QUESTION 12
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

• A. Backup and recovery must be done using Recovery Manager(RMAN).
• B. Select the snapshot of the backup.
• C. Select the archived redo logs.
• D. Select the backup from which restore needs to be done.
• E. Specify the point in time (timestamp) to restore.

Answer: DE

Explanation:
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-78

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

• A. On the Autonomous Database Console.
• B. SSH keys are not required in Oracle Cloud Infrastructure.
• C. SSH keys cannot be added from consol
• D. They have to be added using REST APIs only.
• E. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Answer: D

Explanation:
- 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.

NEW QUESTION 14
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

• A. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
• B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
• C. It is enabled by default.
• D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
• E. The indexing feature is implemented as an automatic task that runs at a fixed interval.

Answer: E

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

• A. A.-1524B.1522C.1521D.1523E.1526

Answer: B

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

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

• A. Change the Automatic Maintenance Schedule to 'None’d.
• B. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
• C. You cannot permanently disable scheduled Automatic Maintenance.
• D. Change the Automatic Maintenance Schedule to 'No Preference'.

Answer: B

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

• A. You can skip a scheduled maintenance ru
• B. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
• C. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
• D. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
• E. You can perform a "rolling restart" on all the Autonomous Database
• F. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

Answer: D

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

• A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
• B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
• C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
• D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
• E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

Answer: AE

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

• A. SQLDEV_ADMIN.GRANT_SCHEMA
• B. ORDS_ADMIN.ENABLE_SCHEMA
• C. ORDS_ADMIN.GRANT_SCHEMA
• D. ORDS_PRIV.ENABLE_SCHEMA

Answer: C

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

• A. Admin page of the Cloud Service Console
• B. OCI CLI
• C. OS command line from the database server.
• D. SQLDeveloper

Answer: B

NEW QUESTION 21
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

• A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
• B. An Autonomous Database with private endpoints can be accessed from the public internet byadding your ip address to an Access Control List.
• C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
• D. You can configure Private Endpoints for an Always Free Autonomous Database

Answer: BC

NEW QUESTION 22
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

• A. Transparent Data Encryption
• B. Database Vault
• C. Customer Managed Keys
• D. Data Redaction
• E. Audit Vault

Answer: ABC

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472

NEW QUESTION 23
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

• A. Current settings for ACLs are cloned.
• B. Clone can be in a different region.
• C. All OML notebooks are cloned.
• D. All underlying data for OML notebooks is cloned.
• E. All resource management rules are cloned.

Answer: CE

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

• A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
• B. Execute alter user MTHEO quota unlimited on tablespace DATA;
• C. Execute DBMS_CLOUD_ADMI
• D. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' ,Tablespace___quota => "UNLIMITED*);
• E. Execute alter tablespace DATA set quota = 10G;

Answer: D

NEW QUESTION 25
......