Online Access Free 1z1-070 Exam Questions

You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.
Which three statements are true about this configuration?

• A.When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
• B.When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
• C.Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.
• D.Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.
• E.Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.
• F.Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to the ASR Manager.

Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?

• A.Storage server flash device drivers
• B.Linux operating system on the storage server
• C.Storage server hard disk device drivers
• D.InfiniBand HCA firmware on the storage server

Examine this IORM plan:

Which two are true concerning this plan?

• A.If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
• B.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.
• 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.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.
• E.The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.

You are planning the migration of a large data warehouse to a Little Endian X6 Database Machine using which is running database version 12.2.0.1.
The current database version is Oracle Database 11.2.0.4.0 hosted on a Big Endian platform.
The current database characterset is WE8ISO8859P15.
Which two migration methods are supported?

• A.Data Pump
• B.Logical Standby database
• C.cross-platform Transportable Database
• D.Physical Standby database

You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:

Identify two reasons why the "cell physical IO interconnect bytes" statistic is greater than the "cell physical IO interconnect bytes returned by smart scan" statistic.

• A.The table is a hash clustered table, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.
• B.The table is list partitioned, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
• C.There are chained rows in the table, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.
• D.There is a local index on a list partitioned table on the column used in the WHERE clause, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
• E.There is a transaction, which committed after the query began, that has modified some of the table blocks, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.