Oracle Oracle Certifications 1Z0-1105-22 Questions & Answers

• Question 41:

  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

  Correct Answer: AE

• Question 42:

  Which deployment option provides the highest degree of security and governance while providing a completely self-service database experience?

  A. Oracle MySQL Database Service

  B. Oracle Autonomous Database

  C. Oracle Database Cloud Service

  D. Exadata Cloud Service

  Correct Answer: D

• Question 43:

  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

  Correct Answer: D

• Question 44:

  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

  Correct Answer: CD

• Question 45:

  Which statement can be detected by monitoring of access to sensitive data?

  A. SELECT SYSDATE from DUAL;

  B. CREATE index emp_id_idx on EMPLOYEES(emp_id);

  C. UPDATE quarter_reference set Q1='012022'

  D. SELECT * from EMPLOYEES;

  Correct Answer: D

• Question 46:

  Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?

  A. OCI Object Storage

  B. OCI File Storage

  C. OCI Block Volumes

  D. OCI Data Safe

  Correct Answer: C

• Question 47:

  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

  Correct Answer: ABC

• Question 48:

  Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?

  A. Audit Vault and Database Firewall

  B. Oracle Native Network Encryption and TDE (Transparent Data Encryption)

  C. Oracle Key Vault

  D. Database Vault and Data Masking Pack

  Correct Answer: B

• Question 49:

  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.

  Correct Answer: AB

• Question 50:

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

  A. Nosql-keys

  B. Nosql-indexes

  C. Nosql-rows

  D. Nosql-tables

  Correct Answer: A