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: Sep 11, 2025

Add To Cart

Question 1

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, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

A : # lvextend -L +20G —verbose /dev/mapper/VGExaDb-LVDbOral

B : # xfs_growfs /uOl +20G

C : # resize2fs +20G /dev/VGExaDb/LVDbOral

D : # lvextend -L +20G —verbose /dev/VGExaDb/LVDbOral

Answer: A

Question 2

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

Which two actions are NOT appropriate for that purpose?

A : YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

B : You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

C : You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

D : You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

Answer: A,C

Question 3

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 4

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 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: Sep 11, 2025

Add To Cart