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: Dec 05, 2025

Add To Cart

Question 1

Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

A : Exadata storage realms using ASM-scoped security mode

B : File permissions on the griddisks in each database server

C : Using EXADCLI instead of CELLCLI to create the griddisks

D : File permissions on the griddisks in each storage server

E : Exadata storage realms using database-scoped security mode

Answer: A,E

Question 2

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

Which of the below is NOT a precaution that should be adhered to in order to ensure the site is safe and ready for

A : Do not use a flathead screwdriver to disconnect connector locks on LAN cables.

B : Be sure that each grounding wire used for Oracle Exadata Rack is used exclusively for Oracle Exadata Rack.

C : Do not install Oracle Exadata Rack near a photocopy machine.

D : Do not place anything on top of Oracle Exadata Rack.

E : When using shared grounding, the grounding resistance must not be greater than 10 ohms.

F : Do not install Oracle Exadata Rack in a location that is exposed to direct sunlight.

Answer: C

Page: 1 / 17

Total 85 Questions | Updated On: Dec 05, 2025

Add To Cart