最新の2023年最新の実際に出ると確認された1Z0-902問題集で100%無料1Z0-902試験問題集
無料提供中で2023年最新のに更新されたOracle 1Z0-902試験問題と解答
質問 # 17
Which are two correct statements about backing up Exadata Database Machine?
- A. Backing up Exadata Storage Server Software is critical for restoration.
- B. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.
- C. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- D. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
- E. For high availability, system area can be on the first two disks and M.2 devices.
正解：A、C
解説：
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure
https://www.oracle.com/technetwork/database/availability/exadata-backup-recovery-bp-3633870.pdf
質問 # 18
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Call Oracle Support and make an appointment so that the drive can be replaced.
- B. Ask the system administrator to replace the broken disk with a spare.
- C. Download and run the latest exadiag tool.
- D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- E. Check the database to see if any rebalance operations are active.
- F. Wait for a blue light to appear on the disk if the rebalance operation is running.
正解：F
解説：
According to Oracle documentation1, Exadata Storage software has a complete set of automated operations for hard disk maintenance, when a hard disk has failed or has been flagged as a problematic disk. It will initiate a rebalance operation to redistribute data across other disks and mark the failed disk with an amber light.
質問 # 19
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?
- A. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
- B. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
- C. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
- D. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
- E. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
正解：B
解説：
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.
質問 # 20
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- B. Provide individual x86 64-Bit gateway hardware.
- C. Install on Oracle Database Appliance.
- D. Install on Exadata Engineered System.
- E. Install in Oracle Virtual Machine with required hardware.
正解：A、C、E
質問 # 21
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.9
- B. Oracle Linux 7.7
- C. Oracle Linux 8.0
- D. Oracle Linux 7.5
正解：A
解説：
RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.
質問 # 22
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. the storage server ILOM
- B. Oracle clusterware on the database server
- C. ASM instances
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- F. the Power Distribution Units (PDUs)
正解：A、B、C
質問 # 23
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Memory Statistics
- B. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- C. PMEM Pool Misses in the Exadata Outlier Summary
- D. PMEM Cache section within Exadata Smart Statistics
- E. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
正解：A、D
解説：
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)
質問 # 24
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. It collects configuration information automatically.
- B. It is mandatory to install OCM on at least one database server.
- C. Collected configuration information can be uploaded automatically to Oracle.
- D. It collects configuration information on demand.
- E. Collected configuration information can be uploaded manually to Oracle.
- F. It is mandatory to install OCM on all database servers.
正解：B、C、F
質問 # 25
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?
- A. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network
- B. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
- C. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
- D. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network
正解：B、C
質問 # 26
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.7
- B. Oracle Linux 8.0
- C. Oracle Linux 7.5
- D. Oracle Linux 6.9
正解：C
質問 # 27
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- B. Bare Metal deployment with one database per database server
- C. A single database with one or more schema per application
- D. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- E. Multiple Databases on a cluster
- F. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
正解：C、D、E
解説：
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
質問 # 28
Which three statements are true about the CELLCLI command?
- A. It can be executed using the DCLI utility.
- B. It can be executed on storage servers.
- C. It requires root privileges to create CELLDISKS and GRIDDISKS.
- D. It can execute commands on multiple storage servers in parallel.
- E. It has command-line history.
正解：A、B、E
解説：
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storage cells from a single interface. You can use DCLI to run CellCLI commands on multiple cells at once54.
質問 # 29
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?
- A. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- B. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.
- C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- D. It is required to install OEDA on the first new database server.
- E. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
正解：C、E
解説：
It is not necessary to execute /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server, nor is it required to install OEDA on the first new database server. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.
Search results: [1] Refer to the Oracle Exadata Database Machine X9M Implementation Essentials documentation for more information on adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA). [2] Oracle Exadata Deployment Assistant (OEDA) is a graphical user interface (GUI) tool used to configure the Oracle Exadata Database Machine X9M. [3] This article provides the step-by-step instructions to add an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA). [4] It is important to run the OEDA Validate Configuration File step prior to adding the new server to ensure the configuration file is valid and that all required files exist. [5] When adding a new database server with OEDA [1], the configuration file must contain the existing nodes and the new server information must be entered in OEDA. [6] The applyElasticConfig.sh script must be executed to configure the new servers, after which the new servers will be restarted.
質問 # 30
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?
- A. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- B. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
- C. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
- D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
正解：A、D
解説：
1. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
2. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/
質問 # 31
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. the storage server ILOM
- B. Oracle clusterware on the database server
- C. ASM instances
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- F. the Power Distribution Units (PDUs)
正解：A、B、C
解説：
1. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor ASM instances.
2. Additionally, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor the storage server ILOM.
3. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) also recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor Oracle clusterware on the database server.
質問 # 32
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?
- A. Extended
- B. Normal
- C. Sparse
- D. High
- E. External
正解：D
解説：
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure. This means that they need a redundancy level that can tolerate at least one disk failure without losing data availability or performance. Therefore, the best option for them is normal redundancy . Normal redundancy provides two-way mirroring by default, which means that each data extent has a primary copy and a mirror copy on different disks in different failure groups1. A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies2. On Exadata Database Machine , each Storage Server is considered as a failure group by default2. This means that if one Storage Server fails or needs to be updated , the data on its disks can still be accessed from another Storage Server that has the mirror copies of the same data extents2. Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html
質問 # 33
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?
- A. ifconfig -a legrep "re0| re1"
- B. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
- C. cat /proc/net/bonding/bondeth0
- D. netstat -rn
正解：C
解説：
According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.
質問 # 34
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- B. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
- D. ZFS Snapshots can provide rapid cloning of development and test environment.
正解：A、B
解説：
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.
質問 # 35
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. The incline of any access route ramp must be less than or equal to 6 degrees.
- B. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- D. Oracle Exadata Rack may only be installed on raised floor environments.
- E. 914mm of space required above the rack height is required for maintenance access.
- F. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
正解：D
解説：
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors
質問 # 36
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?
- A. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
- B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
- C. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
- D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
正解：D
解説：
Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.
質問 # 37
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?
- A. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
- B. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
- C. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
- D. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
- E. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
正解：E
質問 # 38
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?
- A. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- B. alert logs for Enterprise Manager
- C. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- D. alert logs for the ASM instances
- E. alert logs for the prod database instances
正解：D、E
解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.
質問 # 39
How do ASM failure groups provide redundancy?
- A. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- B. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
- C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
正解：D
質問 # 40
......
1Z0-902問題集PDFとテストエンジン試験問題：https://www.jpntest.com/shiken/1Z0-902-mondaishu
無料提供中で最新の1Z0-902認定有効な試験問題集はこれ：https://drive.google.com/open?id=1v7ZOVlZ_KPOQtPe4kQtY5UUxQIdzJA3y