Oracle 1Z0-027 Online Practice Questions and Exam Preparation

Oracle 1Z0-027 Online Questions & Answers

• Question 41:

  Which three factors should you consider when choosing a method for migrating a database to the Database Machine?

  A. Typeof database workload
  B. Number of tablespaces in the source database
  C. Size of the source database
  D. Endian format of the source database
  E. ASM attributes and allocation unit (AU) size of the diskgroups used by the source database
  A. Typeof database workload
  C. Size of the source database
  D. Endian format of the source database

  ---

  A:Use Real Production Workload

  Real Application Testing (RAT)

  Database Workload Replay

  SQL Performance Analyzer (SPA)

  D:

  *Endianformat: Non-Exadata format

  Reference:Exadata MAA Best Practices,Migrating Oracle Databases

• Question 42:

  You are about to replace one memory DIMM in an Exadata storage server and need to power off the affected cell.

  Which four commands must you execute to safely power off the storage server in your standard deployed quarter rack Database Machine assuming that redundancy is not compromised?

  A. `crsctl stop cluster -all' on one of the database servers
  B. CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != `Yes'
  C. CellCLI> ALTER GRIDDISK ALL INACTIVE
  D. CellCLI> LIST GRIDDISK WHERE STATUS != `inactive'
  E. `shutdown
  B. CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != `Yes'
  C. CellCLI> ALTER GRIDDISK ALL INACTIVE
  D. CellCLI> LIST GRIDDISK WHERE STATUS != `inactive'
  E. `shutdown

  ---

  B: Step 1:

  Run the following command to check if there are other offline disks CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'

  If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.

  C: Step 2:

  Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:

  CellCLI> ALTER GRIDDISK ALL INACTIVE

  Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.

  D: Step 3: -- Verify all grid disks are INACTIVE to allow safe storage server shut down by running the following command:CellCLI> LIST GRIDDISK ATTRIBUTES name, asmmodestatusCellCLI> LIST GRIDDISKIf all grid disks are INACTIVE, then the storage server can be shutdown without affecting database availability

  E:Step 4:

  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 43:

  Which two are true concerning theallocation of I/O resources by the IORM within the CELLSRV process?

  A. Control File I/O is managed automatically at high priority by IORM.
  B. Control File I/O is considered part of the SYSTEM resource Consume group by IORM.
  C. Log Writer I/O to the Smart Flash Log is considered part of the SYSTEM resource consumer group by IORM.
  D. Log Writer I/O to the Smart Flash Log is managed automatically at high priority by IORM.
  E. Database Writer I/O is managed automatically at normal priority by IORM.
  F. Database Writer I/O is considered part of the SYSTEM resource consumer group by IORM.
  A. Control File I/O is managed automatically at high priority by IORM.
  E. Database Writer I/O is managed automatically at normal priority by IORM.

  ---

  Note:

  *IORM Rules

  IORM is only "engaged" when needed.

  / (A)Redo and control file writes always take precedence. / (E)DBWR(database writer)writes are scheduled at the same priority as user IO. /IORM does not intervene if there is only one active consumer group on one database. /Any disk

  allocation that is not fully utilized is made available to other workloads in relation to the configured resource plans.

  /Background IO is scheduled based on their priority relative to user IO. /For each cell disk, each database accessing the cell has one IO queue per consumer group and three background queues.

  /Background IO queues are mapped to "high", "medium", and "low" priority requests with different IO types mapped to each queue.

  /If no intradatabase plan is set, all non-background IO requests are grouped into a single consumer group called OTHER_GROUPS.

  Reference:Using IORM with Exadata

• Question 44:

  Which three must he true for Smart Scans tobedone?

  A. Executing a query in parallel
  B. Setting _serial_direct_read=true in the session issuing the SQL statements
  C. Having direct path reads used at run time
  D. Having a 4 megAUsize for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored
  E. Cell_offload_process = true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
  F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
  A. Executing a query in parallel
  C. Having direct path reads used at run time
  F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.

  ---

  F:ASM Diskgroup has an attribute: cell.smart_scan_capable ?Must be set to TRUE for Smart Scans to work

• Question 45:

  To guaranteeproper cooling, you plan to place perforated floor tiles near your Database Machine.

  Where, in relation to the cabinet, should they be placed?

  A. On the left side, because the air flow is from left to right
  B. At the back, because the air flow is from back to front
  C. On the right side, because the air flow is from right to left.
  D. At the front, because the air flow is from front to back
  E. Underneath the cabinet, because the air flow is from bottom to top
  D. At the front, because the air flow is from front to back

  ---

  Airflow must be front-to-back.

  Reference: Oracle White Paper,ORACLE Exadata DatabaseMachine X3-8

• Question 46:

  A table in one of your database schemas contains only varchar, number, and date data types for the columns.

  Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, if no other situations arise that prevent Smart Scan from occurring?

  A. Column filtering
  B. Sort merge join filtering
  C. Predicate filtering
  D. Nested loop Join filtering
  E. Hash join filtering
  F. Virtual column filtering
  A. Column filtering
  C. Predicate filtering
  F. Virtual column filtering

  ---

  Exadata 11.1 Smart Scan operations include:

  -Restriction (filtering of rows)

  -Projection (filtering of columns)

  - Join Filters (Bloom Filters) commonly used in Fact/Dimension joins found in Star Schemas. This is different than Star Transformation. Other join operations such as HASH(not E), SORT, SORT-MERGE(not B), NESTED LOOP(not D), etc. are done by the Oracle Database Grid.

  A:Smart Scan Column Filtering Exadata provides column filtering, also called column projection, for table scans. Only the columns requested are returned to the database server rather than all columns in a table. For example, when the following SQL is issued, only the employee_name and employee_number columns are returned from Exadata to the database kernel. SELECT employee_name, employee_number FROM employee_table. For tables with many columns, or columns containing LOBs (Large Objects), the I/O bandwidth saved can be very large. Using both predicate and column filtering dramatically improves performance and reduces I/O bandwidth consumption. In addition, column filtering also applies to indexes, allowing for even faster query performance.

  C:Smart Scan Predicate Filtering

  Exadata enables predicate filtering for table scans. Only the rows requested are returned to the database server rather than all rows in a table. For example, when the following SQL is issued only rows where the employees' hire date is after the specified date are sent from Exadata to the database instance.

  SELECT * FROM employee_table WHERE hire_date > '1-Jan-2003'. This ability to return only relevant rows to the server greatly improves database performance. This performance enhancement also applies as queries become more complicated, so the same benefits also apply to complex queries, including those with subqueries.

• Question 47:

  Which two are Oracle recommendations for media based backups performed for a database running on a Database Machine?

  A. Allocate equivalent number of channels and instances per tape drive.
  B. Perform periodic level 0 backups and daily cumulative level-1 backups.
  C. Use the InfiniBand network between the database server and media server.
  D. Configure Recovery Manager (RMAN) channels to connect to the least loaded instances.
  E. UseInfiniBand network between the media server and the storage servers.
  A. Allocate equivalent number of channels and instances per tape drive.
  C. Use the InfiniBand network between the database server and media server.

  ---

  A:Configure one RMAN channel per tape drive and add tape drives to scale backup rates.

  C:Configure the Preferred Network Interface (PNI) to direct the Oracle Secure Backup traffic over the InfiniBand network interface.

  Example:

  ob> lspni (List Preferred Network Interface)

  mediaserver1:

  PNI 1:

  interface: mediaserver1-ib

  clients: dbnode1, dbnode2, dbnode3, dbnode4,

  dbnode5, dbnode6, dbnode7, dbnode8

  PNI 2:

  interface: mediaserver1

  clients: adminserver

  dbnode1:

  PNI 1:

  interface: dbnode1-ib

  clients: mediaserver1

  Note:

  *Using the Sun ZFS Backup Appliance as an Oracle RMAN backup target for an Oracle Exadata system delivers much faster backup and recovery, enabling organizations to achieveshorter recovery time objectives and shrink backup windows. The appliance is designed for high sustained read and write I/O performance, and it is connected to the Oracle Exadata system via a high-throughput InfiniBand network fabric.

  *As the only unified storage vendor to support InfiniBand as a storage network for backup and restore operations, Oracle is leading the way with nativehigh-bandwidth interconnects. *The InfiniBand network provides 40 Gb of bandwidth per port between the database servers, storage cells, and the Sun ZFS Backup Appliance. Backup and restore operations can be automatically parallelized across all database nodes, Oracle Exadata storage cells, Sun ZFS Backup Appliance channels, and controllers.

• Question 48:

  In which two locations should files be staged, to be loaded using externaltables into a database on a Database Machine?

  A. On a dbfs file system stored in a staging database on the Database Machine
  B. On an Exadata-based ACFS file system on the Database Machine
  C. On an nfs file system mounted on a database server where the external table will be accessed.
  D. On local storage on one or more cells that are accessible to the database server where the load will be performed.
  C. On an nfs file system mounted on a database server where the external table will be accessed.
  D. On local storage on one or more cells that are accessible to the database server where the load will be performed.

  ---

  Prepare a Temporary File System The Oracle E-Business Suite Rapid Install creates a file system based Oracle Database release

  11.1.0.7 database, and it cannot install directly to a database that uses Oracle ASM. Therefore it requires non-Exadata storage of about 55 GB and an additional 50 GB of storage for the install staging area for a total of 105 GB. The file system to be used for the database node file system and the stage area can either use the database machine local storage or an NFS mounted file system.

  Reference:Installing Oracle E-Business Suite Release 12 with the Oracle Exadata Database Machine

• Question 49:

  Which tool will provide you with diagnostic information for all the software log, trace files, and OS information on Database Machine?

  A. dbmcheck.sh
  B. diagget.sh
  C. oswatcher
  D. adrci
  E. Enterprise Manager
  B. diagget.sh

  ---

  Gather all diagnostics information /opt/oracle.SupportTools/onecommand/diagget.sh

• Question 50:

  Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine?

  A. ILOM can be used to power-on the Cisco switch.
  B. ILOM can be used to power on the InfiniBand switches.
  C. ILOM can be used to power-on the database servers.
  D. ILOM generates hardware alerts for the power distribution units.
  E. ILOM provides a remote console for the storage servers.
  B. ILOM can be used to power on the InfiniBand switches.
  E. ILOM provides a remote console for the storage servers.

  ---

  B:How to monitor the bandwidth of Exadata Infiniband Switch? There are two ways, the simplest method is to use the Fabric Monitor (ILOM Web Interface), and the other way is just to use SNMP request. E:*The Oracle ILOM Remote Console is supported on all Oracle Sun x86 processor-based servers. It is also supported on some SPARC processor-based servers. The Oracle ILOM Remote Console is a Java application that you can launch from the Oracle ILOM web interface *Remote Management: Integrated Lights Out Manager (ILOM) Ethernet port