Free Preparation Discussions
MENU
Oracle 1Z0-902 Exam Questions
- Topic 1: Exadata Database Machine Architecture and Key Capabilities: In this section, the focus is on Exadata hardware architecture (2x database server types, 3x storage server types, power distribution, leaf, and spine switches), explaining Exadata software architecture and deployment scenarios, describing Exadata Remote Direct Memory Access (RDMA) and Client network architecture (including multitrack architecture, secure fabric).
- Topic 2: Exadata Database Machine Site and Implementation Planning (OECA&OEDA): In this domain, the focus is given to describing the function of Oracle Exadata Configuration Assistant and Oracle Exadata Deployment Assistant, designing an Exadata Database Machine with Oracle ZFS Storage in a single rack using Oracle Exadata Configuration Assistant, setting up Exadata Database virtual deployment using Oracle Exadata Deployment Assistant, adding extra database server to a physical Exadata Database Machine, defining physical site requirements and safety best practices for implementing Exadata (site planning, cooling, power), and installing and setting up Oracle Exadata using Oracle Exadata Deployment Assistant.
- Topic 3: Exadata Database Machine Installation: This section deals with the Exadata Database Server SP port (ILOM), the procedure for receiving the rack on site, how to reconfigure the Exadata Database Machine to use a single power cable, how to verify the firmware of an Exadata Storage Server, and configure Automatic Service Request (ASR) on the Exadata Database Machine.
- Topic 4: Exadata Database Machine Integration: This domain includes the network integration options of the Exadata Database Machine Connect Exadata Database Server in various scenarios, including client and backup networks.
- Topic 5: Exadata Database Machine Configuration and Administration: In this domain, the focus is given to creating and setting up Automatic Storage Management disk groups using Exadata, Exadata software and resources using CellCLI or other tools, how to use CellCLI, ExaCLI, DCLI, and ExaDCLI Exadata administration tools in various situations, create an ACFS Filesystem for use with external tables, and back up the Exadata Database Machine and databases on Exadata.
- Topic 6: Exadata Database Machine Security: This module covers configuring Exadata security (storage, secure boot, cellwall, AIDE, ASM Scoped Security, Database Scoped Security, FIPS secure filesystem) and implementing Access Control for REST API.
- Topic 7: Exadata Database Machine Security: This domain covers how to configure Exadata security (storage, secure boot, cellwall, AIDE, ASM Scoped Security, Database Scoped Security, FIPS secure filesystem) and deploy Access Control for REST API.
- Topic 8: Exadata Database Machine Troubleshooting: This domain covers how to recover Storage Cell from disk failure and utilize Exadata Software to troubleshoot client network disconnect.
- Topic 9: Exadata Database Machine Monitoring: This domain covers how to define the monitoring recommendations for Exadata Database Machine database servers, utilize Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers, and monitor and track Exadata Storage Server and Network using Command line or Cloud control.
- Topic 10: Exadata Database Machine Monitoring: In this section, the focus is given to the monitoring recommendations for Exadata Database Machine database servers, how to use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers, monitoring Exadata Storage Server and Network using Command line or Cloud control, describing the Enterprise Manager Cloud Control architecture as it specifically applies to Exadata Database Machine, and utilizing Enterprise Manager to discover Exadata Database Machine.
- Topic 11: Exadata Database Machine Updates: This section focuses on how to describe how software is maintained on different Database Machine components, utilize Exadata Software to deploy an update to an Exadata Database Machine without downtime, and utilize patchmgr to update a single storage server.
- Topic 12: Exadata Database Maintenance Tasks: This domain comprises the Power Database Machine on and off, safely shutting down a single Exadata Storage Server, replacing a damaged physical disk on a cell, replacing a damaged flash card on a cell, and adding extra storage to Exadata Database Servers.
Free Oracle 1Z0-902 Exam Actual Questions
Note: Premium Questions for 1Z0-902 were last updated On Apr. 14, 2025 (see below)
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?
What does the following command do?
root@rul6 -]# for j in {01..23} ; do ipmitool sunoem cli "set /SP/network/test ping=192.168.1.1$j'' ; done
The given command uses a for loop with ipmitool to issue ping commands sequentially to a range of IP addresses in the management network:
for j in {01..23}; do ipmitool sunoem cli 'set /SP/network/test ping=192.168.1.1$j'; done
This script verifies the connectivity of the ILOM management network before the Exadata installation. Each server's Service Processor (SP) is tested for reachability, confirming that the management network setup is operational across the full rack .
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
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.
How many 128GB Persistent Memory DIMMS are included in Exadata X9M-2 Extended (XT) Storage Servers?
The Exadata X9M-2 Extended (XT) Storage Server does not include any Persistent Memory (PMEM) DIMMs. The XT server configuration primarily serves as a cost-effective archival storage option and lacks the performance features available in the HC (High Capacity) and EF (Extreme Flash) storage servers. This configuration does not include Persistent Memory, which is leveraged in other models for accelerating OLTP workloads and providing extremely low-latency data access.
Your customer would like to configure monitoring capabilities Auto Service Request (ASR) on the stand-alone server that was set aside to run ASR Manager.
What configuration should you set up for the customer?
For setting up Auto Service Request (ASR) monitoring on a standalone server dedicated to ASR Manager:
ASR Manager with SNMP Traps: Configuring ASR Manager to utilize SNMP traps allows it to automatically receive alerts from the Integrated Lights Out Manager (ILOM) on Exadata components. The SNMP traps notify ASR Manager of specific hardware faults or critical system events, which then automatically generate service requests with Oracle Support.
This setup ensures proactive monitoring and allows rapid response to any critical alerts related to the Exadata hardware, leveraging the ILOM's ability to monitor key system health metrics and trigger alerts as necessary.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Geraldo
20 days agoAngelica
2 months agoCherri
3 months agoBarney
3 months agoLillian
4 months agoAlisha
4 months agoJovita
4 months agoAnnice
4 months agoDortha
5 months agoRodolfo
5 months agoAlonso
5 months agoLashanda
6 months agoReta
6 months agoBecky
7 months agoTitus
7 months agoAugustine
7 months agoCarolann
7 months agoAmie
8 months agoCeola
8 months agoJacquline
9 months agoCorinne
10 months agoHyman
10 months agoDevon
10 months agoLorrine
10 months agoJeff
10 months agoDustin
10 months agoAyesha
11 months ago