Oracle 1Z0-027 Online Practice Questions and Exam Preparation

Oracle 1Z0-027 Online Questions & Answers

• Question 1:

  Which two activities are supported on the storage serversin the Database Machine?

  A. Installing an alternative package manager B. configuring secure shell user equivalency for the callmonitor user
  C. changing root password
  D. upgrading the Storage Server software package using RPN
  E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
  A. Installing an alternative package manager B. configuring secure shell user equivalency for the callmonitor user
  D. upgrading the Storage Server software package using RPN

  ---

  D:What Oracle Solaris Brings to Oracle Exadata Database Machine Simplified, improved updates--Oracle Solaris 11 uses the new Image Package System (IPS), which is a network-based package management that provides a framework for complete software lifecycle management such as installation, upgrade and removal of software packages

• Question 2:

  You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Database Machine.

  You use RAC for your database and also use Data Guard, having standby database on another Database Machine.

  You wish to have scripts that contain the appropriate command to patch your environment.

  Your patch bundle is on the first database server and is located at /u01/stage.

  You have downloaded the oplan utility to the first database server and run the following:

  $ORACLE_HOME/oplan/oplangenerateApplySteps /u01/stage

  Which two are true concerning oplan?

  A. It will generate instructions for patching only storage servers.
  B. It will generate instructions for patching all the components on the Database Machine.
  C. It will generate instructions for patching the RAC Oracle Home on the primary location.
  D. It will generate instructions for patching the Data Guard environment on the standby location.
  E. It will generate instructions for patching the Grid Infrastructure home on the primary location.
  C. It will generate instructions for patching the RAC Oracle Home on the primary location.
  E. It will generate instructions for patching the Grid Infrastructure home on the primary location.

  ---

  Oplan generates instructions for all of the nodes in the cluster.

  Note:

  *Oplan is a utility that facilitates you with the application of bundle patches on Exadata compute nodes via Opatch. This new utility helps you with the patch process by generating step-by-step instructions telling you how to apply a bundle

  patch in your environment. *Exadata is much more than a "database-in-a-box." It is a set of compute nodes (think RAC node servers) combined with ultra-fast infiniband (...and 10GB ethernet, and multiple 1GB ethernet) and storage nodes.

  Incorrect:

  Not D:There is no support for Oracle DataGuard

• Question 3:

  Which two statements are true about the IPTables firewall configuration on a Database Machine- Machine after the default Initial deployment?

  A. IPTables is configured with Oracle supplied rules on the cells.
  B. IPTables is configured with Oracle supplied rules on the database servers.
  C. IPTables is installed and available but not configured on any servers.
  D. IPTables is installed and available but not configured on the database servers.
  E. IPTables is installed and available but not configured on the cells.
  B. IPTables is configured with Oracle supplied rules on the database servers.

  ---

  Note:

  *As for the iptables settings, I don't believe Oracle supports making modifications to these rules. They're configured out of the box based on the version of the storage server software you're running. As far as I know, the configuration cannot

  be easily modified.

• Question 4:

  Which two are regarding the case of storageindexes?

  A. To increase the chance of using the a storage index, you can make table indexes invisible.
  B. To maximize the benefit of storage Indexes, load your data stored on the filtered columns.
  C. The cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each storage server.
  D. Storage indexes are retained after a cell is rebooted.
  E. Avoid the use of bind variables because Storage Indexes do not work with bind variables.
  B. To maximize the benefit of storage Indexes, load your data stored on the filtered columns.
  E. Avoid the use of bind variables because Storage Indexes do not work with bind variables.

  ---

  B:* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. *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.

  Incorrect:

  Not D:Storage indexes reside in the memory of the storage servers. If a storage cell is shutdown or rebooted the storage index will be lost from memory and will be recreated on subsequent accesses to the data after the cell has been brought

  back online.

• Question 5:

  You have configured a multi-rack Database Machine with two X3-8 full racks all in a single cluster and storage grid.

  Which two are true regarding the servers on which Enterprise manager agents must be deployed in order to monitor all components of the multi-rack Database Machine?

  A. On only one database server in the first rack
  B. On all storage servers in all racks
  C. On at least two storage servers in the first rack
  D. On all database servers in thefirstrack
  E. On only one database server in second rack
  F. On all database servers in second rack
  G. On at least two storage servers in the second rack
  D. On all database servers in thefirstrack
  F. On all database servers in second rack

  ---

  Note:

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

  *Oracle's documentation uses the term compute node when referring to the database server tier of the platform.

  *The Exadata Database Machine runs Oracle Database 11g Real Application Cluster. The cluster and the database run on the servers known as database nodes or compute nodes (or simply "nodes"). *Cells and compute nodes are not shared between partitions. *Compute nodes in same partition share the same Cluster.

• Question 6:

  You plan to monitor storage servers after configuring an I/O resource manager plan with directives for inter-database plans and intra-database plans. Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?

  A. Category I/O
  B. Database I/O
  C. Resource Consumer Group I/O
  D. Smart Flash Log I/O
  E. Smart Flash Cache I/O
  B. Database I/O
  C. Resource Consumer Group I/O

  ---

  B:Database metrics provide information about the size of the I/O load from each database specified in the interdatabase plan.

  C:Consumer group metrics provide information about the size of the I/O load from each consumer group specified in a database resource plan. Each database in the interdatabase plan has metrics for each of its consumer groups.

  Note:

  *I/O Resource Manager (IROM) Settings

  Incorrect:

  Not A:Category metrics provide information about the size of the I/O load from each category specified in the current IORM category plan.

• Question 7:

  You are in the planning stage of the network configuration for your Database Machine. The requirements are:

  1.A

  fault-tolerant network, providing higher availability for connections to database instances

  2.Fault tolerance providing higher availability for connections to perform management functions on the database and storage servers.

  3.Full monitoring of all Database Machine components using Enterprise Manager

  Which three components require external Ethernet network cables to connect your existing network infrastructure to your database machine to satisfy this requirement?

  A. Database servers
  B. Exadata storage servers
  C. InfiniBand storage servers.
  D. Power distribution units (PDUs)
  E. Cisco Ethernet switch
  A. Database servers
  B. Exadata storage servers
  C. InfiniBand storage servers.

• Question 8:

  Yesterday, an Exadata storage server flashdisk entered the poor performance state.

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

  Identify the six steps you must perform to replace flashdisk.

  A. Identify the griddisk located on the poorly performing flashdisk and drop it from the associated ASm diskgroup.
  B. Verify that the griddisk located on the poorly performing flashdisk has been successfully dropped from the associated ASM diskgroup.
  C. Drop the flashcache on all cell.
  D. Safely power off the cell containing the poorly-performing flashdisk.
  E. Replace the poorly performing flashdisk.
  F. Power up the cell containing the replaced flashdisk and activate all griddisks.
  G. Recreate the flashcache on the cell using all flashdisks.
  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 located on the poorly performing flashdisk and drop it from the associated ASm diskgroup.
  D. Safely power off the cell containing the poorly-performing flashdisk.
  E. Replace the poorly performing flashdisk.
  F. Power up the cell containing the replaced flashdisk and activate all griddisks.
  H. Create a new griddisk on the replaced flashdisk.
  I. Add the griddisk back into the ASM diskgroup to which it belonged.

  ---

  Answer: A,D,E,F,H,I

  Note:

  *The default way to deal with the Flash Storage is to use it completely as Flash Cache. You may think of Flash Cache as a prolongation of the Database Buffer Cache. It is populated automatically by the system with objects deemed useful to

  cache them.

  *The second possibility to deal with the Flash Storage is to take a part of it for building ASM diskgroups upon. All files on these ASM diskgroups will then reside permanently on Flash Storage:

  CellCLI> drop flashcache

  Flash cache exa5cel01_FLASHCACHE successfully dropped

  CellCLI> create flashcache all size=100g

  Flash cache exa5cel01_FLASHCACHE successfully created

  CellCLI> create griddisk all flashdisk prefix=flashdrive

• Question 9:

  Which two statements are true about the use of direct path loads when selecting from external tables in a database on a Database Machine?

  A. INSERT INTO . . . SELECT FROM statements, executed serially,whichselect from external tables, require the APPEND hint to use direct path loading.
  B. CREATE TABLE . . . AS SELECT statements, which select from external tables, attempt to use in direct path loading automatically.
  C. CREATE TABLE . . . AS SELECT statements, which select from external tables, require the APPEND hint to use direct path loading.
  D. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, are unable to use direct path loading.
  A. INSERT INTO . . . SELECT FROM statements, executed serially,whichselect from external tables, require the APPEND hint to use direct path loading.
  B. CREATE TABLE . . . AS SELECT statements, which select from external tables, attempt to use in direct path loading automatically.

  ---

  A CTAS(Create table as select)will always use direct path(B, not C)load but IAS(Insert as select)statement will not. In order to achieve direct path load with an IAS statement you must add the APPEND hint to the command(A, not D).

  Direct path loads can also run in parallel. You can set the parallel degree for a direct path load

  either by adding the PARALLEL hint to the CTAS or IAS statement or by setting the PARALLEL clause on both the external table and the table into which the data will be loaded.

  Once the parallel degree has been set at CTAS will automatically do direct path load in parallel

  but an IAS will not. In order to enable an IAS to do direct path load in parallel you must alter the session to enable parallel DML.

  Note:

  *Parallel Direct Path Load

  The key to good load performance is to use direct path loads wherever possible. A direct path

  load parses the input data according to the description given in the external table definition, converts the data for each input field to its corresponding Oracle data type, then builds a column

  array structure for the data. These column array structures are used to format Oracle data blocks

  and build index keys. The newly formatted database blocks are then written directly to the database, bypassing the standard SQL processing engine and the database buffer cache.

  Reference:Best Practices for Implementing a Data Warehouse on the Oracle Exadata Database Machine;Using CTAS and Exchange Partition Replace IAS for Copying Partition on Exadata

• Question 10:

  You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your Database machine and its assets. Which three statements are true about this configuration?

  A. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
  B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to ASR Manager.
  C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
  D. Simple networkManagement Protocol(SNMP) traps are used to send notification from Enterprise manager to ASR Manager.
  E. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to ASR Manager.
  F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to Enterprise Manager.
  A. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
  E. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to ASR Manager.
  F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to Enterprise Manager.

  ---

  A (not C).

  To configure fault telemetry, choose one of the following three options:

  Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility Add SNMP Trap Destinations for a Single Server

  E (not B): As per question: "...configured Auto Service Request (ASR) for your Database machine and its assets."

  F (not D).