Free 1z0-070 Exam Dumps

Question 26

Which two statements are true about the X5 Exadata storage server rescue procedure?

A. The rescue procedure can be executed from the CELLBOOT USB flash drive.
B. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
C. The rescue procedure can be used to repair corruption in an ASM diskgroup.
D. The rescue procedure can be used to restore a corrupt system area.
E. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.

Correct Answer:AD
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
References:
http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#GUID-710814E7-469

Question 27

You are evaluating the performance of a SQL statement that accesses a very large table. You run this query:
1Z0-070 dumps exhibit
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. 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.
B. 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.
C. The table is a hash clustered table, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.
D. The table is list partitioned, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.
E. 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.

Correct Answer:CD
C: Scan on a clustered table can prevent a Smart Scan from occur.
D: Scan on an index-organized table can prevent a Smart Scan from occur.
Note: The Cell physical IO interconnect bytes returned by smart scan metric shows how many bytes of I/O were returned by a smart scan to the database server.
References: https://uhesse.com/2011/01/19/exadata-part-i-smart-scan/

Question 28

Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?

A. All Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems.
B. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
C. All Exadata storage servers may run Oracle Virtual Machine (OVM).
D. All Exadata storage servers must run Oracle Linux.
E. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM).

Correct Answer:D
On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
References:
http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-2406241.pdf

Question 29

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. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.
E. Use exachk to schedule itself to run at regular intervals.

Correct Answer:ADE
AD: To schedule exachk, we can create a cron job or we can create a job in Enterprise Manager..
To add an Enterprise Manager job to execute Exachk on a periodic basis. Execute the following steps. First go to Enterprise, Job, Library. Then create a new OS Command job
E: exachk options include AUTORUN_SCHEDULE, which schedules recurring health checks using the AUTORUN_SCHEDULE daemon option.
References:
http://www.oracle.com/technetwork/database/availability/exadata-health-resource-usage-2021227.pdf http://docs.oracle.com/cd/E68491_01/OEXUG/automated-daemon-mode-operation.htm
Best practices: Execute the latest version of the exachk utility before and after planned maintenance activities and at least once every month

Question 30

You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.
You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.
You want to have scripts that contain the appropriate commands to patch your environment. Your patch bundle is one the first database server and is located at /uo1/stage.
You have downloaded the oplan utility to the first database server and run:
$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage
Which two statements are true concerning the type of instructions oplan will generate?

A. Instructions for patching the Grid Infrastructure home on the primary location
B. Instructions for patching the Data Guard environment on the standby location
C. Instructions for patching the RAC Oracle Home on the primary location
D. Instructions for patching only storage servers
E. Instructions for patching all components on the Database Machine

Correct Answer:AC
Oplan generates instructions for all of the nodes in the cluster. Note: