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

Oracle 1Z0-931-21 Online Questions & Answers

• Question 51:

  When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

  A. Data
  B. Schemas
  C. Tablespaces
  D. Reports
  A. Data
  B. Schemas

• Question 52:

  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)
  F. Microsoft SQL Server (.mdf)

  ---

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

  mdf format is for MS SQL server database file

• Question 53:

  Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

  A. IOPS, Storage Space Used By Tablespace, Applyand Transport Lag
  B. CPU Utilization, Storage Utilization
  C. Query Latency, User Calls, Execute Count
  D. Transaction Count, Sessions, Running Statements
  B. CPU Utilization, Storage Utilization

• Question 54:

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

  A. It cannot be done.
  B. Using Database Configuration Assistant (DBCA) on the database server.
  C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
  D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
  C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

  ---

  The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands. https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using- oci-curl Examples of using Autonomous Database managing by REST API https://oracle.github.io/learning-library/workshops/autonomous-transaction- processing/LabGuide900ConfigureOCI-CLI.md

• Question 55:

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

  A. 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.
  B. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
  C. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
  D. 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.
  C. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

• Question 56:

  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
  D. 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 57:

  Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

  A. TPPERFORMANT
  B. MEDIUM
  C. HIGH
  D. LOW
  E. TPURGENT
  A. TPPERFORMANT

  ---

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID- 80E464A7-8ED4-45BB-A7D6-E201DD4107B7

• Question 58:

  Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

  A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
  B. Oracle Machine Learning ZeppelinNotebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
  C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
  D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
  C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

• Question 59:

  Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

  A. When you restore a database, the existing ACLs are not overwritten by the restore.
  B. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.
  C. ACLs can only be used with private endpoints.
  D. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.
  A. When you restore a database, the existing ACLs are not overwritten by the restore.

• Question 60:

  Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

  A. The Autonomous Database must belong to a Network Security Group (NSG).
  B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
  C. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
  D. The marketplace OCI image can be used with an Always Free Autonomous Database account.
  E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
  E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.