Oracle Oracle Certifications 1Z0-070 Questions & Answers

• Question 61:

  Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

  A. There is one plug-in for Cloud Control.

  B. There are several separate plug-ins for Cloud Control.

  C. Some components of the Database Machine require SNMP trap forwarders.

  D. All components of the Database Machine require SNMP trap forwarders.

  Correct Answer: AC

• Question 62:

  Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5?

  A. Improved performance for Oracle Network traffic

  B. Improved reliability for Cache Fusion RAC network traffic

  C. Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands

  D. Improved performance for ASM rebalance network traffic

  E. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands

  Correct Answer: BC

  Explanation:

  Active-passive bonding provides reliability through failover.

• Question 63:

  You are patching your Exadata X6 Database Machine by applying a new image to the Storage Servers in a rolling fashion.

  Your ASM environment on the Database Machine has five diskgroups stored on an unpartitioned Exadata storage grid, with redundancy settings as shown:

  1.

  DATA_DBM1 – Normal Redundancy

  2.

  RECO_DBM1 – Normal Redundancy

  3.

  DBFS_DG – Normal Redundancy

  4.

  DATA2_DBM1 – High Redundancy

  5.

  DATA3_DBM1 High Redundancy

  Which two diskgroups will not suffer from any data loss throughout the patching process even if there is a single disk failure on one of the cells

  A. DBFS_DG

  B. DATA3_DBM1

  C. DATA2_DBM1

  D. DATA_DBM1

  E. RECO_DBM1

  Correct Answer: DE

  Explanation:

  HIGH redundancy provides protection against 2 simultaneous disk failures from 2 distinct storage servers

  or 2 entire storage servers. HIGH redundancy provides redundancy during Exadata storage server rolling

  upgrades.

  References: http://blog.umairmansoob.com/choosing-high-vs-normal-redundancy-with-exadata/

• Question 64:

  Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?

  A. ASR Manager software may be installed on one of the database servers in the Database Machine.

  B. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.

  C. ASR Manager can connect to the Internet directly with HTTPS.

  D. ASR Manager can connect to the Internet with HTTPS using a proxy server.

  E. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).

  F. ASR Manager software may be installed on a server that is not part of the Database Machine.

  Correct Answer: ACDF

  Explanation: C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.

  D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.

  References: https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#ASRUD137

• Question 65:

  As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.

  Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?

  A. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.

  B. The database grid may be partitioned when deploying a multirack Database Machine configuration.

  C. A single database cluster benefits from accessing multiple storage grids.

  D. Multiple database clusters may access the same storage grid.

  E. Multiple database clusters never benefit from accessing a single storage grid.

  Correct Answer: BCD

• Question 66:

  In which three situations will a Smart Scan occur on a table for which Smart Scan is possible, assuming that nothing in the environment prevents a Smart Scan?

  A. The ASM diskgroup containing the table's tablespace has a 4 MByte AU size.

  B. Executing queries in parallel.

  C. setting _serial_direct_read= true in the session issuing the SQL statements and executing a serial query.

  D. Having direct path reads used at execution time.

  E. An update to the table is made identifying the row to be modified by primary key.

  F. An index range scan occurs for the table.

  Correct Answer: BCD

  Explanation: Whether you get a direct path read and smart scan, depends on the current buffer cache size, how big segment you’re about to scan and how much of that segment is actually cached at the moment. This dynamic decision unfortunately can cause unexpected surprises and variance in your report/batch job runtimes.

  To work around these problems and force a direct path read/smart scan, you can either:

  1.

  (B) Run your query in parallel as parallel full segment scans will use direct path reads, unless your parallel_degree_policy = AUTO, then you may still get buffered reads thanks to the dynamic in-memory parallel execution decision of Oracle 11.2

  2.

  (C) Run your query in serial, but force the serial direct path reads by setting _serial_direct_read = TRUE (or ALWAYS in 11.2.0.2+)

  D: One of the most common Exadata performance problems is that the direct path reads (and thus also Smart Scans) don't sometimes kick in when running full scans in serial sessions.

  Note: Smart Scan is a subset of Cell Offload Processing and is perhaps the feature that is most highly associated with Exadata. Smart Scan allows Oracle databases to push query information down to the storage level, specifically:

  1.

  Filtration (predicate information)

  2.

  Column Projection

  3.

  Join Filtering

  Incorrect Answers:

  F: Objects such as clusters and index organized tables cannot be Smart Scanned.

  References: http://blog.tanelpoder.com/2013/05/29/forcing-smart-scans-on-exadata-is-_serial_direct_readparameter-safe-to-use-in-production/

• Question 67:

  Which three are true concerning Exadata snapshot databases?

  A. They are supported on non-container databases.

  B. They are based on a read-write copy of an existing database.

  C. They are integrated with the Multitenant architecture.

  D. They can be created only on sparse ASM disk groups.

  E. They don't support all Exadata features.

  F. They can be created on any type of ASM disk group.

  Correct Answer: ACD

  Explanation:

  A: An Exadata snapshot database can be either a non-container database (non-CDB) or a container database (CDB). Creating an Exadata snapshot database of a CDB enables access to all of the pluggable databases in that container.

  C: You can create two types of Exadata snapshots, depending on the current setup of your environment:

  1.

  You have a pluggable database (PDB) and want to create a test master from it.

  2.

  You have a container database (CDB) and want to create test masters from all its PDBs, or you have a simple non-container database and want to create a test master from it.

  D: SPARSE disk group based database snapshots is functionality included in Exadata Storage Software. It requires Exadata Storage Software version 12.1.2.1.0 and Oracle Database 12c version 12.1.0.2 with bundle patch 5 or later. This feature is designed to work on native Exadata ASM storage disk groups. It uses ASM SPARSE grid disk based thin provisioning where snapshot databases created on a SPARSE disk group need only the space for changes plus some metadata, thereby enabling storage efficient snapshot databases.

  References:

  http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG-GUIDE1D6EF45-36EF-40E3-A57E-F80B749E6122 http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf

• Question 68:

  Which two statements are true about data paths used during RMAN backup and restore operations when media management servers use InfiniBand to connect to an X5 Database Machine?

  A. During backups, data blocks are always read from Smart Flash Cache by cellsrv.

  B. During restores, data blocks read from the media are sent to a database server that sends the blocks to cellsrv to be written.

  C. During backups, data blocks are read by cellsrv and sent to a database server, which sends the blocks to the media manager to be written to media.

  D. During backups, data blocks are read by cellsrv and sent directly to the media manager to be written to media.

  E. During restores, data blocks read from the media are sent directly to cellsrv to be written.

  Correct Answer: DE

  Explanation:

  The fastest database backup is achieved via InfiniBand.

  1.

  Get dedicated Media Servers that connect to tape library

  2.

  Offers backup rates of up to 12GB/sec

  RMAN does not back up directly to tape. However, it will integrate with media management software such as Oracle Secure Backup and utilize their capabilities to manage tape libraries.

  Exadata Database Machine: The Database Machine contains the databases that need to be backed up. Oracle RMAN is the only mechanism to back up the databases that utilize Exadata Storage Servers as the storage. RMAN processes run on the database servers and interact with the Oracle Secure Backup (OSB) agent, which further interacts with the media management software and enables RMAN to communicate with the tape library.

  References: http://apprize.info/data/oracle_4/6.html

• Question 69:

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

  A. IPMI can be used for server configuration and management on each database server.

  B. The Baseboard Management Controller (BMC), which supports IPMI, runs as a multithreaded process on the storage server O/S.

  C. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single-threaded process on the storage server O/S.

  D. IPMI can be used for server configuration and management on each storage server.

  Correct Answer: AC

  Explanation:

  A: IPMI – short for Intelligent Platform Management Interface – is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It's not an Exadata command but rather a general Linux one. To power on a cell or database server, issue this from another server: # ipmitool -H prolcel01-ilom -U root chassis power on To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now

  C: Like the KCS interface, the SSIF Interface is only specified as a ‘Single Threaded Interface’ for standard IPMI commands. That is, the BMC implementation is not expected to process more than one IPMI request at a time. While an implementation is allowed to have a degree of ‘command queuing’, for standard IPMI messages the SSIF lacks a ‘Seq’ field that software can use to match up particular instances of requests with responses.

  References: https://www.intel.com/content/dam/www/public/us/en/documents/specification-updates/ipmiintelligent-platform-mgt-interface-spec-2nd-gen-v2-0-spec-update.pdf

• Question 70:

  Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?

  A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

  B. Configuring ASR is mandatory for all Database Machine assets.

  C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.

  D. ASR Manager must be installed and configured on one of the database servers.

  E. ASR can upload configuration metadata to support problem resolution.

  F. ASR communicates with Oracle support services using HTTPS.

  Correct Answer: AC

  Explanation:

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

  C: Oracle ASR is designed to generate Oracle service requests automatically when certain types of faults are detected on Oracle products that are qualified for Oracle ASR.

  Oracle ASR works only for specific component faults. Most of the common components, such as disks, fans, and power supplies, are covered. However, some components are not covered. For example, Oracle ASR does not cover InfiniBand events; there are specific images and specific InfiniBand switch firmware that you must use. You cannot upgrade these components independently.

  Incorrect Answers:

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

  References: http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-490B2837-C608-4626-B4FF59F679C36302