1Z0-902 Practice Dumps - Verified By ActualVCE Updated 62 Questions
Updated 1Z0-902 Exam Dumps - PDF Questions and Testing Engine
NEW QUESTION 18
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- D. dbmcli -e "LIST IBPORT DETAIL"
Answer: B
Explanation:
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.
NEW QUESTION 19
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. Configuring ASR is mandatory for all Database Machine assets.
- C. ASR communicates with Oracle support services using HTTPS.
- D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- E. ASR Manager must be installed and configured on one of the database servers.
- F. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
Answer: D,F
NEW QUESTION 20
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. 7,6,9,11
- B. 0
- C. 10, 8, 2, 5
- D. 4,1, 6, 9
- E. 10, 8, 9, 11
Answer: D
NEW QUESTION 21
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
- A. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
- B. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- C. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- D. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
Answer: C,D
NEW QUESTION 22
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- B. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- C. Run exachk and resolve only WARNINGS that you have not seen before.
- D. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- E. Run the appropriate patchmgr preqequisite check step for each component being updated.
- F. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
Answer: A,B,E,F
NEW QUESTION 23
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- B. changing the root password
- C. installing an alternative package manager
- D. configuring secure shell user equivalency for the cellmonitor user
- E. upgrading the Storage Server software package using rpm
Answer: B,C
NEW QUESTION 24
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. It is required to install OEDA on the first new database server.
- 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. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- D. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- E. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
Answer: D,E
Explanation:
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.
NEW QUESTION 25
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:
How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?
- A. 12 consisting of seven griddisks each
- B. 96 consisting of one griddisk each
- C. 7 consisting of 12 griddisks each
- D. 1 consisting of all 96 griddisks
- E. 0 because the new griddisks will be added to the existing faiigroups
Answer: D
Explanation:
This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.
NEW QUESTION 26
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 will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- B. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- C. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
- D. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
Answer: A
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], patchmgr can be used to apply updates in a rolling manner while still maintaining database availability. It will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption. This is done by invoking patchmgr with the -rolling argument and specifying the component groups in the input file.
NEW QUESTION 27
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?
- A. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- B. using the CELLCLI list LUN DETAIL command as the celladmin user
- C. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- D. hardware monitoring using the storage server ILOM
Answer: B,C
NEW QUESTION 28
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 alert ds_temp> 30" on each database server
- B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- C. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
Answer: A
NEW QUESTION 29
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. 3,2,6,1,4,7,5
- B. 2,3,4,6,1,7,5
- C. 2,6,1,4,3,7,5
- D. 4,3,2,6,1,7,5
- E. 3,2,6,4,1,7,5
Answer: A
NEW QUESTION 30
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. Add 32x 64GB DIMMs.
- C. Shutdown the Database Server if running.
- D. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- E. Remove existing memory modules.
- F. Add 12x 32GB DIMMs.
- G. Add 16x 64GB DIMMs.
- H. Add 24x 32GB DIMMs.
- I. Add 16x 32GB DIMMs.
Answer: C,E,G
Explanation:
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".
NEW QUESTION 31
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. cat /proc/net/bonding/bondeth0
- B. netstat -rn
- C. ifconfig -a legrep "re0| re1"
- D. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
Answer: D
NEW QUESTION 32
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 alert ds_temp> 30" on each database server
- B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- C. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
- D. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
Answer: C
Explanation:
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.
NEW QUESTION 33
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool Misses in the Exadata Outlier Summary
- B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- C. PMEM Cache section within Memory Statistics
- D. PMEM Cache section within Exadata Smart Statistics
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: C
NEW QUESTION 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. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
- B. shutdown -h now' on the affected storage server
- C. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- D. 'crsct1 stop cluster -all' on one of the database servers
- E. CellCLI alter GRIDDISK all inactive on the affected storage server
- F. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
Answer: B,E
Explanation:
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].
NEW QUESTION 35
......
New (2023) Oracle 1Z0-902 Exam Dumps: https://dumps4download.actualvce.com/Oracle/1Z0-902-valid-vce-dumps.html