最新2024年06月18日リアルな1z1-902試験問題集解答で有効な1z1-902問題集PDF
Oracle 1z1-902試験問題集でPDF問題とテストエンジン
質問 # 10
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?
- A. -> set /SYS power_state=ON
- B. -> start /SYS/power
- C. -> start /SP/console
- D. You must be physically present in the data center to start an Exadata Storage Server.
- E. -> start /SYSTEM/power
- F. -> start /System
正解：F
質問 # 11
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 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.
- B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- 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 v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
正解：B、C
質問 # 12
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?
- A. 2,6,1,4,3,7,5
- B. 4,3,2,6,1,7,5
- C. 2,3,4,6,1,7,5
- D. 3,2,6,1,4,7,5
- E. 3,2,6,4,1,7,5
正解：D
質問 # 13
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. Multiple Databases on a cluster
- C. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- D. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- E. Bare Metal deployment with one database per database server
- F. A single database with one or more schema per application
正解：B、C、F
解説：
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
1. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
2. A single database with one or more schema per application12.
3. Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
質問 # 14
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
正解：A
解説：
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-performance
質問 # 15
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:
After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?
- A. # xfs_growfs /uOl +20G
- B. # resize2fs +20G /dev/VGExaDb/LVDbOral
- C. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
- D. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
正解：D
解説：
After running the commands above, the filesystem mounted on /u01 is on the logical volume /dev/mapper/VGExaDb-LVDbOral. So, to add 20G of space to the filesystem mounted on /u01, the command that needs to be run is:
lvextend -L +20G --verbose /dev/mapper/VGExaDb-LVDbOral
This command will extend the logical volume /dev/mapper/VGExaDb-LVDbOral by 20 GB of space. It is important to note that the option --verbose is used to display the progress of the operation.
質問 # 16
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. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 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. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
正解：E
解説：
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.
質問 # 17
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. 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.
- B. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- C. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- D. It is required to install OEDA on the first new database server.
- E. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
正解：C、E
質問 # 18
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Manually created Quarantine
- B. SQL Plan Quarantine
- C. Cell Offload Quarantine
- D. Database Quarantine
- E. Disk Region Quarantine
正解：B、D
質問 # 19
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?
- A. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- B. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
- C. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
- D. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
正解：A
解説：
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).
質問 # 20
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 1536GB
- B. 384GB
- C. 2048GB
- D. 768GB
- E. 1024GB
- F. 512GB
正解：C
解説：
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).
質問 # 21
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?
- A. on all database servers in the first rack
- B. on all storage servers in both racks
- C. on only one database server in both racks
- D. on at least two storage servers in both racks
- E. on all database servers in both racks and one storage server in each rack
- F. on all database servers and at least two storage servers in both racks
- G. on all database servers in the second rack
正解：D、F
解説：
In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).
質問 # 22
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?
- A. 5, 8, 7, and 6
- B. 1, 8, 7, 3 and 6
- C. 2, 7, 8, and 6
- D. 2, 8, 7, 3, and 6
- E. 4, 7, 8, 3, and 6
正解：C
質問 # 23
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR communicates with Oracle support services using HTTPS.
- B. ASR can upload configuration metadata to support problem resolution.
- C. ASR Manager must be installed and configured on one of the database servers.
- D. Configuring ASR is mandatory for all Database Machine assets.
- E. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- F. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
正解：E、F
質問 # 24
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
- B. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- C. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
- D. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
正解：A、D
解説：
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
A) Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
D) When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
質問 # 25
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.
Which statement is correct?
- A. The installation cannot proceed until two power feeds are available per PDU.
- B. A splitter cable can be used to provide power to all PDU cables.
- C. The installation can go ahead, no change is required.
- D. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
正解：C
解説：
According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, each PDU has two power input cables that can be connected to separate power sources for redundancy. However, if only one power source is available per PDU, then a single cable can be used to provide sufficient power for normal operation.
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
質問 # 26
......
信頼できるOracle Engineered Systems 1z1-902問題集PDF2024年06月18日最近更新された問題：https://jp.fast2test.com/1z1-902-premium-file.html
最新1z1-902試験問題集には合格保証付きます：https://drive.google.com/open?id=1FhkD29THtXzvjQhNuIm8YkG8sIerq40m