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: Jan 09, 2025

Add To Cart

Question 1

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 2

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

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 3

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

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 4

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

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

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

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

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

E : en 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 options describe the flash memory capabilities of the Exadata X9M-2 database and storage severs?

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

Page: 1 / 17

Total 85 Questions | Updated On: Jan 09, 2025

Add To Cart