Free Oracle 1z0-070 Exam Dumps Questions & Answers

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 17b
Port status for connector 17B Switch Port 2
Adminstate:......................Enabled
LinkWidthEnabled: ...............1X or 4X
LinkWidthSupported:..............1X or 4X
LinkWidthActive..................4X
LinkSpeedSupported: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps
LinkState: ......................Active
PhysLinkState: ................LinkUp
LinkSpeedActive: ..............10.0 Gbps
LinkSpeedEnabled: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps
You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

• A.  Use Enterprise Manager.Cloud Control.
• B.  Create user-defined metrics for the InfiniBand switch.
• C.  Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root.
• D.  Use Enterprise Manager Express.

Which two are true about Smart Scan?

• A.  Join processing can be partly offloaded to Exadata Storage Servers.
• B.  Join processing can be fully offloaded to Exadata Storage Servers.
• C.  A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
• D.  Column projection does not contribute to the performance benefit of Smart Scan.
• E.  It is possible to offload single row functions to the Exadata Storage Servers.
• F.  A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.

Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size?

• A.  Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.
• B.  cellsrv returns only blocks that have changed since the last backup.
• C.  For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• D.  Enabling Block Change Tracking (BCT) on the database can result in a reduction of physical I/O on the cells during incremental backups.
• E.  For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• F.  Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.

Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

• A.  The Baseboard Management Controller (BMC), which supports IPMI, runs as a single-threaded process on the storage server O/S.
• B.  IPMI can be used for server configuration and management on each database server.
• C.  IPMI can be used for server configuration and management on each storage server.
• D.  The Baseboard Management Controller (BMC), which supports IPMI, runs as a multithreaded process on the storage server O/S.

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

• A.  Sessions querying the table must set cell_offload_processing = true.
• B.  The table must not be compressed.
• C.  It must be heap organized.
• D.  It must be accessed using direct path reads.
• E.  It must be stored in an ASM diskgroup with a 4 MByte AU size.