Oracle Oracle Certifications 1Z0-070 Questions & Answers

• Question 91:

  Which two are true about Smart Scan?

  A. A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.

  B. Column projection does not contribute to the performance benefit of Smart Scan.

  C. A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.

  D. It is possible to offload single row functions to the Exadata Storage Servers.

  E. Join processing can be partly offloaded to Exadata Storage Servers.

  F. Join processing can be fully offloaded to Exadata Storage Servers.

  Correct Answer: DE

  Explanation:

  D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.

  E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.

  References: http://www.centroid.com/blog/exadata-smart-scan-processing

• Question 92:

  An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.

  Identify the two steps that you must perform to replace this failed physical disk.

  A. Add the griddisks back into the ASM diskgroup they used to be a member of.

  B. Create a new celldiskand new griddiskson the replaced physical disk.

  C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

  D. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

  E. Replace the failed physical disk.

  Correct Answer: CE

  Explanation: You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.

  Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.

  References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storageservers.htm#DBMMN21047

• Question 93:

  You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups.

  You want to check for potential space problems that take ASM mirroring requirements into account.

  Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?

  A. cold_used_mb

  B. total_mb

  C. required_mirror_free_mb

  D. free_mb

  E. usable_file_mb

  Correct Answer: BD

  Explanation:

  Determine the Amount of Available Space

  To increase the size of the disks in a disk group you must either have unallocated disk space available, or

  you have to reallocate space currently used by a different disk group.

  Example: View the space currently used by the disk groups.

  SELECT name, total_mb, free_mb, total_mb - free_mb used_mb, round(100*free_mb/total_mb,2) pct_free

  FROM v$asm_diskgroup

  ORDER BY 1;

  

  The example above shows that the DATAC1 disk group has only about 15% of free space available while the RECOC1 disk group has about 87% free disk space. The PCT_FREE displayed here is raw free space, not usable free space. Additional space is needed for rebalancing operations.

  References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administeringasm.htm#SAGUG20526

• Question 94:

  You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.

  A part of the requirement is to provide for high availability of the monitoring infrastructure.

  If the host running the agent that has Database Machine targets bound to it fails, the monitoring of these

  targets must be done by another agent.

  Which three statements are true regarding the configuration used to support this requirement?

  A. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.

  B. Fail back to the original agent when the host is restarted is done automatically.

  C. Fail over to any secondary agent is done automatically.

  D. Fail over to any secondary agent must be done manually.

  E. Database machine plug-ins must be deployed to all Enterprise Manager agents.

  F. Fail back to the original agent when the host is restarted must be done manually.

  Correct Answer: BCE

• Question 95:

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

  A. ASR Manager may be installed on any type of server running Oracle Solaris.

  B. ASR Manager may be installed on any type of server running Oracle Linux.

  C. Oracle Linux must be used on the server where ASR Manager is installed.

  D. SMTP must be enabled on at least one database server.

  E. Oracle Solaris must be used on the server where ASR Manager is installed.

  F. ASR Manager must be installed on one of the database servers.

  G. HTTPS connectivity must be enabled from the ASR Manager host to the Internet.

  Correct Answer: ABG

  Explanation:

  AB: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. This

  server receives fault telemetry information from Oracle Exadata Database Machine servers. This server

  must run an Oracle Solaris or Linux operating system.

  G: Before installing Oracle Auto Service Request (Oracle ASR) you must ensure connectivity to the Internet using HTTPS.

  References: Oracle Auto Service Request Exadata Database Machine Quick Installation Guide

  http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-89192315-1B1A-4B5A-89BB94BB5B6ABB05

• Question 96:

  Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?

  A. mirrored system area on hard disk 0, hard disk 1, and hard disk 2

  B. Exadata Smart Flash Cache using all of the flashdisk space

  C. the DBFS_DG diskgroup with high redundancy

  D. mirrored system area on hard disk 0 and hard disk 1

  E. the RECO_ ASM diskgroup

  F. the DATA_ ASM diskgroup

  Correct Answer: CEF

  Explanation:

  The first two disks of Exadata Storage Server are system disks. Oracle Exadata Storage Server Software

  system software resides on a portion of each of the system disks. These portions on both system disks are

  referred to as the system area.

  The default configuration on Exadata is to have 3 diskgroups - DATA, RECO, and DBFS_DG.

• Question 97:

  You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.

  Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

  A. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.

  B. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.

  C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.

  D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

  Correct Answer: D

• Question 98:

  Examine this list of software components:

  1.

  Oracle Virtual Machine (OVM)

  2.

  Oracle Enterprise Manager Agent (OMA)

  3.

  ASM instance

  4.

  RDBMS instance

  5.

  Automatic Diagnostic Repository Command Interpreter (ADRCI)

  6.

  CELLCLI

  7.

  Cell Server (CELLSRV)

  8.

  diskmon

  Identify the location where these software components can run in the standard Exadata Database Machine deployment.

  A. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.

  B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

  C. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

  D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.

  E. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

  Correct Answer: B

  Explanation:

  Automatic Diagnostic Repository Command Interpreter (ADRCI) can be used on an Exadata storage

  server.

  Incorrect Answers:

  A: The diskmon process is a fundamental component of Oracle Exadata Storage Server Software, and is responsible for implementing I/O fencing. The process is located on the database server host computer, and is part of Oracle Clusterware Cluster Ready Services (Oracle Clusterware CRS).

  D, E: Oracle Virtual Machine (OVM) runs on the database servers.

• Question 99:

  Which two statements are true regarding the use of Auto Service Request (ASR) with an X6 Database Machine?

  A. The database server ILOMs must use SMTP over the management network for notifications to ASR Manager.

  B. The database server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.

  C. The storage server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.

  D. The database server MS process must have SNMP traps configured to use the management network for notifications to ASR Manager.

  Correct Answer: BC

  Explanation:

  B: Database Server ILOM plug-in

  Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the ILOM plug-in, as there is no Management Server (MS) on the database servers to receive SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.

  C: Exadata Storage Server plug-in extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user. For alerts to be sent to the plug-in, SNMP traps are used as follows:

  Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send

  SNMP notifications onward to the plug-in.

  Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent

  to the plug-in using SNMP.

  References:

  https://dbatrain.wordpress.com/2011/06/

  http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

• Question 100:

  You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.

  No virtualization is used and the storage grid has not been partitioned.

  Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

  A. the CELLINIT.ORA files on the database servers in CLUSA

  B. the CELLIP.ORA files on the database servers in CLUSA

  C. the CELLINIT.ORA files on the database servers in CLUSB

  D. the CELLIP.ORA files on all existing Exadata storage servers

  E. the CELLIP.ORA files on the database servers in CLUSB

  F. the CELLIP.ORA files on all newly added Exadata storage servers

  Correct Answer: BE

  Explanation:

  The cellip.ora is the configuration file, on every compute node (database server), that tells ASM instances

  which cells are available to this cluster.

  The cellip.ora file contains the storage cell IP addresses.

  References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-serverconfiguring.htm#SAGUG20369