Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. Oracle Cloud Infrastructure
  4. 1z0-1105-22 - Oracle Cloud Data Management 2022 Foundations Associate

Oracle 1z0-1105-22 Oracle Cloud Data Management 2022 Foundations Associate Exam Practice Test

Demo: 8 questions
Total 55 questions
Get 1z0-1105-22 Full Access Download 1z0-1105-22 PDF

Oracle Cloud Data Management 2022 Foundations Associate Questions and Answers

Question 1

Which statement is true about MySQL Database Service?

Options:

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.

Question 2

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

Options:

A.

Data Warehouse

B.

MySQL

C.

APEX

D.

JSON

Question 3

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)

Options:

A.

Unified identity and access management

B.

Connection to other multicloud environments

C.

Upgrade compliance

D.

Low Latency

Question 4

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

Options:

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.

Question 5

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

Options:

A.

JSON

B.

AVRO

C.

CSV

D.

VSAM

E.

Continue

F.

Retake test

Question 6

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

Options:

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;

Question 7

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

Options:

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

Question 8

What are three platforms where Oracle's Autonomous Database service can be deployed? (Choose all correct answers)

Options:

A.

Oracle Public Cloud at Customer

B.

Oracle Cloud Infrastructure

C.

Dedicated Region Cloud at Customer

D.

Hybrid Cloud Configurations

E.

AWS Cloud at Customer

Load More 1z0-1105-22 Questions
Demo: 8 questions
Total 55 questions
Get 1z0-1105-22 Full Access Download 1z0-1105-22 PDF