Get Real 1Z0-902 Exam Dumps [Nov-2023] Practice Tests
Last 1Z0-902 practice test reviews: Practice Test Oracle dumps
Know about the Passing Score, Duration & Questions for the Oracle 1Z0-902 Exam
The passing score: 64%
Time Duration: 90 Minutes
Formate: Multiple Choice
Languages: English
Number of Questions: 60 Questions
NEW QUESTION # 16
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 flashdisks inside the Exadata storage servers for possible use for storage indexes.
- 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 the hard disks inside the database servers for possible extension of the /uoi file system.
- E. The sparse_<DBM_NAME> diskgroup is created automatically.
Answer: B,C
NEW QUESTION # 17
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,3,4,6,1,7,5
- B. 3,2,6,4,1,7,5
- C. 2,6,1,4,3,7,5
- D. 3,2,6,1,4,7,5
- E. 4,3,2,6,1,7,5
Answer: B
Explanation:
The correct sequence is:
Review the safety guidelines. This is important to ensure a safe and successful installation1.
Unpack Oracle Exadata Rack. This involves removing the packaging materials and inspecting the rack for damage or missing components1.
Place Exadata in its allocated space. This involves moving the rack to its final location and securing it with bolts and brackets1.
Let the Exadata acclimatize for 24 hours. This is recommended to allow the rack components to adjust to the ambient temperature and humidity before powering on1.
Stabilize the Exadata Rack. This involves leveling the rack and adjusting its height if needed1.
Power on Exadata PDU B. This involves connecting PDU B to a power source and turning it on1.
Power on Exadata PDU A. This involves connecting PDU A to a power source and turning it on1
NEW QUESTION # 18
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
- B. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
- C. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
- D. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
- E. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
Answer: B
NEW QUESTION # 19
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. 7,6,9,11
- C. 10, 8, 2, 5
- D. 10, 8, 9, 11
- E. 0
Answer: A
NEW QUESTION # 20
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. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- E. OS I/O metrics using OS tools such as iostat on the database servers
Answer: C,D
Explanation:
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.
NEW QUESTION # 21
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. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -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. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: A
NEW QUESTION # 22
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. Each component type must be upgraded independently of the other.
- 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 with all database and storage servers listed in a single input file.
- D. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
Answer: D
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 # 23
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 at least two storage servers in both racks
- B. on all storage servers in both racks
- C. on all database servers in the first rack
- D. on only one database server 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
Answer: A,F
Explanation:
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).
NEW QUESTION # 24
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?
- A. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
- B. to the CELLMONITOR account using cellcli interactively on each storage server
- C. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
- D. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
- E. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
- F. to the CELLADMIN account using cellcli interactively on each storage server
Answer: C,D,F
Explanation:
To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this task
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html
NEW QUESTION # 25
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. 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. 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.
- E. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
Answer: C,E
NEW QUESTION # 26
Which two statements are true about applying updates on Exadata systems?
- A. Failed storage server updates are automatically rolled back to a previous release.
- B. Failed database server updates are rolled back to a working state on a previous release automatically.
- C. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- E. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
Answer: A,F
Explanation:
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.
NEW QUESTION # 27
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
Answer: A
Explanation:
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.
NEW QUESTION # 28
Which two statements are true about applying updates on Exadata systems?
- A. Failed storage server updates are automatically rolled back to a previous release.
- B. Failed database server updates are rolled back to a working state on a previous release automatically.
- C. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- D. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- E. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- F. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
Answer: A,F
Explanation:
1. Exadata updates have a rollback feature in case the update fails, this means that the system will roll back to a previous release automatically, this applies to storage servers updates. D. Yum, the package manager used in Exadata, automatically installs a non-UEK kernel when running a regular update, this kernel can be selected to boot from grub.
NEW QUESTION # 29
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. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- B. the storage server ILOM
- C. Oracle clusterware on the database server
- D. the Power Distribution Units (PDUs)
- E. ASM instances
- F. the RDMA over Converged Ethernet (RoCE) switches
Answer: B,C,E
Explanation:
1. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor ASM instances.
2. Additionally, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor the storage server ILOM.
3. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) also recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor Oracle clusterware on the database server.
NEW QUESTION # 30
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,3,4,6,1,7,5
- B. 3,2,6,4,1,7,5
- C. 2,6,1,4,3,7,5
- D. 3,2,6,1,4,7,5
- E. 4,3,2,6,1,7,5
Answer: A
NEW QUESTION # 31
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
- B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- C. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- D. ZFS Snapshots can provide rapid cloning of development and test environment.
Answer: B,C
Explanation:
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.
NEW QUESTION # 32
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- D. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
Answer: A
Explanation:
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
NEW QUESTION # 33
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 sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
Answer: C,D
Explanation:
1. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
2. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.
NEW QUESTION # 34
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- C. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- D. Run exachk and resolve only WARNINGS that you have not seen before.
- E. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- F. Run the appropriate patchmgr preqequisite check step for each component being updated.
Answer: A,C,E,F
NEW QUESTION # 35
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. 2, 7, 8, and 6
- C. 5, 8, 7, and 6
- D. 2, 8, 7, 3, and 6
- E. 1, 8, 7, 3 and 6
Answer: C
Explanation:
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.
NEW QUESTION # 36
......
Certification Topics of Oracle 1Z0-902 Exam
Exadata Database Machine Updates
Exadata Database Machine Security
Exadata Database Machine Architecture and Key Capabilities
Exadata Database Machine Configuration and Administration
Exadata Database Machine Troubleshooting
Exadata Database Machine Monitoring
Exadata Database Maintenance Tasks
Get Ready to Pass the 1Z0-902 exam with Oracle Latest Practice Exam : https://actualtests.vceengine.com/1Z0-902-vce-test-engine.html
