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

Oracle 1Z0-1105-22 Online Questions & Answers

• Question 31:

  The DBA has determined that number of OCPU assigned to an Autonomous Database does not provide sufficient performance. Which option does the DBA have in this case?

  A. Open the database in OCI Console and increase the number of OCPU. No downtime required.
  B. No downtime is required as number of OCPU can be increased from OCI console, but users have to be informed that they must not use any application for at least one hour.
  C. Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour.
  D. Plan for a one-hour downtime and increase the number of OCPU while database is of- fline.
  A. Open the database in OCI Console and increase the number of OCPU. No downtime required.

• Question 32:

  What is the FINAL release supporting the non-CDB architecture?

  A. Oracle Database 23c
  B. Oracle Database 21c
  C. Oracle Database 18c
  D. Oracle Database 19c
  D. Oracle Database 19c

• Question 33:

  Which is NOT a resource type for NoSQL Database Cloud Service?

  A. Nosql-keys
  B. Nosql-indexes
  C. Nosql-rows
  D. Nosql-tables
  A. Nosql-keys

• Question 34:

  Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability helps you to organize multiple users into teams?

  A. Users
  B. Roles
  C. Policies
  D. Groups
  D. Groups

• Question 35:

  Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud? (Choose all correct answers)

  A. Streaming Service
  B. Compute VM
  C. Exadata Cloud Service
  D. Autonomous Database
  C. Exadata Cloud Service
  D. Autonomous Database

• Question 36:

  What are two main benefits of Oracle APEX? (Choose all correct answers)

  A. Rapidly develop, customize, and deliver secure applications
  B. Store data in PL/SQL objects
  C. Faster development time using hand coding
  D. Less productivity compared to hand coding
  E. Develop responsive web apps
  A. Rapidly develop, customize, and deliver secure applications
  E. Develop responsive web apps

• Question 37:

  Which statement is true about MySQL Database Service?

  A. Its users are responsible for database and operating system patching tasks.
  B. It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.
  C. It is a public cloud service built on MySQL Community Edition.
  D. It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
  D. It is a fully managed Oracle Cloud Infrastructure (OCI) native service.

• Question 38:

  What is a prerequisite of running APEX on an Autonomous Database?

  A. A DBA must enable ORDS first.
  B. APEX can simply be installed by downloading the executable from OTN.
  C. APEX can only be used when selecting APEX as a workload when provisioning an Au- tonomous Database.
  D. An Autonomous Database with the workload type Data Warehouse, Transaction Pro- cessing, JSON or APEX.
  E. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.
  D. An Autonomous Database with the workload type Data Warehouse, Transaction Pro- cessing, JSON or APEX.

• Question 39:

  New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?

  A. Storage Disks
  B. Database Servers
  C. Persistent Memory
  D. Compute Instances
  C. Persistent Memory

• Question 40:

  Oracle ExaC@C brings the Oracle Cloud to the customer data center. The Oracle Cloud In-frastructure is the same, but responsibilities are adjusted so that customer can perform which two tasks? (Choose all correct answers)

  A. Secure access configured to the customer network.
  B. Operator Access Control can terminate Oracle operator connections.
  C. Allow only the Oracle Staff to perform control access.
  D. Allow network connections in the Oracle public cloud.
  A. Secure access configured to the customer network.
  C. Allow only the Oracle Staff to perform control access.