Oracle 1Z0-027 Online Practice Questions and Exam Preparation

Oracle 1Z0-027 Online Questions & Answers

• Question 61:

  You configuring has two half racks, one with high capacity disks and other with high performance disks and high capacity expansion half rack.

  There are two RAC clusters, one on each half rack, which have separate storage grids, each consisting of some of the storage servers in the configuration.

  You are planning your deployment of Enterprise Manager to monitor all the components of this multi-rack Database Machine, and must provide for high availability of the monitoring infrastructure.

  If the host running the agent which has database machine targets bound to it fails, the monitoring of these targets must be another agent.

  Which two are true regarding the configuration used to support this?

  A. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.
  B. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary agent.
  C. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.
  D. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary agent.
  E. A secondary agent must be deployed on a database server in a different cluster than the server hosting the primary agent.
  F. Enterprise Manager support must be deployed to at leasttwoEnterprise Manager Agents in each of the two RAC clusters.
  A. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.
  D. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary agent.

  ---

  Note: *Instructions for configuring a high availability solution for the Exadata Storage cell orany other Exadata plug-in are documented in the Oracle Database Machine Monitoring Best Practices (Doc ID 1110675.1) document located in My Oracle Support *High Availability for Plug-Ins Normally a plug-in target is bound to a specific agent If the agent is down the target cannot be monitored A procedure exists to facilitate target failover to a secondary agent

  *The Enterprise Manager agent must be deployed to all compute nodes of the Exadata Database Machine.

  *The Oracle ILOM plug-in monitors the Oracle ILOM service processor in a compute node for hardware events and records sensor data to the Oracle Enterprise Manager Repository.

  The ILOM plug-in is deployed to the Enterprise Manager (EM) Agent on the first compute node in an Oracle Database Machine, and only that EM agent communicates with the EM Management Server and Repository for all ILOM database

  server service processors in the Oracle Database Machine.

  *OEM Agent and Exadata Plug-ins

  1. OEM Agent and Plug-Ins are deployed under Oracle Home

  2. Agent incorporates additional functionality in Plug-In

  3. Agent and Plug-in DB Server on Exadata DBM

  3. Agent and Plug-in communicates with Storage Server

  4. Plug-Ins are available for monitoring all Exadata hardware components

  5. OEM Agent communicates with the OEM

• Question 62:

  You have a partitioned database grid on an X3-2 full rack with two four-node RAC clusters called CLUSA and CLUSB. The storage grid, however, has not been partitioned.

  Which files on which servers must be modified after connecting an Exadata storage full expansion racktoyour X3-2 Exadata Database Machine on the InfiniBand network so that the cells on the expansion rack are added to the storage grid?

  A. The CELLINIT.ORA files on 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 and newly added Exadata storage servers.
  E. The CELLIP.ORA files on the database servers in CLUSB
  B. The CELLIP.ORA files on the database servers in CLUSA
  E. The CELLIP.ORA files on the database servers in CLUSB

  ---

  Note:

  *cellinit.ora, cellip.ora

  -- on database server

  cellinit.ora - identifies the storage network interface on the database server cat /etc/oracle/cell/network-config/cellinit.ora

  cellip.ora - identifies the Exadata cells that are accessible to the database server cat /etc/oracle/cell/network-config/cellip.ora

  *The cellip.ora is the configuration file, on every compute node, that tells ASM instances which cells are available to this cluster.

  Here is a content of a typical cellip.ora file for a quarter rack system:

  $ cat /etc/oracle/cell/network-config/cellip.ora

  cell="192.168.10.3"

  cell="192.168.10.4"

  cell="192.168.10.5"

• Question 63:

  Which type of network traffic is transported over the internal InfiniBand network in a Database Machine?

  A. IDB protocol traffic only
  B. Both Clustered ASM and RAC database instance traffic
  C. Clustered ASM Instance traffic only
  D. RAC database instance traffic only
  E. IDB protocol traffic,Clustered ASM traffic, and RAC database instance traffic
  A. IDB protocol traffic only

  ---

  The Exadata software is optimally divided between the database servers and Exadata

  cells. The database servers and Exadata Storage Server Software communicate using the iDB ?

  the Intelligent Database protocol. iDB is implemented in the database kernel and transparently

  maps database operations to Exadata-enhanced operations. iDB implements a function shipping

  architecture in addition to the traditional data block shipping provided by the database. iDB is

  used to ship SQL operations down to the Exadata cells for execution and to return query result

  sets to the database kernel. Instead of returning database blocks, Exadata cells return only the

  rows and columns that satisfy the SQL query. Like existing I/O protocols, iDB can also directly

  read and write ranges of bytes to and from disk so when offload processing is not possible Exadata operates like a traditional storage device for the Oracle Database. But when feasible, the

  intelligence in the database kernel enables, for example, table scans to be passed down to execute

  on the Exadata Storage Server so only requested data is returned to the database server. iDB is built on the industry standard Reliable Datagram Sockets (RDSv3) protocol and runs over

  InfiniBand. ZDP (Zero-loss Zero-copy Datagram Protocol), a zero-copy implementation of RDS, is used to eliminate unnecessary copying of blocks. Multiple network interfaces can be used on the database servers and Exadata cells. This is

  an extremely fast low-latency protocol that minimizes the number of data copies required to service I/O operations.

  Note:

  *The Database Machine uses a state of the art InfiniBand interconnect between the servers and

  storage. Each database server and Exadata cell has dual port Quad Data Rate (QDR) InfiniBand

  connectivity for high availability.

  *The same InfiniBand network also provides a high performance cluster interconnect for the Oracle Database Real Application Cluster (RAC) nodes.

  Note:

  *An InfiniBand network allows you to connect multiple Oracle Exadata Database Machines to form a larger single system image configuration; each InfiniBand link provides 40 Gigabits of bandwidth璵any times higher than traditional storage or server networks

• Question 64:

  Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine?

  A. SNMP traps for alerts are sent by the storage server ILOM to the storage serverMSprocess
  B. SNMP traps for alerts are sent by the storage serverMSprocess to the storage server ILOM
  C. SNMP traps for alerts are sent by the storage serverILOMto the Enterprise Manageragent.
  D. SNMP traps for alerts are sent by the storage serverMSprocess to the enterprise Manageragent
  E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.
  A. SNMP traps for alerts are sent by the storage server ILOM to the storage serverMSprocess
  D. SNMP traps for alerts are sent by the storage serverMSprocess to the enterprise Manageragent

  ---

  There are two types of server alerts that come from Oracle Exadata Storage Server:

  *

  (A)For Integrated Lights Out Manager (ILOM)-monitored hardware components, ILOM reports a failure or threshold exceeded condition as an SNMP trap, which is received by MS.

  MS processes the trap, creates an alert for the storage server, and delivers the alert via SNMP

  to Oracle Enterprise Manager 12c.

  *

  (D)For MS-monitored hardware and software components, MS processes a failure or threshold

  exceeded condition for these components, creates an alert, and delivers the alert via SNMP to

  Oracle Enterprise Manager Cloud Control 12c.

  Reference:Managing Oracle Exadata with Oracle Enterprise Manager 12c, Oracle White Paper

• Question 65:

  To troubleshoot a possible hardware problem, you consider moving all disk drives from one Exadata storage server to a replacement chassis.

  You must contain storage availability while performing task.

  The Exadata storage server is an X3-8 Database Machine and storage grid is not partitioned.

  Which two factors would prevent you from moving the disks from one Exadata storage server to another one?

  A. The existence of an external redundancy ASM diskgroup
  B. The existence of a normal redundancy ASM diskgroup
  C. The existence of an ASM diskgroup with the repair_time attribute set to 0.
  D. The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
  E. Offline or inactive celldisks in another Exadata server
  A. The existence of an external redundancy ASM diskgroup
  D. The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0

  ---

  A:If you want Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). You specify EXTERNAL

  REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY if you want to use storage array protection features.

  D:Restoring the redundancy of an Oracle ASM disk group after a transient disk path failure can be time consuming. This is especially true if the recovery process requires rebuilding an entire Oracle ASM failure group. Oracle ASM fast mirror

  resync significantly reduces the time to resynchronize a failed disk in such situations. When you replace the failed disk, Oracle ASM can quickly resynchronize the Oracle ASM disk extents.

  To use this feature, the disk group compatibility attributes must be set to 11.1 or higher.

  Incorrect:

  Not C:You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.

  Note:

  *The redundancy levels are:

  /External redundancy

  Oracle ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error cause a forced dismount of the disk group. All disks must be located to successfully mount the disk group.

  /Normal redundancy

  Oracle ASM provides two-way mirroring by default, which means that all files are mirrored so that there are two copies of every extent. A loss of one Oracle ASM disk is tolerated. You can optionally choose three-way or unprotected mirroring.

  /High redundancy

  Oracle ASM provides triple mirroring by default. A loss of two Oracle ASM disks in different failure groups is tolerated.

  Reference:Administering Oracle ASM Disk Groups

• Question 66:

  You are about to run the oplan utility to patch the servers on your test Database Machine before patching the production environment.

  The following task might be performed:

  A. Test the failback procedure
  B. Run the exachk utility
  C. Read the README file.
  D. Automate the patch application process as appropriate.
  E. Verify that the patch provides the functionality it is meant to.
  F. Apply the patch.
  G. Evaluate the system performance. In which order should the tasks be performed to patch in the recommended fashion?
  H. C, B, D, F, B, E, A
  I. C, D, F, B, E, G, A, B
  J. C, B, D, F, E, G, A
  B. Run the exachk utility

  ---

  Note: *Schedule regular health checks with Exachk Detects bad disks, faulty hardware, incorrect configuration At least every 90 days Before and after patching/upgrades Follow recommended best practices

  *we are recommending running exachk or Healthcheck (depending on your DBM/Exadata model) *before* maintenance and *after* maintenance.

• Question 67:

  Which two may act as building blocks for the creation of two or more griddisks residing on the same physical device and which have more balanced performance characteristics?

  A. griddisk on hard drive-based intervleaved celldisks.
  B. griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent Data Placement (IDP)
  C. griddisk on hard drive-based non-interleaved celldisks.
  D. griddisk on Flash-base celldisks.
  A. griddisk on hard drive-based intervleaved celldisks.
  B. griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent Data Placement (IDP)

  ---

  A (not C):Interleaved Griddisks mean equally fast Griddisks, whereas with non Interleaved Griddisks (the default) the Griddisks created first are being taken from the outer tracks of the underlying physical disk.

  B:Intelligent Data Placement, a feature of ASM that allows placing data in such a way that more frequently accessed data is located close to the periphery of the disk where the access is faster.

• Question 68:

  What is the benefit of bonding the client access network configuration?

  A. Improved performance
  B. Improved reliability
  C. Both improved performance and reliability
  D. A Single Client Access Name (SCAN)
  E. Improved monitoring
  C. Both improved performance and reliability

  ---

  The network ports can be connected directly between the components or the ports can be bonded together to form a logical interface. The bonded ports can be configured for load balancing, fault tolerance, and better network utilization

  Reference:Oracle Exadata Database Machine -Backup and Recovery Sizing:Tape Backups

• Question 69:

  Consider thefollowingsequence of CELLCLI commands and SQL statements:

  

  All CELLCLIcommandsand SQL statements are executedsuccessfullywithout warnings. Which statement is true about the I/O performance of the DATA01 ASM diskgroups?

  A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first.
  B. The DATA02 ASM diskgroup has better performance because the DATA02 diskgroups was created first.
  C. The DATA01 diskgroup has better performance because the DATA01 griddisks are created on interleaved cell disks.
  D. The performance of both diskgroups is balanced because they are created on interleaved griddisks.
  A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first.

  ---

  Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer

  sectors of the underlying Harddisk. It will have the best performance therefore

  Incorrect:

  Not D: non-interleaved is the default.

• Question 70:

  Identify three valid configuration options that can be implemented during the initial configuration process ofanew Database Machine by using the Exadata Deployment Assistant

  A. database character set
  B. size of the RECO ASM diskgroup
  C. size of the DBFS diskgroup
  D. O/S owner mode (standard O/S authentication or role-separated O/S authentication)
  E. RDBMS DBA group name
  B. size of the RECO ASM diskgroup
  D. O/S owner mode (standard O/S authentication or role-separated O/S authentication)
  E. RDBMS DBA group name

  ---

  D: Determine which OS owner mode to use