Oracle 1Z0-931-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-931-22 Online Questions & Answers

• Question 91:

  You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to?

  A. TPURGENT
  B. TP
  C. MEDIUM
  D. LOW
  A. TPURGENT

  ---

  tpurgent: The highest priority application connection service for time critical transaction processing operations. This connectionservice supports manual parallelism. https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID- 9747539B-FD46-44F1-8FF8-F5AC650F15BE

• Question 92:

  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?

  A. The standby database is terminated.
  B. The standby database is also stopped.
  C. Switchover is automatically initiated.
  D. Failover is automatically initiated.
  B. The standby database is also stopped.

• Question 93:

  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
  A. Transparent Data Encryption
  B. Database Vault
  C. Customer Managed Keys

  ---

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

• Question 94:

  Which two of the followingstatements are correct?

  A. ODI Web Edition is available only on Oracle Linux.
  B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
  C. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
  D. All of the capabilities of ODI Classic are available with ODI Web Edition,
  A. ODI Web Edition is available only on Oracle Linux.
  B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

• Question 95:

  Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

  A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
  B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores CloudObject Storage credentials in the Autonomous Data Warehouse database.
  C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format optionsspecified for the external table in a badfile table on Autonomous Data Warehouse.
  D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
  E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates anexternal table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
  B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores CloudObject Storage credentials in the Autonomous Data Warehouse database.
  C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format optionsspecified for the external table in a badfile table on Autonomous Data Warehouse.
  E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates anexternal table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

  ---

  DELETE_FILE Procedure

  This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.

  CREATE_CREDENTIAL Procedure

  This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.

  PUTJDBJECT Procedure

  This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).

  VALIDATE EXTERNAL TABLE Procedure

  This procedure validates the source files for an external table, generateslog information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

  CREATE_EXTERNAL_TABLE Procedure

  This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.

  To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store ,

  including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during

  the imp oil process.

  This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store witha DBMS_CLOUD.PUT_OBJECT

  command.

  VALIDATE_EXTERNAL_TABLE Procedure

  This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in abadfiletable on Autonomous Database. The overloaded form

  enables you to use the operation_id parameter.

  PUT_OBJECT Procedure

  This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedureis 5 gigabytes (GB) DELETE FILE Procedure

  This procedure removes the specified file from the specified directory on Autonomous Database.

  CREATE_EXTERNAL_TABLE Procedure

  This procedure creates an external table on files in the Cloud. This allows you to runqueries on external data from Autonomous Database.

• Question 96:

  Which three are use cases for Graph Studio? (Choose three.)

  A. 3-D modelling
  B. Churn analysis
  C. Pattern matching
  D. Facial recognition
  E. Clustering
  A. 3-D modelling
  C. Pattern matching
  E. Clustering

• Question 97:

  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 onthe 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. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
  D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

  ---

  Autonomous Transaction Processing provides all of theperformance 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.

• Question 98:

  Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

  A. Oracle Cloud Infrastructure Object Storage
  B. Google Cloud Storage
  C. Amazon S3
  D. Oracle Cloud Infrastructure Object Storage Classic
  B. Google Cloud Storage

• Question 99:

  Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

  A. 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.
  B. Moving an Autonomous Database instance does not include its automatic backups.
  C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
  D. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
  A. 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.

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes

• Question 100:

  Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

  A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule thecontainer database maintenance for the following quarter.
  B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
  C. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
  D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of theExadata grid infrastructure code and operating systems updates), and include database patching.
  D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of theExadata grid infrastructure code and operating systems updates), and include database patching.

  ---

  Exadata infrastructure maintenance takes place at least once each quarter and is mandatory.

  If a scheduled container database maintenance run cannottake place (because of changes made to infrastructure maintenance scheduling or other reasons) , Oracle will automatically reschedule the container database maintenance for the following quarter.

  You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter. Exadata infrastructure maintenance patches the Exadata infrastructure (including patching of the Exadata grid infrastructure code and operating systems updates), and DO NOT include database patching.