Free Online Oracle 1Z0-902 Practice Test

Prepare Your Oracle 1Z0-902 Exam Questions with Free online 1Z0-902 Practice Test. Get Brilliant Oracle Exadata Database Machine X9M Implementation Essentials Exam Results with Valid 1Z0 902 Exam Dumps.

Page: 1 / 12

Total 60 Questions | Updated On: Apr 22, 2024

Question 1

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

Question 2

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

Question 3

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

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

Page: 1 / 12

Total 60 Questions | Updated On: Apr 22, 2024