[Oct-2023] Exam Sure Pass Oracle Certification with 1z0-1105-23 exam questions
Real Oracle 1z0-1105-23 Exam Questions Study Guide
Oracle 1z0-1105-23 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION # 37
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?
- A. Open the database in OCI Console and increase the number of OCPU. No downtime required.
- B. Plan for a one-hour downtime and increase the number of OCPU while database is of-fline.
- C. Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour.
- D. 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.
Answer: A
Explanation:
This option is the correct way to increase the number of OCPU assigned to an Autonomous Database. According to the Oracle documentation2, "You can scale your Autonomous Database on demand by adding CPU cores or storage. You can also enable auto scaling to allow your Autonomous Database to automatically use up to three times more CPU and IO resources than its allocated CPU core count." The scaling operation does not require any downtime or affect the availability of the database.
NEW QUESTION # 38
Which statement is true about MySQL Database Service?
- A. It is a public cloud service built on MySQL Community Edition.
- B. It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.
- C. Its users are responsible for database and operating system patching tasks.
- D. It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
Answer: D
Explanation:
This statement is true about MySQL Database Service. According to the Oracle documentation3, "MySQL Database Service is a fully managed Oracle Cloud Infrastructure native service, developed, managed, and supported by the MySQL team in Oracle. Oracle automates tasks such as backup and recovery, and database and operating system patching. You are responsible solely for managing your data, schema designs, and access policies."
NEW QUESTION # 39
Which two locations can be used to store your DB system database backups? (Choose all cor-rect answers)
- A. You can store your DB system database backups on locally attached block storage vol-umes.
- B. You can store your DB system database backups locally in the Fast Recovery Area of the DB system.
- C. You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.
- D. You can store your DB system database backups in on-premises local storage.
Answer: C,D
NEW QUESTION # 40
Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?
- A. Exadata DB Systems
- B. Autonomous Data Warehouse
- C. Compute
- D. Monitoring
Answer: A
Explanation:
Exadata DB Systems is an OCI service that is NOT available as part of Oracle Cloud Free Tier. According to the Oracle website5, "Oracle Cloud Free Tier includes a free time-limited promotional trial that allows you to explore a wide range of Oracle Cloud Infrastructure products, and a set of Always Free offers that never expire." The list of eligible services for the Free Tier does not include Exadata DB Systems, which is a high-performance database platform that runs on OCI6.
NEW QUESTION # 41
The Demand Side is data that is active and does something. What two data services are typi-cally part of the demand side? (Choose all correct answers)
- A. Inert algorithms
- B. Authorization
- C. Data Models
- D. Payloads
Answer: C,D
NEW QUESTION # 42
What is a prerequisite of running APEX on an Autonomous Database?
- A. APEX can only be used when selecting APEX as a workload when provisioning an Au-tonomous Database.
- B. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.
- C. A DBA must enable ORDS first.
- D. An Autonomous Database with the workload type Data Warehouse, Transaction Pro-cessing, JSON or APEX.
- E. APEX can simply be installed by downloading the executable from OTN.
Answer: D
Explanation:
An Autonomous Database with the workload type Data Warehouse, Transaction Processing, JSON or APEX is a prerequisite of running APEX on an Autonomous Database. According to the Oracle documentation, "Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure apps with world-class features that can be deployed anywhere. APEX is preconfigured and fully managed in Oracle Autonomous Database (ADB). You can use APEX on any Autonomous Database workload type: Data Warehouse (ADW), Transaction Processing (ATP), JSON (AJD), or APEX (APEX)."
NEW QUESTION # 43
What are two characteristics of CI/CD?
- A. It requires Liquibase
- B. Development changes are automatically V tested on push/commits and merges.
- C. It introduces automation into all stages of app/database development.
- D. It prevents developers from merging their code changes back to the shared branch for security.
Answer: B,C
Explanation:
These are two characteristics of CI/CD, which is a set of practices that automate the building, testing, and deployment stages of software development. According to the Red Hat website9, "CI/CD introduces ongoing automation and continuous monitoring throughout the lifecycle of apps, from integration and testing phases to delivery and deployment." This means that CI/CD aims to reduce manual tasks and increase efficiency and reliability across the development life cycle. According to the IBM blog10, "Continuous integration (CI) is an automation process for developers. Successful CI means new code changes to an app are regularly built, tested, and merged to a shared repository." This means that CI/CD enables developers to integrate their code changes frequently and automatically, ensuring code quality and consistency.
NEW QUESTION # 44
The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side?
- A. Reports
- B. Domain objects
- C. Technical definitions of business terms
- D. Business rules
Answer: B,D
NEW QUESTION # 45
Which tool allows users to execute SQL statements, create relational models, load data, and monitor SQL queries from your browser?
- A. Enterprise Manager
- B. SQL Developer
- C. Service Console
- D. Database Actions
- E. OCI Operational Insights
Answer: B
NEW QUESTION # 46
Which three are prerequisites for using the MySQL Database Service? (Choose all correct answers)
- A. You or your group must be granted the policies described in Mandatory Policies.
- B. You must create a tenancy and be able to sign in to it
- C. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.
- D. You must download the latest MySQL version from https://edelivery.oracle.com/
Answer: A,B,D
Explanation:
You must create a compartment to store your resources
NEW QUESTION # 47
When should you change COMPATIBLE?
- A. After database downgrades
- B. When the database is stopped
- C. After patching
- D. After upgrades
Answer: D
Explanation:
Changing COMPATIBLE after upgrades is one of the scenarios when you should change COMPATIBLE. According to the Oracle blog post7, "COMPATIBLE needs to be adjusted only once after you completed your last database upgrade." The blog post also explains that changing COMPATIBLE requires a restart of the database and that it should not be changed before upgrades or patching or after downgrades.
NEW QUESTION # 48
Which workload CANNOT be run on Oracle Database 19c?
- A. Machine Learning
- B. Translytical
- C. Hadoop Clusters
- D. Gaming
Answer: C
Explanation:
Hadoop clusters cannot be run on Oracle Database 19c. Hadoop is a framework for distributed processing of large data sets across clusters of computers using simple programming models. Oracle Database 19c is a relational database management system that supports SQL and PL/SQL queries and transactions. Hadoop clusters require a different architecture and storage model than Oracle Database 19c. Oracle Database 19c does not support the Hadoop Distributed File System (HDFS) or the MapReduce programming model.
NEW QUESTION # 49
What are two important reasons to upgrade and patch? (Choose all correct answers)
- A. Validation of application
- B. Security
- C. Restructure the database
- D. Support Compliance
Answer: B,D
Explanation:
Security and support compliance are two important reasons to upgrade and patch your Oracle Database. According to the Oracle blog3, "Security is one of the most important reasons to patch your database. Every quarter Oracle releases security patches as part of the Critical Patch Update (CPU) program. These patches fix vulnerabilities in the database software that could be exploited by malicious attackers." Additionally, according to the Oracle blog4, "Support compliance is another reason to patch your database. Oracle provides different levels of support for different versions of the database software. To be eligible for certain support services, such as Extended Support or Sustaining Support, you need to apply the latest patches available for your version."
NEW QUESTION # 50
Exadata is the integration of the software and hardware and is available to customers on which deployments?
- A. only in public cloud environments
- B. in the Oracle Cloud and customer site
- C. only in a hybrid cloud
- D. only at the customer site
Answer: B
NEW QUESTION # 51
NoSQL Database Cloud Service supports all three types of big data.
Which is NOT considered big data?
- A. structured data
- B. free-structured data
- C. unstructured data
- D. semi-structured data
Answer: A
NEW QUESTION # 52
Which three data file formats can be loaded using Oracle Database Actions? (Choose all cor-rect answers)
- A. Retake test
- B. Continue
- C. VSAM
- D. CSV
- E. JSON
- F. AVRO
Answer: D,E,F
NEW QUESTION # 53
In order to support multicloud strategies, what is offered as an industry first by Oracle?
- A. Private and public cloud network
- B. Oracle FastConnect
- C. Cloud databases
- D. Dedicated cloud region
Answer: B
NEW QUESTION # 54
Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure re-sources?
- A. Tenancy
- B. Availability Domain
- C. Compartments
- D. Identity and Access Management Groups
Answer: C
Explanation:
Compartments are a feature that allows you to logically group and isolate your Oracle Cloud Infrastructure resources. According to the Oracle documentation2, "Compartments are a fundamental component of Oracle Cloud Infrastructure that allow you to create a heterogeneous collection of resources for organization, security isolation, and access control. To learn more about compartments, see Managing Compartments . Organize your cloud resources in logically separate compartments, for the purposes of measuring usage and billing, controlling access, and isolating resources."
NEW QUESTION # 55
Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud? (Choose all correct answers)
- A. Exadata Cloud Service
- B. Compute VM
- C. Autonomous Database
- D. Streaming Service
Answer: A,C
Explanation:
Exadata Cloud Service and Autonomous Database are two target database environments that provide both high availability (HA) and disaster recovery (DR) options in the cloud. Exadata Cloud Service is a fully managed Oracle Database service that runs on Exadata infrastructure in the cloud. It offers high performance, scalability, availability, security, and reliability for all types of database workloads. It also supports various HA and DR options, such as Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle Active Data Guard, Oracle GoldenGate, and Oracle Zero Data Loss Recovery Appliance Cloud Service. Autonomous Database is a self-driving, self-securing, and self-repairing cloud database service that automates provisioning, configuring, securing, tuning, scaling, patching, backing up, and repairing of databases without human intervention. It also provides built-in HA and DR features based on Oracle Maximum Availability Architecture (MAA), such as transparent application continuity, automatic failover to standby databases or regions, automatic backups to object storage, point-in-time recovery using restore points or backups.
NEW QUESTION # 56
What security control area determines if there is sensitive data in a system?
- A. Protect
- B. Detect
- C. Users
- D. Assess
Answer: D
Explanation:
Assess is the security control area that determines if there is sensitive data in a system. According to the Oracle documentation2, "The Assess security control area includes activities that help you identify and classify sensitive data, assess your security posture, and monitor compliance with security standards and regulations."
NEW QUESTION # 57
After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?
- A. If d VM DB system requires more block storage, increase the storage at any time without impacting the system.
- B. After you have provisioned a VM DB system, you cannot increase or decrease block storage.
- C. Only bare metal DB systems can increase block storage at any time without impacting the system.
- D. If a VM DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system.
Answer: B
NEW QUESTION # 58
......
Updated and Accurate 1z0-1105-23 Questions for passing the exam Quickly: https://exams4sure.briandumpsprep.com/1z0-1105-23-prep-exam-braindumps.html
