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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 131:

  Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS, in Oracle Cloud Infrastructure?

  A. Subject
  B. Notification
  C. Topic
  D. Event
  C. Topic

• Question 132:

  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. MEDIUM
  B. TPURGENT
  C. LOW
  D. TP
  B. TPURGENT

• Question 133:

  Which Oracle package is used to load data to an Autonomous Database from object storage?

  A. DBMS_RPC
  B. DBMS_LOAD
  C. DBMS_MIGRATE
  D. DBMS_CLOUD
  D. DBMS_CLOUD

• Question 134:

  Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three.)

  A. Suppress alarms during investigations
  B. Create multiple alarm metrics
  C. Select the correct alarm interval for your metric.
  D. Routinely tune your alarms
  A. Suppress alarms during investigations
  C. Select the correct alarm interval for your metric.
  D. Routinely tune your alarms

• Question 135:

  Which three functions are provided by Spatial Studio? (Choose three.)

  A. Map visualization
  B. Custom SQL queries
  C. Spatial analysis
  D. Geocoding
  E. Spatial data editing
  A. Map visualization
  C. Spatial analysis
  E. Spatial data editing

• Question 136:

  Which statement is FALSE about Oracle Autonomous JSON Database?

  A. It supports NoSQL-style, document-centric applications.
  B. There is a 20 GB limit on JSON collection.
  C. JSON data is stored natively in the database.
  D. You can promote Autonomous JSON Database to Autonomous Transaction Processing.
  B. There is a 20 GB limit on JSON collection.

• Question 137:

  Which two infrastructure types support deployment of Oracle Autonomous Database? (Choose two.)

  A. Virtual Machines on Oracle Cloud Infrastructure
  B. Dedicated Exadata Infrastructure
  C. Oracle Bare Metal Servers
  D. Shared Exadata Infrastructure
  B. Dedicated Exadata Infrastructure
  D. Shared Exadata Infrastructure

• Question 138:

  Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

  A. Data formats supported include: text, CSV, JSON, Avro, and Parquet
  B. Data can be loaded from a local data source
  C. Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud, and Oracle Object Storage
  D. You must first manually create your database credentials usingDBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket
  E. Data can be loaded from a remote database using Database Links (DBLinks)
  D. You must first manually create your database credentials usingDBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket

• Question 139:

  Which two statements apply to the Autonomous Database service on Dedicated Infrastructure? (Choose two.)

  A. You, as the customer, are responsible for all patching operations
  B. You can set maintenance windows for an Autonomous Exadata Infrastructure
  C. You can set maintenance windows for each individual Autonomous Container Database
  D. Patching occurs on the first Sunday of each quarter
  A. You, as the customer, are responsible for all patching operations
  C. You can set maintenance windows for each individual Autonomous Container Database

• Question 140:

  Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPU 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 are not being used by other auto scaling databases to meet high-load demands.
  B. 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.
  C. The base number of OCPU cores allocated to a database is not guaranteed.
  D. Auto Scaling is enabled by default and can be enabled or disabled at any time.
  C. The base number of OCPU cores allocated to a database is not guaranteed.