Free Oracle 1z0-902 Practice Exam with Questions & Answers

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

Oracle Exadata Deployment Assistant (OEDA) offers multiple benefits for configuring and deploying Exadata systems:

Configuration Gathering and Rack File Creation: OEDA simplifies the setup of Exadata environments by collecting system-specific configuration details. It uses this information to generate the Exadata Rack configuration file, which outlines the optimal setup for the particular environment, streamlining the deployment process and ensuring compatibility with Oracle best practices​ .

Lifecycle Management CLI for Exadata Systems: OEDA includes a command-line interface (CLI) that facilitates various lifecycle management tasks, specifically designed for Exadata systems. This CLI helps in automating deployment steps, adjusting configurations, and updating system parameters, tailored specifically for Exadata’s hardware and software environment .

https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf

A. YOU query VSSYSTEM_EVENTS and filter for the event ‘cell physical IO interconnect bytes returned by smart scan’, associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.

C. You query v$SYSTAT and filter for the statistic ‘cell smart table scan’, associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.

https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

Oracle Auto Service Request (ASR) on Exadata Database Machines is designed to proactively monitor and detect hardware and software issues. When a problem is detected, ASR Manager automatically opens a service request (SR) with Oracle Support. The primary focus of ASR is on hardware assets, such as storage servers, database servers, and network components, as well as software assets related to Exadata System Software and Oracle Database configurations​​.

Exadata System Software metrics and alerts work as follows:

Persistence of Thresholds: When metric thresholds are configured, they remain active and persist across server reboots. This ensures consistent monitoring behavior even after maintenance or unexpected reboots .

Default Metrics: By default, metrics are collected without predefined thresholds. Administrators must set custom thresholds to enable specific alerting based on their operational requirements​.

Oracle ASR covers a range of hardware components on Exadata Database Machines to ensure rapid response and issue resolution. The covered hardware components include critical parts such as:

Fan Trays: These are essential for cooling Exadata components and are covered by ASR in case of failures​.

System Controller (SC): Integral to the operation of Exadata storage servers, SC failures are reported by ASR to ensure the overall system’s reliability and availability​.

I/O Boards: ASR actively monitors and responds to failures in I/O boards, which are crucial for data processing and connectivity within Exadata storage servers​.

The ASR system is optimized to handle hardware-related issues proactively, ensuring that critical components are continuously monitored and replaced as necessary.

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

A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.

[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-software-introduction.html

Statement B is true as the vm_maker —start-domain command can be used to start a virtual machine manually, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 65).

Statement E is also true as the vm_maker —auto-start command can be used to configure a virtual machine to start automatically when the KVM host is started [1][2], as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 66).