Oracle 1Z0-027 Online Practice Questions and Exam Preparation

Oracle 1Z0-027 Online Questions & Answers

• Question 51:

  Which three storage components are available after the standard initial Database machine deployment?

  A. The DATA_ ASM diskgroup
  B. The RECO_ ASM diskgroup
  C. Mirrored system partitions on hard disk 0 and hard disk 1
  D. The DBFS_DG diskgroup with external redundancy
  E. Exadata Smart Flash Cache using all of the flashdisk space
  A. The DATA_ ASM diskgroup
  B. The RECO_ ASM diskgroup
  D. The DBFS_DG diskgroup with external redundancy

  ---

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

• Question 52:

  You have used setupem.sh to deploy a plug in for Grid Control.

  In which two ways do all the targets supported by the plug-in get configured?

  A. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.
  B. Setupem.sh is used again to configure the targets.
  C. The targets must be configured by an O/S administrator manually.
  D. The targets must be configured by a database administrator manually.
  E. There may be more than one target for each plug-in.
  A. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.
  E. There may be more than one target for each plug-in.

  ---

  

• Question 53:

  Which three are among the software components that constitute the QoS Management framework?

  A. Cluster Health Monitor (CHM)
  B. Cluster Verification Utility (CLUVFY)
  C. O/S Resource Manager
  D. Grid Infrastructure for a standalone server
  E. Grid Infrastructure for a cluster
  F. OC4J cluster resource
  A. Cluster Health Monitor (CHM)
  E. Grid Infrastructure for a cluster
  F. OC4J cluster resource

  ---

  A:In conjunction with Cluster Health Monitor, QoS Management's Memory Guard detects nodes that are at risk of failure due to memory over-commitment. It responds by automatically preventing new connections thus preserving existing

  workloads and restores connectivity once the sufficient memory is again available.

  F:The ora.oc4j is for the QoS (Quality of Service Management), which is only available on Exadata.

  Incorrect:

  Not B: The Cluster Verification Utility (CVU) performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation

  steps so that your Oracle grid infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation completes successfully.

• Question 54:

  You have two very large databases supporting OLTP workloads which run on multiple small-blade styleservers in a cluster and which require optimal latencyfor I/O.

  You plan to migrate them to a Database Machine once a capacity planning exercise isfinished.

  The database backup strategy requires that backups are written directly to media.

  High availability requirements state that you must be able to survive node failures at any time.

  Which three Database Machine components or features would you recommend to support these requirements?

  A. Use of write back flash cache
  B. Use of smart flash logs
  C. High capacity disks in the Database Machine
  D. High performance disks in the Database Machine
  E. A high capacity expansion full rack
  F. A high performance expansion full rack
  B. Use of smart flash logs
  D. High performance disks in the Database Machine
  E. A high capacity expansion full rack

  ---

  B:The Exadata Smart Flash Cache feature of the Exadata Storage Server Software intelligently caches database objects in flash memory, replacing slow, mechanical I/O operations to disk with very rapid flash memory operations.

• Question 55:

  Which three statements are true about the initial storage configuration after the standard deployment of a new database Machine?

  A. The Data_ and RECO_ ASM diskgroups are built on part of the interleaved griddisks.
  B. The Data_ and RECO_ ASM diskgroups are built on top of the non-interleaved griddisks.
  C. There is a free space available on the hard disks inside the database servers for possible extension of the /u01 file system.
  D. There is no free disk space available on the hard disk inside the database servers for possible extensions of the /u01 file system.
  E. There is free space available on the flashdisk inside the Exadata storage servers for possibleuseas flash-based griddisks.
  F. There isnofree disk available on the flashdisk inside the Exadata storage servers forpossible use as flash-based griddisks.
  B. The Data_ and RECO_ ASM diskgroups are built on top of the non-interleaved griddisks.
  C. There is a free space available on the hard disks inside the database servers for possible extension of the /u01 file system.
  F. There isnofree disk available on the flashdisk inside the Exadata storage servers forpossible use as flash-based griddisks.

  ---

  B( not A): 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 firstGriddisk that is created upon a Celldisk is placed on

  the outer sectors of the underlying Harddisk. It will have the best performance therefore. If we follow the recommendations, we will create 3 Diskgroups upon our Griddisks: DATA, RECO and SYSTEMDG.

  Note:

  *non-rootpartition (/u01).

  *Oracle Database files: DATA disk group.

  *Flashback log files, archived redo files, and backup files: RECO disk group.

• Question 56:

  Which three are true abort Enterprise Manager plug- in configuration for the Database Machine?

  A. There are several separate plug-ins for Grid Control.
  B. There is one plug-in for Cloud Control.
  C. There are several separate plug-ins for Cloud Control.
  D. Some plug-ins require SNMP trap forwarders.
  E. All plug-ins require SNMP trap forwarders.
  F. There is one plug-in for Grid Control.
  A. There are several separate plug-ins for Grid Control.
  B. There is one plug-in for Cloud Control.
  D. Some plug-ins require SNMP trap forwarders.

  ---

  A:Oracle Enterprise manager Grid control, is hands down the best monitoring and management tool, for the oracle exadata database machine. It comes with plugins to monitor all the hardware components of the database machine, and sensible, preset thresholds for proactive monitoring.

• Question 57:

  Identity the resource bottleneck for which QoS Management can generate recommendation?

  A. CPU resource bottlenecks
  B. Global Cache resource bottlenecks
  C. I/O resource bottlenecks
  D. Network resource bottlenecks
  B. Global Cache resource bottlenecks

  ---

  Note:

  *Oracle Exadata QoS Management provides the following benefits:

  1.

  Reduces the time and expertise requirements for system administrators who manage Oracle Real Application Clusters (Oracle RAC) resources

  2.

  Helps reduce the number of performance outages

  3.

  Reduces the time needed to resolve problems that limit or decrease the performance of yourapplications

  4.

  Provides stability to the system as the workloads change

  5.

  Makes the addition or removal of servers transparent to applications

  6.

  Reduces the impact on the system caused by server failures

  7.

  Helps ensure that service-level agreements (SLAs) are met

  8.

  Enables more effective sharing of hardware resources

  9.

  Protects existing workloads from over committed memory-induced server failures 10.Exadata Storage Virtualization 11.Exadata provides a rich set of sophisticated and powerful storage management virtualization 12.capabilities that leverage the strengths of the Oracle Database, the Exadata software, and Exadata hardware.

  *When QoS Management is enabled, individual Exadata nodes are protected from memory related failures. The Memory Guard features tracks real-time memory use and should it detect a node has over-committed memory, will prevent new database requests from being sent until the current load is relieved

• Question 58:

  Which three are true about Exadata storage server alerts?

  A. A threshold based alert gets cleared automatically when the measured value no longer violates the threshold.
  B. A storage server alert is only ever issued as a warning or at a critical situation.
  C. Storage server alerts are all stateless alerts.
  D. Storage server alerts notifications may be sent using SNMP.
  E. Storage server alerts are all stateful alerts.
  F. Storage server alerts notifications may be sent using SMTP.
  A. A threshold based alert gets cleared automatically when the measured value no longer violates the threshold.
  B. A storage server alert is only ever issued as a warning or at a critical situation.
  D. Storage server alerts notifications may be sent using SNMP.

  ---

  Incorrect:

  Not C, Not E: there are both stateful and stateless alerts

• Question 59:

  You plan to migrate a database supporting an anOLTP workload to your Database Machine

  This is part of a consolidation project and several other databases already exist on the Database Machine.

  Which three Exadata features may help to improve the performance of this OLTP workload?

  A. Hybrid Columnar Compression
  B. I/O Resource Manager
  C. Smart Flash Cache
  D. Smart Flash Log
  E. Smart Scan
  F. Storage Index
  B. I/O Resource Manager
  C. Smart Flash Cache
  D. Smart Flash Log

  ---

  C:OLTP performance benefits with Exadata /(D)Smart flash log for low latency commits / (C)Smart flash cache for low latency reads. KEEP in Flash for critical objects

• Question 60:

  A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan

  capability.

  The following is true about the tables used by the application:

  1.The data for the tables has just been loaded.

  2.There are no applications accessing the tables currently.

  3.None of the indexes are compressed or reverse key indexes.

  4.The tables use the default organization type data.

  5.The only data types for the table are varchar (2), number, or date.

  6.The largest number of columns for any table is 29.

  7.No access is based on ROWID, or virtual columns.

  Which two access paths will always generate either a set of "cell smart table scan" or a set of "cell smart index scan" requested?

  A. Full scans on sorted hash clustered tables executed in parallel
  B. Full table scans on index organized tables executed in parallel.
  C. Full table scans on heap tables executed in parallel
  D. Full scans on index clustered tables executed in parallel
  E. full scans on hash clustered tables executed in serially
  F. fast full scans on B*Tree indexes executed in parallel
  G. full index scans on B*Tree indexes executed in parallel
  B. Full table scans on index organized tables executed in parallel.
  G. full index scans on B*Tree indexes executed in parallel

  ---

  Note:

  *Exadata is built to efficiently use the resources to return results to the end user. Toward that end it has been designed to offload query tasks to the storage server, when possible, to reduce the amount of data passed to the calling session.

  Certain criteria must be met to offload to the storage server:

  /Full table or index scans must be used

  /Direct path reads must be used to access the data If the first requirement is not met another option can trigger the offloading mechanism:

  /Parallel query is in use

  *How do you know you've used a Smart Scan? The 'cell smart table scan' wait event or the 'cell smart index scan' wait event will show activity indicating a Smart Scan occurred. Nothing in the execution plan would be displayed to prove a

  Smart Scan was used; querying v$waitstat would be the only way to confirm that a Smart Scan was implemented.