1z0-902 Practice Test

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.

Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

A.

2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network

B.

2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network

C.

2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network

D.

2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network

Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

A.

OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.

B.

There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

C.

OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

D.

OEDA sets up key-based authentication for the root user by using the setuprootssh.shutility included with OEDA.

Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

A.

SQL Plan Quarantine

B.

Manually created Quarantine

C.

Database Quarantine

D.

Disk Region Quarantine

E.

Cell Offload Quarantine

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.