Online 1Z0-902 Practice Test

Question 1

Which two options describe the flash memory capabilities of the Exadata X9M-2 database and storage severs?

Options :

A : 4 x 6.4 TB NVMe flash cards on the High Capacity (HC) storage server

B : 4 x 6.4 TB NVMe flash cards on the database server

C : 8x 6.4 TB NVMe flash cards on the Extended (XT) storage server

D : No flash storage on the database server

E : 8 x 6.4 TB NVMe flash cards on the Extreme Flash (EF) storage server

Answer: A,E

Question 2

You want to examine how much Smart Scan activity is occurring. Which two would provide the information you require?

Options :

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

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

Options :

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 4

Which statement is FALSE about the OEDA command line interface (OEDACU)?

Options :

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

Options :

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: E,F

EXPERTY DESIGNED 1Z0-902 PRACTICE TEST