[Jun 05, 2024] Fully Updated Free Actual Oracle 1z0-1105-23 Exam Questions [Q17-Q32]

Rate this post

[Jun 05, 2024] Fully Updated Free Actual Oracle 1z0-1105-23 Exam Questions

Free 1z0-1105-23 Questions for Oracle 1z0-1105-23 Exam [Jun-2024]

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

Users

Roles

Policies

Groups

QUESTION 18
What is the primary goal of Oracle Maximum Availability Architecture for customer systems?

Scale out, application availability and protection

Active Replication, Data Protection and continuous availability

Continuous Availability, network security and failover

Data Protection, access and reporting

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

Oracle Public Cloud at Customer

Oracle Cloud Infrastructure

Dedicated Region Cloud at Customer

Hybrid Cloud Configurations

AWS Cloud at Customer

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

Restructure the database

Security

Validation of application

Support Compliance

QUESTION 21
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)

Unified identity and access management

Low Latency

Upgrade compliance

Connection to other multicloud environments

QUESTION 22
Which are two characteristics of Autonomous Transaction Processing (ATP)? (Choose all correct answers)

Focuses on creation of indexes

Stores data in columnar format

Statistics are gathered as part of bulk load operations

Optimized for response time

Creates autonomous data summaries

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

A DBA must enable ORDS first.

APEX can simply be installed by downloading the executable from OTN.

APEX can only be used when selecting APEX as a workload when provisioning an Au-tonomous Database.

An Autonomous Database with the workload type Data Warehouse, Transaction Pro-cessing, JSON or APEX.

A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.

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

Data Warehouse

MySQL

APEX

JSON

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

SELECT SYSDATE from DUAL;

CREATE index emp_id_idx on EMPLOYEES(emp_id);

UPDATE quarter_reference set Q1=’012022′

SELECT * from EMPLOYEES;

QUESTION 26
Oracle Data Lakehouse streamlines the integration, storage, and processing of dat a. Which two services are used for persistence of the data in Lakehouse? (Choose all correct answers)

OCI Data Catalog

Autonomous Database

OCI Object Storage

OCI GoldenGate

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

SODA (Simple Oracle Document Access)

OASD (Oracle Application Storage Definition)

OSDA (Oracle Simple Document Access)

DOSA (Document Open Solution Access)

QUESTION 28
Where should you store unstructured, high volume data sets of unknown value for best price/performance?

OCI Data Flow

OCI Object Storage

OCI Data Catalog

OCI GoldenGate

QUESTION 29
What are the two main features of APEX’s low code platform? (Choose all correct answers)

Use traditional computer programming paradigms

Use graphical user interfaces and configuration

Focus on business requirements

Limited productivity
Build scalable web apps for MongoDB

Simplified core-based licensing

QUESTION 30
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?

Open the database in OCI Console and increase the number of OCPU. No downtime required.

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.

Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour.

Plan for a one-hour downtime and increase the number of OCPU while database is of-fline.

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

Nosql-keys

Nosql-indexes

Nosql-rows

Nosql-tables

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

Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC)

Layer 3 and FastConnect

Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPC)

FastConnect and Direct Connect

Oracle 1z0-1105-23 Exam Syllabus Topics:

Topic	Details
Topic 1	Explain the various Exadata deployment options (C@C, Cloud Service, etc) Describe the use cases and business problems Exadata solves
Topic 2	Explain Oracle’s Maximum Availability Architecture Describe various migration strategies to the cloud
Topic 3	Explain the data mesh architecture Discuss concepts and uses of OCI Analytics and AI Data Services
Topic 4	Describe MySQL Database Service Explain Oracle Cloud Free Tier Sign-up processes
Topic 5	Explain Oracle’s Maximum Security Architecture Discuss concepts and uses of Oracle Machine Learning
Topic 6	Explain Oracle’s Data Management Strategy Discuss multi-cloud and hybrid cloud options for managing data using Oracle Cloud
Topic 7	Explain JSON, graph, and spatial in the Oracle Database Explain the processes and concepts to Manage Autonomous Databases: REST, APIs