• ホーム
  • ブログ
  • [2023年更新]1Z0-902試験問題集でテストエンジン練習テスト問題 [Q25-Q40]

[2023年更新]1Z0-902試験問題集でテストエンジン練習テスト問題 [Q25-Q40]

Share

[2023年更新]1Z0-902試験問題集でテストエンジン練習テスト問題

合格できる1Z0-902試験[2023年06月30日]最新62問題


Oracle 1z1-902 認定試験は、Exadata Database Machine X8Mを実装するためのタスクを担当するITプロフェッショナルのスキルと知識を検証するために設計されています。この試験では、Exadataストレージサーバーのインストールと構成、ネットワークコンポーネントの構成、およびExadataプラットフォーム上のOracleデータベースの管理と管理がカバーされています。

 

質問 # 25
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. 2, 8, 7, 3, and 6
  • C. 4, 7, 8, 3, and 6
  • D. 2, 7, 8, and 6
  • E. 1, 8, 7, 3 and 6

正解：D

解説：
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.


質問 # 26
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

  • A. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
  • B. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
  • C. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.
  • D. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
  • E. The sparse_<DBM_NAME> diskgroup is created automatically.

正解：B、D

解説：
According to the Oracle Exadata Database Machine Technical Architecture1, the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_<DBM_Name> and RECO_<DBM_NAME>. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1.
The correct statements about this configuration are:
Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1.
Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.


質問 # 27
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

  • A. PMEM Pool Misses in the Exadata Outlier Summary
  • B. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
  • C. PMEM Cache section within Memory Statistics
  • D. PMEM Cache section within Exadata Smart Statistics
  • E. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

正解：B、D

解説：
Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.


質問 # 28
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. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
  • B. # xfs_growfs /uOl +20G
  • C. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
  • D. # resize2fs +20G /dev/VGExaDb/LVDbOral

正解：A


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

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

正解：A

解説：
1. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'" is valid command and it is used to list the historical values for metrics where the name starts with "DS_."
2. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " is valid command and it is used to list the current value of the metric named "DS_TEMP"
3. dbmcli -e "LIST IBPORT DETAIL" is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
"dbmcli" is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command "dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15" is not a valid command, it is not supported on Exadata X9M.


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

正解：A、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).


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

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

正解：A、D、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.


質問 # 32
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

  • A. Install on Oracle Database Appliance.
  • B. Provide individual x86 64-Bit gateway hardware.
  • C. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  • D. Install on Exadata Engineered System.
  • E. Install in Oracle Virtual Machine with required hardware.

正解：B、C、D

解説：
These options are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources. The customer can choose to either provide their own x86 64-Bit gateway hardware or purchase the recommended hardware from Oracle, or they can install the gateway on an Exadata Engineered System.


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

正解：A、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).


質問 # 34
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. 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. A splitter cable can be used to provide power to all PDU cables.
  • D. The installation can go ahead, no change is required.

正解：B


質問 # 35
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

  • A. ASR Manager must be installed and configured on one of the database servers.
  • B. ASR communicates with Oracle support services using HTTPS.
  • C. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
  • D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
  • E. ASR can upload configuration metadata to support problem resolution.
  • F. Configuring ASR is mandatory for all Database Machine assets.

正解：D、E

解説：
1. ASR can upload configuration metadata to support problem resolution1.
2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm


質問 # 36
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. Add 12x 64GB DIMMs.
  • B. Remove existing memory modules.
  • C. Add 24x 32GB DIMMs.
  • D. Add 16x 64GB DIMMs.
  • E. Memory cannot be expanded on Exadata X9M-2 Database Servers.
  • F. Add 12x 32GB DIMMs.
  • G. Add 16x 32GB DIMMs.
  • H. Add 32x 64GB DIMMs.
  • I. Shutdown the Database Server if running.

正解：B、D、I

解説：
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".


質問 # 37
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

  • A. Collected configuration information can be uploaded manually to Oracle.
  • B. It collects configuration information automatically.
  • C. It is mandatory to install OCM on all database servers.
  • D. It collects configuration information on demand.
  • E. Collected configuration information can be uploaded automatically to Oracle.
  • F. It is mandatory to install OCM on at least one database server.

正解：C、E、F


質問 # 38
Which two statements are true about enabling write-back flash cache?

  • A. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
  • B. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
  • C. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
  • D. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
  • E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

正解：C、E

解説：
The two statements that are true about enabling write-back flash cache are:
When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Before write-back flash cache is enabled, you need to drop the Flash Cache first.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "when enabling write-back flash cache in a rolling manner [1], grid disks need to be inactivated on all cells before enabling write-back flash cache". It also states that "before write-back flash cache can be enabled, the existing flash cache must be dropped".


質問 # 39
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 "set threshold ds_temp comparison=' >', critical=30" on each database server
  • B. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
  • C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
  • D. dbmcli -e "set alert ds_temp> 30" on each database server

正解：A

解説：
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 5-54) recommends using the dbmcli command to set thresholds on metrics, such as temperature. To do this, you should use the following command:
dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server.
This will generate an alert if the temperature exceeds 30C.


質問 # 40
......


Oracle 1z1-902 認定試験の準備には、オラクルが提供する様々なトレーニングリソースを活用することができます。それには、インストラクターによるコース、オンライントレーニング、自習教材などがあります。候補者は、実世界の環境で Oracle Exadata Database Machine X8M と一緒に作業することで実践的な経験を積むこともできます。

 

Oracle 1Z0-902リアルな2023年最新の知能問題集模擬試験問題集：https://www.goshiken.com/Oracle/1Z0-902-mondaishu.html

Oracle 1Z0-902リアルな問題と100%カバーリアルな試験問題：https://drive.google.com/open?id=13wgPg0P9B18gfzyi-gyhgawuAAPwozuY

関するブログ

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