Oracle 1Z0-027 Online Practice Questions and Exam Preparation

Oracle 1Z0-027 Online Questions & Answers

• Question 11:

  Which is true regarding Enterprise Managermonitoring and configuration?

  A. Agents must be deployed on the- storage servers, in case all the database servers are down.
  B. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents, but additional ethernet cables are required to connect the PDUs to the internal network switch in the Database Machine
  C. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.
  D. Agents may be deployed on the storage servers, in case all the database servers are down.
  E. Monitoring the power distribution units (PDUS) is done by Enterprise Manager agents but additional ethernet cables are required to connect the PDUs to the corporate network switch.
  C. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.

  ---

  Note:

  *The following prerequisites must be met before you can deploy the plug-in:

  Set and validate the preferred credentials on all Agents where you want to deploy the plug- in. This is essential in order to deploy the plug-in.

  The PDU firmware version must be 1.02 or later.

  *This plug-in will be used to monitor PDU's actual current value of Phase1, Phase2, and Phase3 and raises appropriate events if they have crossed the different threshold values. Each PDU will have a plug-in instance added to its own OEM

  Grid Control agent.

  By deploying the plug-in to your Grid Control environment, you gain the following management features:

  Monitor PDU targets.

  Raise alerts and violations based on thresholds set on monitoring and configuration data.

  Provide rich out-of-box metrics and reports based on the gather

  Reference:Oracle Enterprise Manager System Monitoring Plug-In Installation Guide for Exadata Power Distribution Unit

• Question 12:

  Identify the correct sequence of commands to completely power off a Database Machine in an orderly fashion: Execute "crsctl stop cluster -all" as the grid user from one database server. Execute "crsctl stop cluster -all" as the root user from one database server. Power off all network switches using their power switch. Execute "crsctl stop cluster -all" as the root user from one database server. Execute "crsctl stop cluster -all" as the grid user from one database server. Power off the rack using the power switches on the PDUs. Execute "shutdown -h now" on all database servers. Execute "shutdown -h now" on all Exadata storage servers. Execute "shutdown -h now" on all servers.

  A. 1, 9, 3 and 6
  B. 2, 9 and 6
  C. 4, 7, 8, 3 and 6
  D. 5, 8, 7, 3 and 6
  E. 2, 8, 7, 3 and 6
  F. 1, 8, 7, 3 and 6
  G. 2, 7, 8 and 6
  H. 2, 8, 7 and 6
  E. 2, 8, 7, 3 and 6

  ---

  2,8, 7,3, 6

  Note:

  *(step 1)With root user, from $ORA_CRS_HOME, shutdown the CRS:

  /crsctl stop cluster

  *Here is the command to stop the cluster on all nodes:

  # /bin/crsctl stop cluster -all

  *To stop a server, use the shutdown command. To stop immediately and keep it down, i.e.

  not reboot, execute:# shutdown -h -y now

• Question 13:

  Which four statements are true about Exadata Smart Flash Cache?

  A. Smart Scan will always be done for I/Os to flash based griddisks.
  B. Flash based ASM diskgroups may share space with the Flash Cache on the flashdisks.
  C. Single block reads can benefit from Smart Flash Cache.
  D. Smart Scan will never be done for I/Os to flash based griddisks.
  E. Multiblock reads can benefit from Smart Flash Cache.
  F. Smart Flash Logs reduce the size of Smart Flash Cache.
  B. Flash based ASM diskgroups may share space with the Flash Cache on the flashdisks.
  C. Single block reads can benefit from Smart Flash Cache.
  E. Multiblock reads can benefit from Smart Flash Cache.
  F. Smart Flash Logs reduce the size of Smart Flash Cache.

  ---

  B: *Grid disks (the logical disks that reside on physical cell disks) are created on these flash-based cell disks and the grid disks areassigned to an Automatic Storage Management (ASM) diskgroup. The best practice would be to reserve the same amount of flash on each Exadata cell for flash disks and have the ASM diskgroup spread evenly across the Exadata cells in the configuration just as you would do for regular Exadata grid disks. This will evenly distribute the flash I/O load across the Exadata cells and flash.

  Note: *The Exadata Storage Server comes with a substantial amount of flash storage. A small amount is allocated for database logging and the remainder will be used for caching user data

• Question 14:

  You must drop all celldisks on all the cells in a quarter rack as part of a reconfiguration project, to support normal redundancy interleaving.

  Select two actions that describe the operating system (O/S) account on the cells to which you should log in, and the tool that may be used to drop the celldisks.

  A. To the CELLMONITOR account using CELLCLI interactively on each cell.
  B. To CELLADMIN account calling CELLCLI on all cells using DCLI
  C. To either the CELIMONITOR or the CELLADMIN account calling CELLCLI on all cells using DCLI
  D. To the CELLMONITOR account calling CELLCLI on all cells using DCLI
  E. To the CELLADMIN account using CELLCLI interactively on each cell
  F. To either the CELLMONITOR or CELLADMIN account calling interactively on each cell
  B. To CELLADMIN account calling CELLCLI on all cells using DCLI
  E. To the CELLADMIN account using CELLCLI interactively on each cell

  ---

  Note:

  *Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type "cellcli". Within cellcli, a wide

  range of commands can be invoked to monitor the cell.

  *While connected to cellcli as the Linux account celladmin, you can perform all cellcli commands except calibrate.

  While logged into the cell server as cellmonitor, you can do any "read-only" commands; you cannot change any configuration or attributes.

• Question 15:

  Which two are true about Exadata storage server alerts?

  A. Metric alerts are never stateful.
  B. Metrics have no thresholds set on them by default.
  C. SNMP alert notifications can be sent to only one destination.
  D. Metric threshold; if set, will persist across storage server reboots.
  E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents
  D. Metric threshold; if set, will persist across storage server reboots.
  E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents

  ---

  Incorrect:

  Not A: there are both stateful and stateless alerts.

  Not B: Metrics have defaults.

  Not C: An SNMP alert can have multiple destinations.

• Question 16:

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

  A. HTTPS connectivity must be enabled from the ASK Manager host to the internet.
  B. ASR Manager must be installed on one of the database servers.
  C. Oracle Solaris must be used on the server where ASK Manager is installed.
  D. SMTP must be enabled on at least one database server.
  E. Oracle Linux must be used on the server where ASR Manager is installed
  F. ASRManager may be installed on any type of server running Oracle Linux.
  G. ASRManager may be installed on any type of server running Oracle Solaris.
  A. HTTPS connectivity must be enabled from the ASK Manager host to the internet.
  F. ASRManager may be installed on any type of server running Oracle Linux.
  G. ASRManager may be installed on any type of server running Oracle Solaris.

  ---

  A:Before installing ASR, please ensure the following conditions are met:

  / (A)Ensure connectivity to the Internet using HTTPS. /Make sure you have access to My Oracle Support and that your contact information is correct and current.

  /Make sure all of your assets have a Contact assigned and that the contact is correct and current.

  /Identify and designate a system to serve as ASR Manager.

  /Identify and verify ASR assets.

  F, G (not C, not E, not B):The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must

  run Solaris or Linux as the operating system.

  Reference: OracleAuto Service Request Exadata Database Machine Quick Installation Guide

• Question 17:

  Consider the following list of software components:

  1.DCLI

  2.Management Server (MS)

  3.ASM Instance

  4.RDBMS instance

  5.Restart Server (RS)

  6.Cellcli

  7.Cell Server (CELLSRV)

  8.Diskmon

  Identify the location where these software components may run in the standard Database machine deployment.

  A. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata Storage servers.
  B. 4 and 8 run on the database servers; 1, 2, 3, 5, 6 and 7 run on the Exadata Storage servers.
  C. 1, 3 and 4 run on the database servers; 2, 5, 6, 7 and 8 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. 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
  F. 1, 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
  B. 4 and 8 run on the database servers; 1, 2, 3, 5, 6 and 7 run on the Exadata Storage servers.

  ---

  *

  (not C or notF):Exalogic includes a tool called DCLI (Distributed Command Line Interface) that can be used to run the same commands on all or a subset of compute nodes in parallel.

  *

  Cellcli(not E): on Exadata Storage Servers.

  *

  RDBMS instance on database server.

  *CELLSRVon Exadata Storage Servers.

  *

  ASM on Exadata Storage Servers(not D)

  After an Oracle ASM instance has been installed on a single-instance Oracle Database or in an Oracle Real Application Clusters (Oracle RAC) environment, the final Oracle ASM configuration can be performed.

• Question 18:

  Your customer wants you to partition the database and storage grids in his X3-2 full rack, creating database clusters and two storage grids.

  One cluster will be used for production and should consist of 6 databases servers and 11 cells from the first storage grid.

  The other cluster will be used for test and development, and should consist of 2 database servers and 3 cells from the second storage grid.

  The storage must be partitioned so that the cells are visible only to the appropriate database servers based on the description above. What must be done to achieve this?

  A. Configure Exadata realms using Oracle ASM scoped security mode.
  B. Configure Exadata realms using Database scoped security mode.
  C. Edit the CELLIP.ORA file on each database server to contain IP addresses of cells in the storage grid associated with cluster to which that database server belongs.
  D. Edit the CELLINIT.ORA file on each database server to contain IP addresses of cells in the storage grid associated with the cluster to which that database server belongs.
  E. Edit the CELLIP.ORA file on each database server to contain IP addresses of database servers which are allowed access to specific cells in the same storage grid.
  F. Edit the CELLIP.ORA file on each cell to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that cell belongs.
  C. Edit the CELLIP.ORA file on each database server to contain IP addresses of cells in the storage grid associated with cluster to which that database server belongs.

  ---

  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"

  Now that we see what is in the cellip.ora, the grid disk path, in the examples above, should make more sense.

  Note:

  *cellinit.ora decides which network takes storage traffic. *cellip.ora - list of cells, new cells can be added dynamically without shutdown

• Question 19:

  Identify two permitted uses of external InfiniBand connections to a Database Machine.

  A. To connect an ExaLogicElastic CloudMachine
  B. To monitor the InfiniBand network using Enterprise Manager
  C. To connect an external tape library
  D. To use a bonded client access network
  E. To use a bonded management network
  A. To connect an ExaLogicElastic CloudMachine
  B. To monitor the InfiniBand network using Enterprise Manager

  ---

  A:Combining the Oracle Exalogic Elastic Cloud withthe Oracle Exadata Database Machine for SAPNetWeaver The InfiniBand fabric that spans Exalogic and Exadata components provides the following key ways of simplifying and accelerating SAP NetWeaver installations running on Exalogic

  Note:A highspecialized database networking protocols connects all the components inside anExadata Database Machine. External connectivity to the Exadata Database Machineis provided through standard 1 Gigabit and 10 GigabMultiple X3even larger configurations.

• Question 20:

  Last weekend, an Exadata storage server flashdisk entered the predictive failure state.

  The flashdisk is used by the flashcache and has a griddisk which is a member of a normal redundancy diskgroup.

  Identify thefoursteps you must perform to replace this flashdisk.

  A. Identify the griddisk on the predictive failure flashdisk and drop it from the associated ASM diskgroup
  B. Verify that the griddisk located on the predictive failure flashdisk has been successfully dropped from the associated ASM diskgroup.
  C. Drop the flashcache on the cell and re-create it using all but the predictive failure flashdisk.
  D. Safely power off the cell containing the predictive failure flashdlsk.
  E. Replace the predictive failure flashdisk.
  F. Power up the cell containing the replaced flashdlsk and activate all grlddlsks.
  G. Drop the flashcache on the cell and re-create it using all flashdlsks.
  H. Create a new griddisk on the replaced flashdisk.
  I. Add the griddisk back into the ASM diskgroup to which it belonged.
  A. Identify the griddisk on the predictive failure flashdisk and drop it from the associated ASM diskgroup
  D. Safely power off the cell containing the predictive failure flashdlsk.
  E. Replace the predictive failure flashdisk.
  I. Add the griddisk back into the ASM diskgroup to which it belonged.

  ---

  Note:

  *Exadata monitors for the number of media and other disk/flash failures (e.g. an I/O write failure due to physical media damage). If there are too many of those, Exadata is 'predicting' that it will soon fail and it takes it out of the system.

  *Exadata Server, that runs on the storage cells, monitors disk health and performance. If the disk performance degrades it can put it into proactive failure mode. It also monitors for predictive failures based on the disk's SMART (Selfmonitoring, Analysis and Reporting Technology) data. In both cases, the Exadata Server notifies XDMG to take those disks offline.

  When a faulty disk is replacedf on the storage cell, the Exadata Server will recrate all grid disks on a new disk. It will then notify XDMG to bring those grid disks online or add them back to disk groups, in case they were already dropped.

  *ASM is a critical component of the Exadata software stack. It is also a bit different - compared to non-Exadata environments. It still manages your disk groups, but builds those with grid disks. It still takes care of disk errors, but also handles

  predictive disk failures. It doesn't like external redundancy and ACFS, but it makes the disk group smart scan capable.