Which two methods would you use to check the status of all 36 ports?

You are checking the status of the ports on one of the InfiniBand switches on your X5 Database Machine.You run the getportstatus command as shown:[root@exampsw-ib2 bin] # getportstatus 17bPort status for connector 17B Switch Port 2Adminstate:………………….EnabledLinkWidthEnabled: ……………1X or 4XLinkWidthSupported:…………..1X or 4XLinkWidthActive………………4XLinkSpeedSupported: ………….2.5 Gbps or 5.0 Gbps or 10.0 GbpsLinkState: ………………….ActivePhysLinkState: …………….LinkUpLinkSpeedActive: …………..10.0 GbpsLinkSpeedEnabled: ………….2.5 Gbps […]

Read More

Which three access paths always generate “cell single block physical read” or “cell multiblock physical read”

An important application has been migrated to a database on an X5 Database Machine.You are examining high-load SQL statements from this application, in an attempt to determine which ones willbenefit from the Exadata Smart Scan capability.Which three access paths always generate “cell single block physical read” or “cell multiblock physical read”requests? A. Index fast full […]

Read More

Which two statements are true about Exadata X5 cell metrics and alerts?

Which two statements are true about Exadata X5 cell metrics and alerts? A. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository. B. Cell metrics are written to disk every hour by default. C. Cell metrics on each storage server are accumulated in memory […]

Read More

Which three statements are true about the EXADCLI utility?

Which three statements are true about the EXADCLI utility? A. It may be run interactively. B. It can be used to execute EXACLI scripts on multiple storage servers in parallel. C. It can be used to execute O/S commands on multiple storage servers in parallel. D. It can be used to execute EXACLI commands on […]

Read More

How would you achieve this?

A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.The script must run on each cell simultaneously.How would you achieve this? A. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command. B. […]

Read More

Which three must be true for a Smart Scan to occur for a table?

Which three must be true for a Smart Scan to occur for a table? A. cell_offload_processing must be true in sessions issuing SQL statements that access the table. B. The query must be executed serially. C. The query must be executed in parallel. D. Direct path reads must be used at run time. E. The […]

Read More