Free Oracle 1Z0-902 Exam Questions

Become Oracle Certified with updated 1Z0-902 exam questions and correct answers

Page: 1 / 17

Total 85 Questions | Updated On: Apr 01, 2026

Add To Cart

Question 1

You are monitoring PMEM cache to see if it is being used effectively with RDMA. Which two of these sources contain information about the RDMA I/O statistics?

A : PMEM Cache Space Usage section in AWR Report

B : PMEM Cache User Reads section in AWR Report

C : Database lOs section in AWR Report

D : Database Statistics (v$ View)

E : Exadata Metrics (LIST METRICCURRENT)

Answer: B,E

Question 2

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 power off the storage server in an Exadata X9M Database Machine?

A : CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

B : CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server

C : 'crsct1 stop cluster -all' on one of the database servers

D : CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server

E : CellCLI alter GRIDDISK all inactive on the affected storage server

F : shutdown -h now' on the affected storage server

Answer: E,F

Question 3

Which statement is FALSE about the OEDA command line interface (OEDACU)?

A : Add nodes to and remove nodes from a VM cluster.

B : Add or remove additional databases.

C : Resize Oracle ASM disk groups.

D : Support ZDLRA life cycle management operation.

E : Add or remove Oracle Database home directories.

F : OEDACU has Edit mode and Deploy mode.

Answer: D

Question 4

You want to examine how much Smart Scan activity is occurring. Which two would provide the information you require?

A : the number of full table scans that accessed the table

B : the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list activerequest command using CELLCLI on all the cells

C : the number of serial queries that accessed the table

D : the number of parallel queries that accessed the table

E : the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list ACTIVEREQUEST command using EXACLI on all the cells

Answer: B,E

Question 5

How do ASM failure groups provide redundancy?

A : Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.

B : Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

C : They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

D : Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

Answer: B

Page: 1 / 17

Total 85 Questions | Updated On: Apr 01, 2026

Add To Cart