Question 1

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

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?

Options :

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 4

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

Options :

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

Free 1Z0-902 Mock Exam – Practice Online Confidently

Buying Options: