1Z0-1105-22 Online Practice Questions and Answers

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

A. Data Warehouse

B. MySQL

C. APEX

D. JSON

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

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

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;

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.

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

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

Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud. Which two are also benefits this partnership and interconnect provide? (Choose all correct answers)

A. Unified identity and access management

B. Connection to other multicloud environments

C. Upgrade compliance

D. Low Latency

Which Lakehouse service should you use for serverless Spark processing?

A. OCI Data Flow

B. Oracle Analytics Cloud

C. OCI Object Storage

D. OCI Data Catalog

What are two important reasons to upgrade and patch? (Choose all correct answers)

A. Restructure the database

B. Security

C. Validation of application

D. Support Compliance