1Z0-902 Sample Questions

1Z0-902 Sample Questions & Answers

Revolves around Exadata hardware and software architecture, planning deployment with OECA and OEDA tools, installing the rack and integrating networking, configuring ASM disk groups, securing storage, monitoring servers, and applying software updates.

Launch the full 1Z0-902 simulator →

Showing 10 of 20 free samples.

  1. Question 1Intermediate

    Exadata Database Machine Troubleshooting · Use Exadata Software to troubleshoot client network disconnect

    An administrator is troubleshooting a client connectivity issue where applications are intermittently failing to connect to a database on an Exadata X9M machine. The administrator suspects a network configuration problem on the database server. Which utility provides the most comprehensive details about the state and configuration of the InfiniBand ports on the database server?

    Show answer & explanation

    Correct answer: B

    The Database Machine Command-Line Interface (DBMCLI) is specifically designed for managing and monitoring Exadata database servers. The LIST IBPORT command provides detailed information about the InfiniBand ports, including their state, GUID, link speed, and error counters, which is essential for diagnosing connectivity problems over the high-speed fabric. ifconfig provides general network interface information but lacks InfiniBand-specific details. cellcli is for storage servers, and netstat shows active connections but not port configuration.

  2. Question 2Beginner

    Exadata Database Machine Configuration and Administration · Create an ACFS Filesystem for use with external tables

    A new Exadata X9M implementation requires the creation of a general-purpose filesystem on the database servers for storing staging files and application binaries. The solution must leverage the existing ASM storage infrastructure for high availability and ease of management. Which Exadata feature should be used to create this filesystem?

    Show answer & explanation

    Correct answer: C

    ASM Cluster File System (ACFS) is the correct solution as it is a general-purpose, clustered filesystem that leverages the underlying ASM storage infrastructure. This provides high availability and unified management within the Exadata environment, directly meeting the requirements. A local filesystem is not clustered, an NFS mount introduces external dependencies, and creating a new disk group is for database files, not a general-purpose filesystem.

  3. Question 3Intermediate

    Exadata Database Machine Site and Implementation Planning (OECA&OEDA) · Configure Exadata Database virtual deployment using Oracle Exadata Deployment Assistant

    A consultant is using the Oracle Exadata Deployment Assistant (OEDA) to plan a virtualized deployment. The customer has a requirement to create three separate VM clusters with different CPU and memory allocations for production, development, and testing environments. What is the correct procedure within the OEDA workflow to define these distinct VM clusters?

    Show answer & explanation

    Correct answer: B

    The OEDA interface is designed to handle multi-cluster virtualized deployments within a single configuration file. The 'Cluster' page allows the user to define multiple, distinct clusters. For each cluster, specific attributes such as the name, assigned database servers (VMs), CPU cores, and memory can be specified, fulfilling the customer's requirement.

  4. Question 4Intermediate

    Exadata Database Maintenance Tasks · Power Database Machine on and off

    After a power outage in the data center, an Exadata X9M machine is being powered back on. To prevent component damage and ensure a clean startup, what is the correct sequence for powering on the machine components?

    Show answer & explanation

    Correct answer: C

    The correct power-on sequence is critical for a stable startup. First, the network infrastructure (switches) must be active. Second, the storage layer (Storage Servers) must be available. Finally, the compute layer (Database Servers) can be started, as it depends on both the network and storage to function correctly. This bottom-up approach ensures that dependencies are met at each stage.

  5. Question 5Advanced

    Exadata Database Machine Security · Configure Exadata security (storage, secure boot, cellwall, AIDE, ASM Scoped Security, Database Scoped Security, FIPS secure filesystem)

    A security audit of an Exadata X9M machine has identified a vulnerability. To mitigate the risk, the administrator needs to prevent a specific database server, db01, from communicating with a specific storage server, cell03, over the RDMA network fabric. All other communication paths must remain active. Which command, run on cell03, will achieve this?

    Show answer & explanation

    Correct answer: C

    The CellWall feature is the correct mechanism for this task. The ALTER CELL cellwall ADD denied_hosts command allows you to specify IP addresses that should be blocked from accessing the storage cell's services. This creates a specific firewall rule to isolate the component as required. The other options use incorrect syntax or objects (ipconf, acls).

  6. Question 6Beginner

    Exadata Database Machine Monitoring · Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers

    A database administrator needs to check the current temperature of the database servers in an Exadata Full Rack to ensure they are within the optimal operating range. The administrator wants to use the command-line interface on one of the database servers. Which dbmcli command will display the current temperature metric?

    Show answer & explanation

    Correct answer: B

    The dbmcli utility is used for monitoring database servers. The LIST METRICCURRENT command retrieves the latest value for monitored metrics. The metric name for the database server temperature is DS_TEMP. Therefore, this command correctly queries for the current temperature. METRICHISTORY would show past values, not the current one.

  7. Question 7Intermediate

    Exadata Database Machine Troubleshooting · Recover Storage Cell from disk failure

    A storage administrator is tasked with replacing a failed hard disk in an Exadata X9M Storage Server. After replacing the physical drive, the new disk is not automatically added back to the ASM disk group. The administrator verifies the disk is physically sound and recognized by the cell. What is the most likely cause of this issue?

    Show answer & explanation

    Correct answer: C

    In Exadata, ASM uses logical celldisks, which are created on top of physicaldisks. When a physical disk fails, the corresponding celldisk is dropped. After replacing the hardware, the administrator must manually recreate the celldisk on the new physical disk using CREATE CELLDISK. Only after the celldisk exists can it be added back to the ASM disk group. This is a common manual step in the disk replacement process.

  8. Question 8Beginner

    Exadata Database Machine Site and Implementation Planning (OECA&OEDA) · Describe physical site requirements and safety best practices for implementing Exadata (site planning, cooling, power)

    A retail company is planning the physical installation of a new Exadata X9M Full Rack. The data center manager needs to ensure the site meets the power requirements. Which of the following is a key safety and operational best practice for the power setup of an Exadata machine?

    Show answer & explanation

    Correct answer: C

    A fundamental best practice for high-availability systems like Exadata is power redundancy. The rack is equipped with redundant Power Distribution Units (PDUs) that should be connected to separate, independent power circuits. This ensures that the failure of a single power source will not cause an outage for the entire machine.

  9. Question 9Intermediate

    Exadata Database Machine Architecture and Key Capabilities · Describe Exadata Remote Direct Memory Access (RDMA) and Client network architecture (including multirack architecture, secure fabric)

    What is the primary function of the Remote Direct Memory Access (RDMA) protocol over Converged Ethernet (RoCE) within the Exadata X9M network fabric?

    Show answer & explanation

    Correct answer: B

    RDMA is a key technology in Exadata that provides a high-bandwidth, low-latency network communication path. Its primary function is to allow the network interface card (NIC) to transfer data directly to or from the application's memory on another server without involving the operating system's kernel or CPU on either end. This significantly reduces CPU overhead and network latency, which is critical for high-performance database operations.

  10. Question 10AdvancedSelect 3

    Exadata Database Machine Updates · Use Exadata Software to deploy an update to an Exadata Database Machine without downtime

    An implementation specialist needs to perform a zero-downtime software update on an entire Exadata X9M rack. The goal is to patch all database servers and storage servers in a rolling fashion. Which THREE actions are part of the recommended procedure using patchmgr? (Select THREE)

    Show answer & explanation

    Correct answers: A, C, E

    Running a prerequisite check is a critical first step to identify any potential issues that could cause the update to fail. This helps ensure a smooth patching process.

    The recommended update order is to patch the storage tier first, followed by the database tier. This ensures that the storage layer is running the new software before the database servers that depend on it are updated.

    patchmgr handles the rolling execution, but it is crucial to monitor its progress. After the patch is applied to a node and it rejoins the cluster, post-patch verification steps are often required to ensure its health and proper functioning.

Ready for the real thing?

The full 1Z0-902 simulator has every exam-style question, timed mode, and instant scoring.

Go to the 1Z0-902 simulator →