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

Oracle 1Z0-1105-22 Online Questions & Answers

• Question 41:

  Which statement is true about moving virtual machine (VM) database (DB) systems fro one compartment to another?

  A. You can move VM DB systems from one compartment to another by only using Oracle Cloud Infrastructure REST APIs.
  B. You do not need access permissions to the compartment that the resource is being moved to when moving VM DB systems to a different compartment.
  C. You have to move dependent resources like Database Homes and databases to the des-tination compartment before moving the VM DB system.
  D. You can move DB systems to a different compartment if you have sufficient access permissions to the compartment that the resource is being moved to, as well as the cur- rent compartment.
  D. You can move DB systems to a different compartment if you have sufficient access permissions to the compartment that the resource is being moved to, as well as the cur- rent compartment.

• Question 42:

  What is the Oracle recommended way to upgrade databases?

  A. Database Upgrade Assistant (DBUA)
  B. Data Pump Export/Import
  C. Command Line Upgrade
  D. AutoUpgrade
  D. AutoUpgrade

• Question 43:

  Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI) re- sources? (Choose all correct answers)

  A. Secure Shell (SSH)
  B. Remote Desktop Protocol (RDP)
  C. Serial console connection (SCC)
  D. OCI REST APIs
  E. OCI Command-line Interface (CLI)
  D. OCI REST APIs
  E. OCI Command-line Interface (CLI)

• Question 44:

  Which three are prerequisites for using the MySQL Database Service? (Choose all correct answers)

  A. You must create a tenancy and be able to sign in to it
  B. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.
  C. You or your group must be granted the policies described in Mandatory Policies.
  D. You must download the latest MySQL version from https://edelivery.oracle.com/ You must create a compartment to store your resources
  A. You must create a tenancy and be able to sign in to it
  C. You or your group must be granted the policies described in Mandatory Policies.
  D. You must download the latest MySQL version from https://edelivery.oracle.com/ You must create a compartment to store your resources

• Question 45:

  Which three data file formats can be loaded using Oracle Database Actions? (Choose all cor-rect answers)

  A. JSON
  B. AVRO
  C. CSV
  D. VSAM
  E. Continue
  F. Retake test
  A. JSON
  B. AVRO
  C. CSV

• Question 46:

  What information is required to connect to the NoSQL Database Cloud Service?

  A. API signing key, admin ID, user ID
  B. signing key fingerprint, API signing key, tenancy OCID
  C. user ID, tenancy ID, component ID
  D. tenancy ID, passphrase, handshake key
  B. signing key fingerprint, API signing key, tenancy OCID

• Question 47:

  The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse so- lution. What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?

  A. View of data for discovery
  B. Data Warehouse
  C. Source of managed services
  D. Analytic environments
  A. View of data for discovery

• Question 48:

  The Demand Side is data that is active and does something. What two data services are typi-cally part of the demand side? (Choose all correct answers)

  A. Inert algorithms
  B. Authorization
  C. Payloads
  D. Data Models
  C. Payloads
  D. Data Models

• Question 49:

  Which two statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers)

  A. HeatWave data which is needed for analytic processing is stored in disk files.
  B. HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs.
  C. HeatWave uses periodic long-running ETL batch jobs to refresh the data.
  D. HeatWave is a in-memory, query-processing engine designed for fast execution of ana- lytic queries.
  B. HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs.
  D. HeatWave is a in-memory, query-processing engine designed for fast execution of ana- lytic queries.

• Question 50:

  What is the primary goal of Oracle Maximum Availability Architecture for customer systems?

  A. Scale out, application availability and protection
  B. Active Replication, Data Protection and continuous availability
  C. Continuous Availability, network security and failover
  D. Data Protection, access and reporting
  B. Active Replication, Data Protection and continuous availability