1Z0-902 Exam Questions

Which are two correct statements about backing up Exadata Database Machine?

Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical d...

Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

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...

Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

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 Con...

Which three of the following options are available for database consolidation on Exadata?

You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Pl...

You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS proc...

Which statement is true about the Persistent Memory Commit Accelerator?

Which two activities are supported on the storage servers in an Exadata Database Machine?

What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

Examine this list of software components: 1. Oracle KVM Guest 2. Oracle Enterprise Manager Agent (OMA) 3. ASM instance 4. RDBMS instance 5. Automatic Diagnostic Repository Command...

Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protecte...

Which three statements are true about the CELLCLI command?

An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA PDUs is being installed in a Data Center. However, the Data Center is only providin...

You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely po...

Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

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 ser...

You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C. What command should use use to...

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 Ma...

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 investi...

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....

Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing e...

Which dbmcli command is NOT valid on Exadata X9M?

Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes: After running the following commands,...

You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands: What steps and in which order should they be executed?

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...

Which two statements are true about enabling write-back flash cache?

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. Le...

Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance. Which ILOM command start...

Which two statements are true about applying updates on Exadata systems?

How do ASM failure groups provide redundancy?

You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exada...

How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve...

You use Enterprise Manager to monitor all the components of your Exadata Database Machine. Recently, you discovered that certain asmdisks were offline in one of the diskgroups used...

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 Stor...

For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

What are two recommended configuration best practices for backup and recovery on Exadata?

Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

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 en...