2023年最新のお手軽に合格させる1z0-1105-23試験にはこちらが提供する問題集PDFテストエンジン
1z0-1105-23のPDFで合格させるスゴ問題集で1z0-1105-23最新のリアル試験問題
Oracle 1z0-1105-23 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
質問 # 35
Which workload CANNOT be run on Oracle Database 19c?
- A. Gaming
- B. Hadoop Clusters
- C. Translytical
- D. Machine Learning
正解：B
解説：
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.
質問 # 36
Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) work-flows?
- A. SQL Developer (including ADB wallet)
- B. SQLcl (including Liquibase)
- C. ADB console (including Performance Hub)
- D. Database Actions (including real time SQL monitor)
正解：B
質問 # 37
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
- A. The required patch is available on the Control Plane server.
- 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. All database compute nodes of the VM cluster are up and running.
正解：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.
質問 # 38
What is a prerequisite of running APEX on an Autonomous Database?
- A. APEX can simply be installed by downloading the executable from OTN.
- B. An Autonomous Database with the workload type Data Warehouse, Transaction Pro-cessing, JSON or APEX.
- C. A DBA must enable ORDS first.
- D. APEX can only be used when selecting APEX as a workload when provisioning an Au-tonomous Database.
- E. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.
正解：B
解説：
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)."
質問 # 39
What set of NoSQL-style APIs can be used in Autonomous JSON Database?
- A. OASD (Oracle Application Storage Definition)
- B. OSDA (Oracle Simple Document Access)
- C. SODA (Simple Oracle Document Access)
- D. DOSA (Document Open Solution Access)
正解：C
解説：
SODA (Simple Oracle Document Access) is the set of NoSQL-style APIs that can be used in Autonomous JSON Database. According to the Oracle documentation, "SODA provides a set of APIs for various application-development languages and for RESTful web services that let you create and store collections of JSON documents in an Oracle Database without needing any knowledge of SQL or how the data is stored in the database."
質問 # 40
Which Lakehouse service should you use for serverless Spark processing?
- A. Oracle Analytics Cloud
- B. OCI Data Flow
- C. OCI Object Storage
- D. OCI Data Catalog
正解：B
解説：
OCI Data Flow is the Lakehouse service that you should use for serverless Spark processing. According to the Oracle documentation, "Oracle Cloud Infrastructure Data Flow is a fully managed big data service that lets you run Apache Spark applications with no infrastructure to deploy or manage. Data Flow lets you create, run, and manage Apache Spark applications with minimal coding and no infrastructure provisioning or management."
質問 # 41
What is NOT a workload that can be selected when provisioning an Autonomous Database?
- A. Data Warehouse
- B. MySQL
- C. JSON
- D. APEX
正解：B
質問 # 42
Which statement is true about MySQL Database Service?
- A. It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
- 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. Its users are responsible for database and operating system patching tasks.
正解：A
解説：
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."
質問 # 43
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. Payloads
- D. Data Models
正解：C、D
質問 # 44
What security control area determines if there is sensitive data in a system?
- A. Detect
- B. Assess
- C. Protect
- 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."
質問 # 45
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. Business rules
- C. Technical definitions of business terms
- D. Domain objects
正解：B、D
質問 # 46
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. Database Vault and Data Masking Pack
- C. Oracle Native Network Encryption and TDE (Transparent Data Encryption)
- D. Audit Vault and Database Firewall
正解：C
解説：
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."
質問 # 47
How does the Converged Database help to access data using an API?
- A. Developer can point their application to the location of ADB Wallet which integration all REST API calls.
- B. The database provides only one universal RES interface which makes integration of applications extremely agile.
- C. Each database comes with a REST-enabled compute instance to provide access to data.
- D. A REST API is automatically generated on top of SQL or stored procedures.
正解：D
解説：
This statement is true about how the Converged Database helps to access data using an API. According to the Oracle documentation5, "Oracle REST Data Services (ORDS) makes it easy to develop modern REST interfaces for relational data in the Oracle Database and the Oracle Database 18c JSON Document Store. A mid-tier Java application, ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database transactions and returns any results formatted using JSON." ORDS can automatically generate RESTful services for tables and views in the database or expose custom REST APIs using SQL or PL/SQL.
質問 # 48
Which three can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer?
- A. size of the shared global area (SGA) to use
- B. client network
- C. workload type
- D. amount of database OCPUs required
- E. amount of database storage required
正解：C、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.
質問 # 49
Which two are key characteristics of Oracle Autonomous Database? (Choose all correct an-swers)
- A. Lower cost
- B. Higher cost
- C. Customer manages everything
- D. Oracle manages everything
- E. Less automated
正解：A、D
解説：
These are two key characteristics of Oracle Autonomous Database. According to the Oracle documentation10, "Autonomous Database provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database administration." As a service, Autonomous Database handles all the tasks related to provisioning, patching, upgrading, scaling, backup, and recovery of the database, so that customers do not need to manage anything. Additionally, Autonomous Database offers lower cost compared to other cloud database services by providing features such as auto scaling, performance optimization, and pay-per-use pricing model.
質問 # 50
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)
- A. OCI GoldenGate
- B. OCI Object Storage
- C. Autonomous Database
- D. OCI Data Catalog
正解：B、D
質問 # 51
What are two main benefits of Oracle APEX? (Choose all correct answers)
- A. Less productivity compared to hand coding
- B. Faster development time using hand coding
- C. Develop responsive web apps
- D. Rapidly develop, customize, and deliver secure applications
- E. Store data in PL/SQL objects
正解：C、D
解説：
Rapidly developing, customizing, and delivering secure applications and developing responsive web apps are two main benefits of Oracle APEX. According to the Oracle website2, "Oracle APEX is a low-code development platform that enables you to build scalable, secure enterprise apps with world-class features that can be deployed anywhere." Additionally, according to the Oracle website3, "Oracle APEX enables developers to build modern, mobile-ready applications out of the box with minimal effort."
質問 # 52
What is a main feature of APEX's low code platform?
- A. Build scalable web apps for MongoDB
- B. Simplified core-based licensing
- C. Use graphical interfaces and configuration for building web applications
- D. Use traditional computer programming paradigms
- E. Limited productivity
正解：C
解説：
Use graphical interfaces and configuration for building web applications is a main feature of APEX's low code platform. As mentioned earlier, according to the Oracle website, "Oracle APEX is a low-code development platform that enables you to build scalable, secure enterprise apps with world-class features that can be deployed anywhere. With APEX, you can create modern web apps with minimal coding using intuitive graphical interfaces and declarative configuration."
質問 # 53
Which is NOT a key to successful database upgrades?
- A. Enable Performance Stability with SPM. STA, and RAT
- B. Download and install newest RU
- C. Download and use Auto Upgrade
- D. Download and install Oracle 21c
- E. Download and install Oracle 19c
正解：A
質問 # 54
Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which is an example of an in-database option?
- A. Tuning of hyperparameter
- B. Oracle Machine Learning for Python (OML4Py) APIs
- C. Cognitive text
- D. REST Interface
正解：B
質問 # 55
What are three platforms where Oracle's Autonomous Database service can be deployed? (Choose all correct answers)
- A. Oracle Public Cloud at Customer
- B. Dedicated Region Cloud at Customer
- C. Hybrid Cloud Configurations
- D. Oracle Cloud Infrastructure
- E. AWS Cloud at Customer
正解：A、B、C
質問 # 56
Which statement can be detected by monitoring of access to sensitive data?
- A. SELECT * from EMPLOYEES;
- B. SELECT SYSDATE from DUAL;
- C. CREATE index emp_id_idx on EMPLOYEES(emp_id);
- D. UPDATE quarter_reference set Q1='012022'
正解：A
解説：
This statement can be detected by monitoring of access to sensitive data, because it queries all the data from the EMPLOYEES table, which may contain personal or confidential information about the employees, such as name, address, salary, or performance. Monitoring access to sensitive data can help protect the data from unauthorized or malicious use, and ensure compliance with data privacy regulations.
質問 # 57
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 locally in the Fast Recovery Area of the DB system.
- B. You can store your DB system database backups in on-premises local storage.
- C. You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.
- D. You can store your DB system database backups on locally attached block storage vol-umes.
正解：B、C
質問 # 58
......
1z0-1105-23問題集はあなたの合格を必ず保証します：https://jp.fast2test.com/1z0-1105-23-premium-file.html