Oracle Oracle Certifications 1Z0-931-22 Questions & Answers

• 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 privateendpoints can be accessed from the public internet by adding 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

  Correct Answer: AC

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/network- private-endpointchange.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 OracleCloud Infrastructure tenancy. This network configuration completely blocks access to the database from public endpoints

• Question 22:

  Which two actions are available to perform when an Autonomous Database is stopped?

  A. Start

  B. Update Network Access

  C. Change administrator password

  D. UpdateLicense Type

  Correct Answer: AD

• Question 23:

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

  Correct Answer: C

  "If the Autonomous Exadata Infrastructure resource doesn't have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define."

  https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenancescheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E

• Question 24:

  Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

  A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

  B. The OCI compute instance does not support connecting to a Shared Autonomous Database.

  C. The Autonomous Database must belong to a Network Security Group (NSG).

  D. The OCI compute instance can be used with an Always-Free Autonomous Database account.

  E. A Private Endpoint is required to connect to the Shared-Autonomous Database.

  Correct Answer: D

• Question 25:

  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

  Correct Answer: C

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

• Question 26:

  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_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

  D. Execute alter tablespace DATA setquota = 10G;

  Correct Answer: C

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

• Question 27:

  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?

  A. SQL Developer

  B. JAVA JDK

  C. You can't use Python with ADB.

  D. The Oracle Client and the cx_Oracle interface for Python

  Correct Answer: D

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

• Question 28:

  Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

  A. Network Security Group

  B. Security List

  C. VCN

  D. Route Table

  E. Subnet

  Correct Answer: ACE

  To provision an Autonomous Database with a private endpoint, you must have the following resources

  already created:

  A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure.

  Cannot be changed after provisioning. A private subnet within your VCN configured with default DHCP

  options. Cannot be changed after provisioning.

  At least 1network security group (NSG) within your VCN for the Autonomous Database. Can be changed

  or edited after provisioning.

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

• Question 29:

  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 keyscannot be added from console. They have to be added using REST APIs only.

  D. Navigate to Identity, select Users panel on the console and select "Add Public Key".

  Correct Answer: D

  -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 30:

  

  Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

  A. Data Pump Export File

  B. Avro

  C. Parquet

  D. Text

  E. JSON

  F. Microsoft SQL Server (.mdf)

  Correct Answer: F

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/format- options.html#GUID08C44CDA-7C81-481A-BA0A-F7346473B703

  mdf format is for MS SQL server database file