Oracle Oracle Certifications 1Z0-070 Questions & Answers

• Question 31:

  You plan to migrate an Oracle database supporting an online transaction processing (OLTP) workload to an X5 Exadata Database Machine.

  The database machine is running database version 12.1.0.2.

  The source database has these attributes:

  Database version: 12.1.0 Byte order: Big Endian Database size: 24 TB

  You have decided to perform physical migration using the Transportable Tablespace method.

  Examine this list of possible steps to accomplish this task.

  1.

  Create a new 12.1.0.2 Exadata–based database.

  2.

  Export the source system metadata using Transportable Tablespace (TTS).

  3.

  Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.

  4.

  Import the metadata into the target database.

  5.

  Use the RMAN CONVERT to change the database files to the little endian format on the source system.

  Identify the required steps in the correct order.

  A. 1, 2, 4, 5

  B. 1, 2, 5, 3, 4

  C. 1, 2, 3, 4, 5

  D. 1, 2, 3, 4

  E. 1, 2, 5, 4, 3

  F. 1, 2, 5, 4

  Correct Answer: D

  Explanation:

  Step 1: 1. Create a new 12.1.0.2 Exadata –based database.

  Step 2: 2. Export the source system metadata using transportable Tablespace (TTS).

  Step 3: 3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change

  them to the little endian format.

  Step 4: 4. Import the metadata into the target database.

  This method is often chosen when migrating between platforms with different endian formats, or in cases

  where physical re-organization is not necessary.

  The transportable tablespace method is generally mu

  References: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/mig-transportabletablespace.html

• Question 32:

  Which three are true concerning Storage Indexes?

  A. A maximum of eight table columns for any table are indexed per storage region.

  B. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.

  C. Storage Indexes persist across any Exadata storage server reboots.

  D. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.

  E. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.

  F. Different storage regions may have different columns indexed for the same table.

  Correct Answer: ADE

  Explanation:

  A: Each disk in the Exadata storage cell is divided into equal sized pieces called storage regions (default 1MB). There is an index entry for every storage regions (1MB of data stored on disk). Each entry contains the minimum and maximum value for columns seen in ‘where’ clause predicates. Information for up to 8 columns can be stored. The index is then used to eliminate disk IO by identifying which storage regions don't match the ‘where’ clause of a query.

• Question 33:

  Which three are sources for alerts from storage servers in an X5 Database Machine?

  A. Software errors reported by the MS process on the storage servers

  B. Hardware sensor alerts reported by the CELLSRV process on the storage servers

  C. Software errors reported by the RS process on the storage servers

  D. Hardware sensor alerts detected by the ILOM on the storage servers

  E. Metrics that have administrator-defined thresholds on the storage servers

  Correct Answer: ABE

  Explanation:

  AB: The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of

  metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can

  generate alerts for important storage cell hardware or software events.

  Incorrect Answers:

  C: The Restart Server (RS) process is used to start up and shut down the CELLSRV and MS processes. It also monitors these services to check whether they need to be restarted.

  References: http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em122291964.html

• Question 34:

  Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata X5 or X6 Database Machine?

  A. ILOM on database servers can use IPMI to send sensor alerts to an Enterprise Manager Agent.

  B. ILOM on a storage server uses SNMP to send sensor alerts to the cellsrv process on the same storage server.

  C. ILOM on a storage server uses IPMI to send sensor alerts to the MS process on the same storage server.

  D. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server.

  E. ILOM on database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent.

  Correct Answer: CE

  Explanation:

  C: ILOM supports the Intelligent Platform Management Interface (IPMI), which enables you to monitor and

  control your server platform, as well as to retrieve information about your server platform.

  ILOM supports alerts in the form of IPMI Platform Event Trap (PET) alerts. Alerts provide advance warning

  of possible system failures.

  E: Oracle ILOM supports the Simple Network Management Protocol (SNMP), which is used to exchange

  data about network activity.

  SNMP functionality requires the following two components:

  1.

  Network management station – A network management station hosts management applications, which monitor and control managed nodes.

  2.

  Managed node – A managed node is a device such as a server, router, or hub that hosts SNMP management agents that are responsible for carrying out requests from management stations, such as a service processor (SP) running Oracle ILOM. Managed nodes can also provide unsolicited status information to a management station in the form of a trap.

  References: https://docs.oracle.com/cd/E19860-01/E21452/E21452.pdf

• Question 35:

  You plan to consolidate your company's INVENTORY and SALES databases onto your new Exadata X6 Database Machine.

  You are considering consolidation of all schemas into one RAC database. Which three factors would you need to consider before choosing this approach?

  A. the number of database users

  B. Security Policies

  C. the number of database roles

  D. the number of simultaneous sessions

  E. the maintenance schedule

  Correct Answer: ABD

• Question 36:

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

  Exadata X6 Database Machine.

  You use RAC for your databases and also use Data Guard, having standby databases on another

  Database Machine.

  You want to have scripts that contain the appropriate commands to patch your environment.

  Your patch bundle is one the first database server and is located at /uo1/stage.

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

  $ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage

  Which two statements are true concerning the type of instructions oplan will generate?

  A. Instructions for patching the Grid Infrastructure home on the primary location

  B. Instructions for patching the Data Guard environment on the standby location

  C. Instructions for patching the RAC Oracle Home on the primary location

  D. Instructions for patching only storage servers

  E. Instructions for patching all components on the Database Machine

  Correct Answer: AC

  Explanation:

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

  Note:

  1.

  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.

  2.

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

  B: There is no support for Oracle DataGuard References: https://blogs.oracle.com/xpsonha/patching-for-exadata:-introducing-oplan

• Question 37:

  Which two activities are supported on the storage servers in an Exadata X6 Database Machine?

  A. Upgrading the Storage Server software package using RPM

  B. Configuring secure shell user equivalency for the cellmonitor user

  C. Installing an alternative package manager

  D. Changing the root password

  E. Upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

  Correct Answer: AC

• Question 38:

  You are evaluating the performance of a SQL statement that accesses a very large table.

  You run this query: Identify two reasons why the “physical read total bytes” statistic is greater than the “cell physical IO bytes eligible for predicate offload” statistic.

  

  A. There is an index on the column used in the WHERE clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

  B. The table is an IOT and has an overflow segment, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

  C. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

  D. The table is an index clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

  E. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

  Correct Answer: BE

  Explanation: Note:

  1.

  physical read total bytes: the size of the segment to read is known by the database, and must be read entirely from the database's perspective.

  2.

  cell physical IO bytes eligible for predicate offload: this statistic shows the amount of data which the cell server is able to process on behalf of the database, instead of the database processing and the cell server just delivering blocks.

  3.

  Cell physical IO bytes eligible for predicate offload --- This number should be high

  4.

  The higher the number more MB/GB is filtered out at the cell level itself rather sending it to the buffer cache to filter the rows.

  5.

  In this case, all bytes are processed on the cellserver (cell physical IO bytes eligible for predicate offload=physical read total bytes)

  Cell Offloading:

  The storage cells are intelligent enough to process some workload inside them, saving the database

  nodes from that work. This process is referred to as cell offloading.

• Question 39:

  You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown:

  [root@excel04 ~] # imageinfo

  Kernel version: 2.6.18-194.3.1.0.4.el5 #1 SMP Sat Feb 19 03:38:37 EST 2011 x86_64 Cell version: OSS_11.2.0.3.0_LINUX.X64_110429.1 Cell rpm version: cell-11.2.2.3.1_LINUX.X64_110429.1-1

  Active image version: 11.2.2.3.1.110429.1Active image activated: 2011-05-09 16:26:36 -0400Active image status: successActive image partition on device: /dev/md6Active software partition on device: /dev/md8

  In partition rollback: Impossible

  Cell boot usb partition: /dev/sdm1Cell boot usb version: 11.2.2.3.1.110429.1

  Inactive image version: 11.2.1.2.6Inactive image activated: 2010-10-04 23:59:16 -0400Inactive image status: successInactive system partition on device: /dev/md5Inactive software partition on device: /dev/md7

  Boot area has rollback archive for the version: 11.2.1.2.6 Rollback to the inactive partitions: Possible

  Which two statements are true about the software and system partitions?

  A. /dev/md6 and /dev/md8 have one of their mirror copies on physicaldisk 1

  B. /dev/md6 and /dev/md8 are located only on physicaldisk 1

  C. /dev/md5 and /dev/md7 have one of their mirror copies on physicaldisk 0

  D. /dev/md5 and /dev/md7 are located only on physicaldisk 0

  Correct Answer: BC

• Question 40:

  Examine this IORM plan: Which two are true concerning this plan?

  

  A. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.

  B. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.

  C. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.

  D. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.

  E. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.

  Correct Answer: BE

  Explanation: The IORM plan can be configured using the ALTER IORMPLAN command on command-line interface (CellCLI) utility on each Exadata storage cell. It consists of two parameters - dbplan and catplan. While the "dbplan" is used to create the I/O resource directives for the databases, the "catplan" is used to allocate resources by workload category consolidated on the target system.

  allocation/share - Specify the resource allocation to a specific database in terms of percentage or shares. limit - Specify maximum limit of disk utilization for a database.

  Incorrect Answers:

  A: IORM plans configures % I/O resources, not % of Flash Cache.

  References: https://community.oracle.com/docs/DOC-998939