News

  1. Home
  2. All posts
All posts, Cloud, Oracle by Team Ajara

OCI Foundations Associate Dumps 1Z0-1105-23 s2

Oracle Cloud Data Management 2023 Foundations Associate (1Z0-1105-23).

Oracle Cloud Data Management 2023 Foundations Associate

 

Question 

Q1)

What information is required to connect to the NoSQL Database Cloud Service? 

  • A) API signing key, admin ID, user ID
  • B) tenancy ID, passphrase, handshake key
  • C) user ID, tenancy ID, component ID
  • D) signing key fingerprint, API signing key, tenancy OCID

Answer : D

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q2

 Q 2) A customer is looking to migrate their old database backups from their on-premises data center to Oracle Cloud Infrastructure (OCI).

Which OCI service is the most cost-effective?

  • A) File Storage
  • B) Block Volume
  • C) Archive Storage
  • D) Object Storage (standard)

Answer: C

Explanation:

Try Oracle Cloud Free Tier

Archive Storage

Long-term, low cost data storage

Customers trust Oracle Cloud Infrastructure (OCI) Archive Storage to securely store any type of data in its native format. This cost-effective solution is highly durable and used for storing and managing encrypted data for long periods of time

https://www.oracle.com/in/cloud/storage/archive-storage/#:~:text=Customers%20trust%20Oracle%20Cloud%20Infrastructure,for%20long%20periods%20of%20time

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q3

Q 3) Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?

  • A) The /u01 directory on the database host file system has at least 15 GB of free space for the execution of patching processes.
  • B) Oracle Clusterware is down on the VM cluster.
  • C) All database compute nodes of the VM cluster are up and running.
  • D) The required patch is available on the Control Plane server.

Answer: B

Explaination:

Oracle Clusterware should be up  on the VM cluster.

The prerequisites-checking operation:

  • Confirms that the patch is available for download.
  • Confirms connectivity to the required compute nodes.
  • Verifies that there is enough space to apply the patch.
  • Runs additional commands to validate that the specific patch requirements are met.

More Details can be found from below link.

https://docs.oracle.com/en/cloud/cloud-at-customer/exadata-cloud-at-customer/exacc/check-patch-prereqs.html#GUID-34608C02-9F7C-455A-BBC1-1F2AD90E33EE

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q4

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

  • A) JSON
  • B) APEX
  • C) Data Warehouse
  • D) MySQL

 Answer: D

Explanation:

MySQL is NOT a workload that can be selected when provisioning an Autonomous Database.

 

For more details:

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#:~:text=Oracle%20Autonomous%20Database%20Serverless%20provides,mixed%2C%20APEX%2C%20and%20JSON

For more info :

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-add-resources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q5

Q 5) What are two characteristics of Oracle SQLCI (SQL Developer Command Line)?

  • A) Creates isolated development environments
  • B) Available in the OCI Cloud Shell by default
  • C) Tracks database schema changes
  • D) Ability to execute SQL batch files

Answer: B,D

Explanation:

Oracle SQLcl (SQL Developer Command Line) is a Java-based command-line interface for Oracle Database. Using SQLcl, you can interactively or batch execute SQL and PL/SQL statements. SQLcl provides inline editing, statement completion, command recall, and also supports existing SQL*Plus scripts.

For more details follow below link.

https://docs.oracle.com/en/database/oracle/sql-developer-command-line/19.2/sqcug/working-sqlcl.html#GUID-1343FA2B-BDB4-4645-B4D4-CD7C3E200AC9

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q6

Q6) Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI) resources?

  • A) Serial console connection (SCC)
  • B) OCI REST APIs
  • C) Secure Shell (SSH)
  • D) Remote Desktop Protocol (RDP)
  • E) OCI Command-line Interface (CLI)

Answer: B,E

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q7

Q7) Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?

  • A) Exadata DB Systems
  • B) Monitoring
  • C) Compute
  • D) Autonomous Data Warehouse

Answer: A

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q8

Q8) Which three are prerequisites for using the MySQL Database Service?

  • A) You must create a compartment to store your resources.
  • B) You must create a tenancy and be able to sign in to it.
  • C) You or your group must be granted the policies described in Mandatory Policies.
  • D) You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.
  • E) You must download the latest MySQL version from https://edelivery.oracle.com/.

Answer: A,B,C

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q9

Q9)Oracle Lakehouse provides extensive data processing capabilities, to accommodate the migration of existing architectures or the creation of new, agile ones. Which service does NOT provide data processing on Oracle Cloud Infrastructure (OCI) Lakehouse?

  • A) Autonomous Database
  • B) Big Data Service
  • C) OCI Data Flow
  • D) NoSQL Service

Answer: C

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q10

Q10) What are two characteristics of CI/CD?

  • A) It requires Liquibase
  • B) It prevents developers from merging their code changes back to the shared branch for security.
  • C) Development changes are automatically tested on push/commits and merges.
  • D) It introduces automation into all stages of app/database development.

Answer: C,D

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

Question 

Q11

Q11) NoSQL Database Cloud Service supports all three types of big data.

Which is NOT considered big data?

  • A) free-structured data
  • B) unstructured data
  • C) structured data
  • D) semi-structured data

Answer: A

For more Questions: OCI Foundations Associate Dumps 1Z0-1105-23

 

 

See also:

All Questions in Sequence: