• ホーム
  • ブログ
  • 最新の1Z0-902試験問題集でOracle試験にはトレーニングを提供しています [Q30-Q47]

最新の1Z0-902試験問題集でOracle試験にはトレーニングを提供しています [Q30-Q47]

Share

最新の1Z0-902試験問題集でOracle試験にはトレーニングを提供しています

合格できるOracle Oracle Exadata Database Machine X8M Implementation EssentialsのPDF問題集は最近更新された62問あります

質問 # 30
Which dbmcli command is NOT valid on Exadata X9M?

  • A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
    B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
  • B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
  • C. dbmcli -e "LIST IBPORT DETAIL"

正解：B


質問 # 31
Which dbmcli command is NOT valid on Exadata X9M?

  • A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
  • B. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
  • C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
  • D. dbmcli -e "LIST IBPORT DETAIL"

正解：D

解説：
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.


質問 # 32
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?

  • A. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
  • B. list cell attributes name, deviceName, diskType, physicalFirmware
  • C. list celldisk attributes name, deviceName, diskType, physicalFirmware
  • D. list devices attributes name, deviceName, diskType, physicalFirmware

正解：A


質問 # 33
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?

  • A. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
  • B. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
  • C. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
  • D. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

正解：B


質問 # 34
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

  • A. shutdown -h now' on the affected storage server
  • B. CellCLI alter GRIDDISK all inactive on the affected storage server
  • C. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
  • D. 'crsct1 stop cluster -all' on one of the database servers
  • E. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
  • F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

正解：A、B

解説：
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1188080_1.html


質問 # 35
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

  • A. Disk Region Quarantine
  • B. SQL Plan Quarantine
  • C. Cell Offload Quarantine
  • D. Manually created Quarantine
  • E. Database Quarantine

正解：B、E


質問 # 36
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?

  • A. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
  • B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
  • C. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
  • D. dbmcli -e "set alert ds_temp> 30" on each database server

正解：D


質問 # 37
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?

  • A. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • C. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • D. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

正解：A

解説：
Exachk is an Oracle-provided diagnostic tool that allows you to check various components of an Exadata Database Server, including the client network. The tool is located in the /opt/oracle.SupportTools/exachk/ directory and can be run with the command: exachk. This command can be run with the option -from <Fridays_Date>_17:00:00 and -to <Sundays_Date>_23:59:00 to specify a time range of interest, this way you can check the client network status between the specified time range. The tool checks the status of various components such as network interfaces, InfiniBand fabric, and storage servers. It also analyzes log files, configuration files, and system settings to detect any issues. The tool generates a report, which can be used to identify the root cause of the issue and provide recommendations for resolution.
Tfact1 is a tool to collect diagnostic information from Exadata and non-Exadata systems and it is not related to client network status.
Netcheck and GetExaWatcherResults.sh are not tools provided with the Exadata Database Server and they are not related to client network status.


質問 # 38
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

  • A. Remove existing memory modules.
  • B. Memory cannot be expanded on Exadata X9M-2 Database Servers.
  • C. Add 32x 64GB DIMMs.
  • D. Add 16x 32GB DIMMs.
  • E. Add 24x 32GB DIMMs.
  • F. Shutdown the Database Server if running.
  • G. Add 16x 64GB DIMMs.
  • H. Add 12x 64GB DIMMs.
  • I. Add 12x 32GB DIMMs.

正解：A、C、F

解説：
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/


質問 # 39
Which are two correct statements about backing up Exadata Database Machine?

  • A. For high availability, system area can be on the first two disks and M.2 devices.
  • B. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
  • C. Backing up Exadata Storage Server Software is critical for restoration.
  • D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
  • E. 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、D

解説：
[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


質問 # 40
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?

  • A. 4,1, 6, 9
  • B. 0
  • C. 10, 8, 9, 11
  • D. 7,6,9,11
  • E. 10, 8, 2, 5

正解：A


質問 # 41
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?

  • A. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
  • B. list cell attributes name, deviceName, diskType, physicalFirmware
  • C. list celldisk attributes name, deviceName, diskType, physicalFirmware
  • D. list devices attributes name, deviceName, diskType, physicalFirmware

正解：A

解説：
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html


質問 # 42
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 only one database server in both racks
  • B. on all database servers in the second rack
  • C. on all database servers and at least two storage servers 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 in the first rack
  • G. on all storage servers in both racks

正解：C、D

解説：
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).


質問 # 43
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

  • A. OS I/O metrics using Enterprise Manager host pages for the storage servers
  • B. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us
  • C. OS I/O metrics using OS tools such as iostat on the storage servers
  • D. OS I/O metrics using OS tools such as iostat on the database servers
  • E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

正解：B、E

解説：
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.


質問 # 44
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

  • A. OS I/O metrics using Enterprise Manager host pages for the storage servers
  • B. OS I/O metrics using OS tools such as iostat on the storage servers
  • C. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us
  • D. OS I/O metrics using OS tools such as iostat on the database servers
  • E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

正解：D、E

解説：
The two monitoring tools that might be useful in examining I/O performance for the prod database are:
OS I/O metrics using OS tools such as iostat on the database servers.
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "I/O metrics can be collected from the database server using OS tools such as iostat [1], as well as from the storage servers using cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk". It also suggests using Enterprise Manager host pages for the storage servers to view OS I/O metrics.


質問 # 45
Which three of the following options are available for database consolidation on Exadata?

  • A. Multiple Databases on a cluster
  • B. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
  • C. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
  • D. Bare Metal deployment with one database per database server
  • E. A single database with one or more schema per application
  • F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

正解：B、C、F

解説：
Options A, D, and F are available for database consolidation on Exadata. Option A refers to the use of multiple pluggable databases in one or more container databases on either a Virtual Machine or Bare Metal cluster. Option D refers to the use of multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently. And finally, Option F refers to the use of multiple Virtual Machine clusters supporting a single database for greatest resource isolation. This is referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.


質問 # 46
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

  • A. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
  • B. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
  • C. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
  • D. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

正解：A、B


質問 # 47
......

更新されたテストエンジン練習1Z0-902問題集と練習試験で使おう：https://www.passtest.jp/Oracle/1Z0-902-shiken.html

問題集お試しセット1Z0-902テストエンジン問題集トレーニングには62問あります：https://drive.google.com/open?id=1953CR5zkcY_lXeC12MATMxbrcEZIx0ug

関するブログ

もっと
1Z0-902 無料問題集