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: May 23, 2026

Add To Cart

Question 1

Which three statements are true about the CELLCLI command?

A : It can execute commands on multiple storage servers in parallel.

B : It has command-line history.

C : It requires root privileges to create CELLDISKS and GRIDDISKS.

D : It can be executed on storage servers.

E : It can be executed using the DCLI utility.

Answer: B,D,E

Question 2

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 3

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

A : With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.

B : With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.

C : With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.

D : With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

Answer: D

Question 4

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

A : Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

B : Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.

C : When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

D : Before write-back flash cache is enabled, you need to drop the Flash Cache first.

E : When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.

Answer: A,D

Question 5

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

Page: 1 / 17

Total 85 Questions | Updated On: May 23, 2026

Add To Cart