[2024年07月31日] 最新更新されたのは1Z0-902試験問題2024年更新 [Q16-Q38]

[2024年07月31日] 最新更新されたのは1Z0-902試験問題2024年更新

無料更新されたOracle 1Z0-902テストエンジン問題には60問題と解答

質問 # 16
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

A. Exadata storage realms using database-scoped security mode
B. Exadata storage realms using ASM-scoped security mode
C. Using EXADCLI instead of CELLCLI to create the griddisks
D. File permissions on the griddisks in each database server
E. File permissions on the griddisks in each storage server

正解：B、E

解説：
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.

質問 # 17
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

A. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
B. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
C. Copy and execute the script on all storage servers using the EXACLI command.
D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
E. Copy and execute the script on all storage servers using the dcli command.

正解：A

解説：
This can be done by using the 'cellcli -e' command, which allows you to execute commands in parallel on all storage servers. For more information about executing CELLCLI commands in parallel, please refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

質問 # 18
Which two activities are supported on the storage servers in an Exadata Database Machine?

A. configuring secure shell user equivalency for the cellmonitor user
B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
C. upgrading the Storage Server software package using rpm
D. changing the root password
E. installing an alternative package manager

正解：A、D

解説：
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
A) changing the root password
E) configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

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

正解：C

解説：
Option 5 stops the clusterware on all database servers as the grid user3.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.
Option 7 shuts down all database servers using their ILOM interfaces1.
Option 6 powers off the rack using the power switches on the PDUs2.

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

正解：C

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

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

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

正解：A、C

質問 # 22
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

A. accidental loss of all data from all griddisks in a storage server
B. the failure of physical disk 1
C. the failure of physical disk 0 and 11
D. the failure of both physical M.2 disks
E. corruption in a normal or high redundancy ASM diskgroup
F. corruption in the / (root) filesystem
G. moving all disks from one cell to another as part of a chassis-level component failure

正解：D、F

解説：
The two valid reasons are:
corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.
the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.

質問 # 23
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 METRICHISTORY WHERE name LIKE 'DS_.*'"
D. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "

正解：B

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

質問 # 24
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 Power Distribution Units (PDUs)
B. ASM instances
C. the RDMA over Converged Ethernet (RoCE) switches
D. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
E. Oracle clusterware on the database server
F. the storage server ILOM

正解：A、C、F

解説：
According to Oracle's documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are:
The storage server ILOM2
The Power Distribution Units (PDUs)2
The RDMA over Converged Ethernet (RoCE) switches3

質問 # 25
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
B. You query v$SYSTAT and filter for the statistic 'cell smart table 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 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.

正解：A、C

質問 # 26
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

A. the failure of both physical M.2 disks
B. the failure of physical disk 1
C. the failure of physical disk 0 and 11
D. corruption in a normal or high redundancy ASM diskgroup
E. corruption in the / (root) filesystem
F. moving all disks from one cell to another as part of a chassis-level component failure
G. accidental loss of all data from all griddisks in a storage server

正解：E、G

解説：
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs

質問 # 27
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

A. 6, 1, 2, 7, 5, 8
B. 6, 3, 1, 9, 7, 8
C. 6, 8, 3, 4, 2, 1
D. 6, 2, 1, 8, 4, 5

正解：B

質問 # 28
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/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
B. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
C. # /opt/oracle.SupportTools/exachk/exachk -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

質問 # 29
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

A. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
B. OECA facilitates PDU power selection initially and after equipment addition.
C. OECA allows one XT storage server in the configuration.
D. OECA reconfigures the size of disk groups and recreates grid disks.
E. OECA extends the hardware for the elastic configuration only.

正解：A、C

質問 # 30
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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
B. netstat -rn
C. ifconfig -a legrep "re0| re1"
D. cat /proc/net/bonding/bondeth0

正解：D

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

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

正解：C、E、G

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

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

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

正解：A、C

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

質問 # 33
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. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
B. 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.
C. 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.
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, 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.

質問 # 34
How do ASM failure groups provide redundancy?

A. 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.
B. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
D. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

正解：D

解説：
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.

質問 # 35
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. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
C. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
D. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
E. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

正解：A、B

解説：
When enabling write-back flash cache in a rolling manner, it is important to use DBCLI to inactivate the grid disks on all cells first so that all the cells are in the same state before the process is started. In a non-rolling manner, you must drop the Persistent Memory Commit Accelerator (PMEMLog) first. Write-back flash cache is not on by default for High Capacity Storage Servers in High Redundancy configurations and can be used on Extreme Flash Storage Servers. It's also important to check if it's necessary to drop the flash cache before enabling write-back flash cache.

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

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

正解：B、E、F

解説：
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.

質問 # 37
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
B. You query v$SYSTAT and filter for the statistic 'cell smart table 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 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.

正解：A、C

解説：
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or 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 (D). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).

質問 # 38
......

100%の合格率を試そう！更新されたのは1Z0-902試験問題 [2024年更新]：https://www.jpntest.com/shiken/1Z0-902-mondaishu

ベストな問題集を使おうOracle Engineered Systems 1Z0-902専門試験問題：https://drive.google.com/open?id=1v7ZOVlZ_KPOQtPe4kQtY5UUxQIdzJA3y