1z1-070 試験問題を無料オンラインアクセス

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 CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
• B.Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
• C.Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.
• D.Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.
• E.Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.

You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.
No virtualization is used and the storage grid has not been partitioned.
Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

• A.the CELLIP.ORA files on the database servers in CLUSA
• B.the CELLIP.ORA files on all newly added Exadata storage servers
• C.the CELLIP.ORA files on all existing Exadata storage servers
• D.the CELLINIT.ORA files on the database servers in CLUSB
• E.the CELLINIT.ORA files on the database servers in CLUSA
• F.the CELLIP.ORA files on the database servers in CLUSB

Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle's recommended best practices.
Which three actions could you take to do this?

• A.Use a cron job on a database node to run it at regular intervals.
• B.Use a cron job on each cell to run it at regular intervals.
• C.Run it once each cell and it will then perform periodic monitoring automatically.
• D.Use exachk to schedule itself to run at regular intervals.
• E.Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.

A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns.
Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table?

• A.Virtual column filtering
• B.Column filtering
• C.Predicate filtering
• D.MIN/MAX scans
• E.Nested loop join filtering
• F.Sort-merge join filtering

Which three are true concerning Storage Indexes?

• A.A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.
• B.A maximum of eight table columns for any table are indexed per storage region.
• C.The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
• D.Different storage regions may have different columns indexed for the same table.
• E.Storage Indexes persist across any Exadata storage server reboots.
• F.The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.