Online Access Free 1z0-070 Practice Test

Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?

• A.Oracle Solaris must be used on the server where ASR Manager is installed.
• B.ASR Manager may be installed on any type of server running Oracle Solaris.
• C.HTTPS connectivity must be enabled from the ASR Manager host to the Internet.
• D.SMTP must be enabled on at least one database server.
• E.ASR Manager must be installed on one of the database servers.
• F.Oracle Linux must be used on the server where ASR Manager is installed.
• G.ASR Manager may be installed on any type of server running Oracle Linux.

Examine this IORM plan:

Which two are true concerning this plan?

• A.I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.
• B.I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.
• C.If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.
• D.The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
• E.If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.

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

• A.Direct path reads must be used at run time.
• B.The query must be executed in parallel.
• C.The ASM diskgroup containing the table's tablespace must have cell.smart_scan_capable set to true.
• D.cell_offload_processing must be true in sessions issuing SQL statements that access the table.
• E.The query must be executed serially.
• F.The ASM diskgroup containing the table's tablespace must have a 4 Mbyte AU size.

Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?

• A.All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.
• B.All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.
• C.Some SNMP notifications may be configured using the alter cell command on the storage servers.
• D.All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.
• E.The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.
• F.Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.

You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5 Database Machine?

• A.CellCLI> ALTER GRIDDISK ALL INACTIVE
• B.'crsctl stop cluster -all' on one of the database servers
• C.CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
• D.'shutdown -h now' on the affected storage servers
• E.CellCLI> LIST GRIDDISK WHERE STATUS != 'inactive'