[2024年07月]更新のOracle 1z0-1105-23試験基本問題には解答が付きます
2024年最新の実際に出るOracle 1z0-1105-23試験問題集と解答
質問 # 46
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
- A. All database compute nodes of the VM cluster are up and running.
- B. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of patching processes.
- C. Oracle Clusterware is down on the VM cluster.
- D. The required patch is available on the Control Plane server.
正解：C
解説：
This statement is not a prerequisite for patching Grid Infrastructure or database homes when using the console. According to the Oracle documentation8, "Before you patch Grid Infrastructure or database homes, ensure that the following prerequisites are met: All database compute nodes of the VM cluster are up and running. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of patching processes. The required patch is available on the Control Plane server." This means that Oracle Clusterware must be up and running on the VM cluster before patching, not down.
質問 # 47
Which two statements about ORDS are true? (Choose all correct answers)
- A. ORDS stores, manages and indexes JSON documents
- B. ORDS creates servlets for the Data Dictionary
- C. ORDS makes REST APIs in the Oracle Database available.
- D. ORDS is a low code development platform to build responsive applications.
正解：B、C
解説：
ORDS makes REST APIs in the Oracle Database available is a true statement about ORDS. According to the Oracle FAQ page4, "ORDS is a Java application that enables developers with SQL and database skills to develop REST APIs for the Oracle Database, the Oracle Database 12c JSON Document store, and the Oracle NoSQL Database." ORDS is not a low code development platform, nor does it store, manage or index JSON documents. ORDS also does not create servlets for the Data Dictionary.
質問 # 48
How can the goal of scale out high availability be achieved?
- A. By provisioning nodes with Real Application Clusters
- B. By implementing Flashback
- C. By implementing Active Data Guard
- D. By using the Zero Data Loss Recovery Appliance
正解：A
解説：
The goal of scale out high availability can be achieved by provisioning nodes with Real Application Clusters (RAC). According to the Oracle documentation6, "Oracle Real Application Clusters (RAC) enables you to scale out your database by adding nodes as needed without changing your application code. RAC also provides high availability by automatically recovering from node failures." RAC allows multiple instances of Oracle Database to run on different servers while accessing a shared set of data files.
質問 # 49
Exadata is the integration of the software and hardware and is available to customers on which deployments?
- A. only in a hybrid cloud
- B. in the Oracle Cloud and customer site
- C. only in public cloud environments
- D. only at the customer site
正解：B
質問 # 50
Which three are prerequisites for using the MySQL Database Service? (Choose all correct answers)
- A. You must download the latest MySQL version from https://edelivery.oracle.com/
- B. You or your group must be granted the policies described in Mandatory Policies.
- C. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.
- D. You must create a tenancy and be able to sign in to it
正解：A、B、D
解説：
You must create a compartment to store your resources
質問 # 51
Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) work-flows?
- A. SQLcl (including Liquibase)
- B. Database Actions (including real time SQL monitor)
- C. ADB console (including Performance Hub)
- D. SQL Developer (including ADB wallet)
正解：A
質問 # 52
What are two important reasons to upgrade and patch? (Choose all correct answers)
- A. Security
- B. Support Compliance
- C. Validation of application
- D. Restructure the database
正解：A、B
解説：
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."
質問 # 53
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. Big Data Service
- B. NoSQL Service
- C. Autonomous Database
- D. OCI Data Flow
正解：B
解説：
NoSQL Service does not provide data processing on OCI Lakehouse. According to the Oracle website5, "Oracle Lakehouse provides extensive data processing capabilities, to accommodate the migration of existing architectures or the creation of new, agile ones. You can use Autonomous Database for SQL processing; Big Data Service for Hadoop/Spark processing; OCI Data Flow for serverless Spark processing; and OCI Data Integration for data movement." NoSQL Service is a fully managed database service that provides fast and predictable performance for simple queries on flexible schemas.
質問 # 54
The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse so-lution. What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?
- A. Source of managed services
- B. Analytic environments
- C. Data Warehouse
- D. View of data for discovery
正解：D
解説：
View of data for discovery is the level of data detail that Data Catalog provides when integrated with Autonomous Databases and Object storage. According to the Oracle documentation6, "Oracle Cloud Infrastructure Data Catalog is a fully managed, self-service data discovery and governance solution for your enterprise data. Data Catalog helps you maximize the value of your data assets by providing a rich set of capabilities that enable you to discover, explore, organize, enrich, and trace data lineage on various types of data sources." Data Catalog provides a view of data for discovery by using metadata to create an informative and searchable inventory of all data assets in an organization.
質問 # 55
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. Authorization
- B. Payloads
- C. Data Models
- D. Inert algorithms
正解：B、C
質問 # 56
When Customers are using the Exadata Cloud Service, what are they responsible fo managing?
- A. Databases and Customer VM
- B. Host VM and Storage
- C. Hypervisor and Internal Fabric
- D. Internal Fabric and Customer VMs
正解：A
解説：
Customers are responsible for managing databases and customer VMs when they are using the Exadata Cloud Service. According to the Oracle documentation7, "Customers have full control over their databases running on Exadata Cloud Service, including root access for database servers." Additionally, according to the Oracle documentation8, "Customers can create customer VMs on Exadata Cloud Service database servers for their own use."
質問 # 57
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. Upgrade compliance
- B. Low Latency
- C. Connection to other multicloud environments
- D. Unified identity and access management
正解：B、D
解説：
These are two benefits that the partnership and interconnect between Oracle Cloud and Microsoft Azure provide. According to the Oracle website1, the partnership enables the following benefits:
A secure intercloud connection that bypasses the public internet
High availability and reliability through redundant 10-Gbps physical connections Predictable cross-cloud network performance One time setup without the need for any intermediate network provider Unified identity and access management platform that leads to cost savings The unified identity and access management platform allows customers to use a single identity provider to access resources in both clouds, simplifying the authentication and authorization process. The low latency is achieved by the direct interconnection between the two clouds, which provides less than two seconds of latency for superior multicloud network performance2.
質問 # 58
Which three can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer?
- A. amount of database OCPUs required
- B. size of the shared global area (SGA) to use
- C. client network
- D. workload type
- E. amount of database storage required
正解：A、D、E
解説：
These are three options that can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer. According to the Oracle documentation1, "When you create an Autonomous Database on Autonomous Exadata Cloud@Customer, you specify the following information: Database name, Database display name, Workload type, Admin password, License type, Number of OCPUs, Storage (TB), and Tags (optional)." The workload type can be either transaction processing or data warehouse.
質問 # 59
You have stopped the HeatWave cluster. Which two statements are correct?
- A. The HeatWave cluster data will remain loaded.
- B. The data loaded in HeatWave cluster memory is lost.
- C. Billing will stop for the HeatWave cluster.
- D. Billing will continue for the HeatWave cluster.
- E. The HeatWave cluster stop action will also stop DB Syster
正解：B、E
質問 # 60
Which is NOT a resource type for NoSQL Database Cloud Service?
- A. Nosql-tables
- B. Nosql-keys
- C. Nosql-rows
- D. Nosql-indexes
正解：B
解説：
Nosql-keys is not a resource type for NoSQL Database Cloud Service. According to the Oracle documentation, "Oracle NoSQL Database Cloud Service supports three resource types: nosql-tables, nosql-rows, and nosql-indexes. These resource types are used to define policies that control access to NoSQL tables and data."
質問 # 61
What security control area determines if there is sensitive data in a system?
- A. Protect
- B. Assess
- C. Detect
- D. Users
正解：B
解説：
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."
質問 # 62
What is a prerequisite of running APEX on an Autonomous Database?
- A. An Autonomous Database with the workload type Data Warehouse, Transaction Pro-cessing, JSON or APEX.
- B. A DBA must enable ORDS first.
- C. APEX can simply be installed by downloading the executable from OTN.
- D. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.
- E. APEX can only be used when selecting APEX as a workload when provisioning an Au-tonomous Database.
正解：A
解説：
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)."
質問 # 63
Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?
- A. Oracle Key Vault
- B. Oracle Native Network Encryption and TDE (Transparent Data Encryption)
- C. Database Vault and Data Masking Pack
- D. Audit Vault and Database Firewall
正解：B
解説：
Oracle Native Network Encryption and TDE are security measures that are implemented out-of-the-box, and are included if you are not using BYOL licensing with Exadata Cloud@Customer. According to the Oracle documentation5, "Oracle Native Network Encryption encrypts all data sent over the network between database clients and servers using industry-standard encryption algorithms." Additionally, according to the Oracle documentation6, "Transparent Data Encryption (TDE) enables you to encrypt sensitive data, such as credit card numbers, stored in tables and tablespaces."
質問 # 64
What information is required to connect to the NoSQL Database Cloud Service?
- A. API signing key, admin ID, user ID
- B. signing key fingerprint, API signing key, tenancy OCID
- C. tenancy ID, passphrase, handshake key
- D. user ID, tenancy ID, component ID
正解：B
解説：
Signing key fingerprint, API signing key, and tenancy OCID are the information required to connect to the NoSQL Database Cloud Service. According to the Oracle documentation, "To connect your application to Oracle NoSQL Database Cloud Service , obtain your credentials such as the client ID, client secret, and the entitlement ID from the Identity Cloud Service console. After obtaining the credentials, pass the credentials to your application and create tables in Oracle NoSQL Database Cloud Service." The client ID is also known as the signing key fingerprint, and the client secret is also known as the API signing key. The tenancy OCID is a unique identifier for your Oracle Cloud account.
質問 # 65
Which three data file formats can be loaded using Oracle Database Actions? (Choose all cor-rect answers)
- A. AVRO
- B. VSAM
- C. CSV
- D. JSON
- E. Retake test
- F. Continue
正解：A、C、D
質問 # 66
What is NOT a workload that can be selected when provisioning an Autonomous Database?
- A. MySQL
- B. Data Warehouse
- C. JSON
- D. APEX
正解：A
質問 # 67
When should you change COMPATIBLE?
- A. After upgrades
- B. After database downgrades
- C. After patching
- D. When the database is stopped
正解：A
解説：
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.
質問 # 68
Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?
- A. OCI Block Volumes
- B. OCI Object Storage
- C. OCI Data Safe
- D. OCI File Storage
正解：A
解説：
OCI Block Volumes is the service used by default by the MySQL Database Service to store user data to make it more resistant to failures. OCI Block Volumes provides high-performance block storage volumes that can be attached to MySQL DB systems running on OCI Compute instances. Block volumes are always encrypted at rest using AES-256 encryption keys. Block volumes also support backup and restore operations using snapshots or clones that can be used for disaster recovery or testing purposes.
質問 # 69
Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure re-sources?
- A. Tenancy
- B. Identity and Access Management Groups
- C. Availability Domain
- D. Compartments
正解：D
解説：
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."
質問 # 70
......
合格保証付きのOracle Cloud 1z0-1105-23試験問題集：https://jp.fast2test.com/1z0-1105-23-premium-file.html