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: Mar 27, 2025

Add To Cart

Question 1

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

Question 2

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

Question 3

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 : U query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

B : u 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 : u query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

D : u 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,B

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

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

Page: 1 / 17

Total 85 Questions | Updated On: Mar 27, 2025

Add To Cart