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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 1:

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

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

• Question 2:

  You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing, License Included, Shared Infrastructure. Which parameter would you NOT use?

  A. db-type
  B. is-dedicated
  C. db-workload
  D. license-model
  A. db-type

• Question 3:

  Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

  A. Oracle Database Result Cache is enabled by default for all SQL statements.
  B. You have direct access to the database node.
  C. Parallelism is not enabled by default.
  D. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
  A. Oracle Database Result Cache is enabled by default for all SQL statements.
  D. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

• Question 4:

  Which command should you issue to enable application continuity on Oracle Autonomous Databaseon Shared Infrastructure?

  A. ALTER SESSION SET APPLICATION_CONTINUITY=TRUE
  B. EXEC DBMS_CLOUD_ADMIN.ENABLE_APP_CONT('');
  C. ALTER DATABASE SET APPLICATION_CONTINUITY=TRUE
  D. ALTER SYSTEM SET APPLICATION_CONTINUITY=TRUE
  B. EXEC DBMS_CLOUD_ADMIN.ENABLE_APP_CONT('');

• Question 5:

  What are two advantages of using Data Pump to migrate your Oracle databases to Autonomous Database? (Choose two.)

  A. Data Pump is faster to migrate database than using RMAN
  B. Data Pump creates the tablespaces used by your Autonomous Database
  C. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database
  D. Data Pump is platform-independent - it can migrate Oracle databases running on any platform
  C. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database
  D. Data Pump is platform-independent - it can migrate Oracle databases running on any platform

• Question 6:

  Which option should you use to create a graph with Graph Studio?

  A. Tables in an Autonomous Database instance
  B. Graph analytics algorithms
  C. NoSQL configuration
  D. Graph created by a special tool downloaded from oracle.com
  E. A graph license key
  A. Tables in an Autonomous Database instance

• Question 7:

  Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?

  A. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.
  B. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.
  C. Create a database link from the source database to the Autonomous Database environment and clone the PDB.
  D. Unplug into a PDB archive, which can be uploaded to Object Storage.
  B. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.

• Question 8:

  You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?

  A. APEX
  B. SQL Developer Web
  C. Business Models
  D. Data Load
  C. Business Models

• Question 9:

  Which three of the following data sources are available when using the Data Load page on Database Actions?

  A. Local Files
  B. Files in Oracle Cloud Storage
  C. REST endpoints
  D. Files in AWS S3 Storage
  E. Backup files in block storage
  A. Local Files
  B. Files in Oracle Cloud Storage
  D. Files in AWS S3 Storage

• Question 10:

  Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE for Oracle Data Safe?

  A. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
  B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
  C. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
  D. Oracle Data Safe only supports Autonomous Database
  D. Oracle Data Safe only supports Autonomous Database