Free Oracle 1z0-070 Exam Dumps Questions & Answers

You applied patches to both the storage servers and the database servers in your Exadata X6 Database Machine.
You use Database Replay for a 90-minute workload to verify that there are no performance regressions after applying the patches.
Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?

• A.  SQL trace using dbms_monitor
• B.  cellcli list alerthistory
• C.  cellcli list metriccurrent
• D.  SQL Access Advisor
• E.  cellcli list metrichistory

You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network.
Which two components need to be monitored?

• A.  the Infiniband leaf switches
• B.  the InfiniBand spine switches
• C.  the Cisco 48 port Catalyst Ethernet Switch
• D.  the power distribution units

Which three are true about Exadata Smart Flash Log?

• A.  I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.
• B.  The use of Exadata Smart Flash Logs is mandatory for support of production databases.
• C.  I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.
• D.  Databases on the Database Machine use Exadata Smart Flash Log by default.
• E.  LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.

You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown:
[root@excel04 ~] # imageinfo
Kernel version: 2.6.18-194.3.1.0.4.el5 #1 SMP Sat Feb 19 03:38:37 EST 2011 x86_64 Cell version: OSS_11.2.0.3.0_LINUX.X64_110429.1 Cell rpm version: cell-11.2.2.3.1_LINUX.X64_110429.1-1 Active image version: 11.2.2.3.1.110429.1 Active image activated: 2011-05-09 16:26:36 -0400 Active image status: success Active image partition on device: /dev/md6 Active software partition on device: /dev/md8 In partition rollback: Impossible Cell boot usb partition: /dev/sdm1 Cell boot usb version: 11.2.2.3.1.110429.1 Inactive image version: 11.2.1.2.6 Inactive image activated: 2010-10-04 23:59:16 -0400 Inactive image status: success Inactive system partition on device: /dev/md5 Inactive software partition on device: /dev/md7 Boot area has rollback archive for the version: 11.2.1.2.6 Rollback to the inactive partitions: Possible Which two statements are true about the software and system partitions?

• A.  /dev/md5 and /dev/md7 are located only on physicaldisk 0
• B.  /dev/md6 and /dev/md8 are located only on physicaldisk 1
• C.  /dev/md5 and /dev/md7 have one of their mirror copies on physicaldisk 0
• D.  /dev/md6 and /dev/md8 have one of their mirror copies on physicaldisk 1

Which two Exadata X5 security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A.  Exadata storage realms using database-scoped security mode
• B.  file permissions on the griddisks in each storage server
• C.  Using EXADCLI instead of CELLCLI to create the griddisks
• D.  file permissions on the griddisks in each database server
• E.  Exadata storage realms using ASM-scoped security mode