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

Oracle 1Z0-1105-22 Online Questions & Answers

• Question 1:

  Which is NOT an option in Database Actions to load data into Autonomous Database?

  A. Load data from a local file such as text or Excel
  B. Load data using FTP
  C. Load data from cloud storage (Oracle, S3, Azure, Google)
  D. Load data from a remote database
  E. Load data using Data Pump
  B. Load data using FTP

• Question 2:

  What is NOT a workload that can be selected when provisioning an Autonomous Database?

  A. Data Warehouse
  B. MySQL
  C. APEX
  D. JSON
  B. MySQL

• Question 3:

  What connections to multiple public clouds are provided through 3rd party connectivity?

  A. Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC)
  B. Layer 3 and FastConnect
  C. Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPC)
  D. FastConnect and Direct Connect
  C. Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPC)

• Question 4:

  Multicloud strategy eliminates the reliance of a single cloud provider but also provides which two advantages? (Choose all correct answers)

  A. Ability to have private clouds and maintain customer data centers
  B. Compliance for use of specific geographies for data sovereignty laws
  C. Duplication of data and applications
  D. Workload utilization of specific services
  B. Compliance for use of specific geographies for data sovereignty laws
  D. Workload utilization of specific services

• Question 5:

  What are two characteristics of Oracle SQLcl (SQL Developer Command Line)? (Choose all correct answers)

  A. Tracks database schema changes
  B. Creates isolated development environments
  C. Available in the OCI Cloud Shell by default
  D. Ability to execute SQL batch files
  A. Tracks database schema changes
  D. Ability to execute SQL batch files

• Question 6:

  What set of NoSQL-style APIs can be used in Autonomous JSON Database?

  A. SODA (Simple Oracle Document Access)
  B. OASD (Oracle Application Storage Definition)
  C. OSDA (Oracle Simple Document Access)
  D. DOSA (Document Open Solution Access)
  A. SODA (Simple Oracle Document Access)

• Question 7:

  Which two are objectives of Oracle's Data Management strategy? (Choose all correct answers)

  A. Offer multiple integration points for 3rd party databases that work better for mixed and analytic workloads.
  B. Automate everything for developers, data analysts, DBAs and data scientists.
  C. Provide for the fastest, most scalable converged SQL database.
  D. Provide the best platform for warehouse workloads only.
  A. Offer multiple integration points for 3rd party databases that work better for mixed and analytic workloads.
  B. Automate everything for developers, data analysts, DBAs and data scientists.

• Question 8:

  Which two are key characteristics of Oracle Autonomous Database? (Choose all correct an-swers)

  A. Oracle manages everything
  B. Less automated
  C. Higher cost
  D. Customer manages everything
  E. Lower cost
  A. Oracle manages everything
  E. Lower cost

• Question 9:

  Oracle and Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which is an example of an in-database option?

  A. Tuning of hyperparameter
  B. Oracle Machine Learning for Python (OML4Py) APIs
  C. REST Interface
  D. Cognitive text
  B. Oracle Machine Learning for Python (OML4Py) APIs

• Question 10:

  Which two statements about ORDS are true? (Choose all correct answers)

  A. ORDS is a low code development platform to build responsive applications.
  B. ORDS stores, manages and indexes JSON documents
  C. ORDS makes REST APIs in the Oracle Database available.
  D. ORDS creates servlets for the Data Dictionary
  C. ORDS makes REST APIs in the Oracle Database available.
  D. ORDS creates servlets for the Data Dictionary