Oracle 1Z0-931 Online Practice Questions and Exam Preparation

Oracle 1Z0-931 Online Questions & Answers

• Question 21:

  Given the steps:

  1.

  Create Oracle Machine Learning User

  2.

  Create projects

  3.

  Create workspaces

  4.

  Create Notebooks

  5.

  Run SQL Scripts

  Which two steps are out of order when working with Oracle Machine learning? (Choose two.)

  A. Create Oracle Machine Learning User
  B. Create workspaces
  C. Create Notebooks
  D. Run SQL Scripts
  E. Create projects
  D. Run SQL Scripts
  E. Create projects

• Question 22:

  Which task is NOT automatically performed by the Oracle Autonomous Database?

  A. Backing up the database.
  B. Mask your sensitive data.
  C. Patching the database.
  D. Automatically optimize the workload.
  B. Mask your sensitive data.

  ---

  Reference: https://www.oracle.com/database/what-is-autonomous-database.html

• Question 23:

  Which is NOT required to connect to Autonomous Database from SQL developer?

  A. Database name
  B. Service name
  C. Wallet file
  D. Username and password
  A. Database name

• Question 24:

  As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.

  Which connection service is appropriate for such a workload?

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

  ---

  Reference: https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md

• Question 25:

  Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

  A. 18.1 onwards
  B. Any version
  C. 17.4 onwards
  D. 12c Release 2 onwards
  A. 18.1 onwards

• Question 26:

  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 keys cannot 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".
  D. Navigate to Identity, select Users panel on the console and select "Add Public Key".

  ---

  Reference: https://www.dbarj.com.br/en/2018/09/creating-a-read-only-user-in-oracle-cloud-infrastructure/

• Question 27:

  Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)

  A. Data is encrypted at rest using transparent data encryption.
  B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
  C. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.
  D. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
  A. Data is encrypted at rest using transparent data encryption.
  B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
  D. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.

  ---

  Reference: https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html

• Question 28:

  Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

  A. Terraform
  B. REST API
  C. Dlocker
  D. Enterprise Manager
  A. Terraform

• Question 29:

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

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

  ---

  Reference: https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbcreating.htm

• Question 30:

  Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

  A. Original Import/Export tools
  B. Physical migration method like database cloning
  C. Data Pump
  D. RMAN backup and restore
  C. Data Pump

  ---

  Oracle Data Pump provides very fast bulk data movement between Oracle Databases and Autonomous Data.

  Reference: https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-options-data-pump-sql-loader-dbms_cloud-goldengate/