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. 27, 2025 (see below)
Which three component faults are covered by Oracle Auto Service Request (ASR)?
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.
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.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Heidy
4 days agoGeraldo
1 months agoAngelica
2 months agoCherri
3 months agoBarney
3 months agoLillian
4 months agoAlisha
4 months agoJovita
5 months agoAnnice
5 months agoDortha
5 months agoRodolfo
6 months agoAlonso
6 months agoLashanda
6 months agoReta
7 months agoBecky
7 months agoTitus
7 months agoAugustine
8 months agoCarolann
8 months agoAmie
8 months agoCeola
9 months agoJacquline
9 months agoCorinne
10 months agoHyman
10 months agoDevon
10 months agoLorrine
11 months agoJeff
11 months agoDustin
11 months agoAyesha
11 months ago