Oracle 1Z0-070 Online Practice Questions and Exam Preparation

Oracle 1Z0-070 Online Questions & Answers

• Question 1:

  You have altered an index supporting a constraint to be invisible on a large data warehouse table in an X5 Database Machine. Which two statements are true?

  A. You might retain the index, and leave it as invisible, and the constraint will still be recognized and enforced.
  B. You must retain the index and make it visible again for the constraint to be recognized and enforced.
  C. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.
  D. You might drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags for the constraint to be recognized.
  E. You might drop the index and make the constraint invisible, for the constraint to be recognized and enforced.
  B. You must retain the index and make it visible again for the constraint to be recognized and enforced.
  C. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.

  ---

  B: With making indexes invisible, we can easily check whether indexes are useful without having to drop (and in case recreate) them actually. While this may be of interest for "ordinary" Oracle Databases already, it is particular a useful feature for Exadata where we expect some conventional indexes to become obsolete after a migration.

  C: DISABLE NOVALIDATE RELY means: "I don't want an index and constraint checking to slow down my batch data loading into datawarehouse, but the optimizer can RELY on my data loading routine and assume this constraint is enforced by other mechanism". This information can greatly help optimizer to use correct materialized view when rewriting queries. So if you don't use materialized views for query rewrite then you can put RELY for all your constraints (or NORELY for all your constraints) and forget about it.

• Question 2:

  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
  A. Upgrading the Storage Server software package using RPM
  C. Installing an alternative package manager

• Question 3:

  Identify two supported modifications to an X5 Database Machine.

  A. installing a Host Bus Adapter (HBA) in the compute nodes
  B. installing additional Operating System (O/S) packages on the compute nodes
  C. installing additional Operating System (O/S) packages on the Exadata storage servers
  D. installing a Host Bus Adapter (HBA) in the storage servers
  E. replacing the Cisco Ethernet switch with another make or model
  F. replacing the Infiniband switches with another make or model
  B. installing additional Operating System (O/S) packages on the compute nodes
  D. installing a Host Bus Adapter (HBA) in the storage servers

  ---

  B: Updating Exadata Database Servers (compute nodes).

  The software and firmware components that are updated for a specific release depend on the current Exadata software release the database server is running and the release you are updating to. Linux operating system packages and

  Exadata software are always updated while firmware may be updated for only a small selection of the components or not at all.

  D: The storage cells (storage servers/nodes) contain HBAs, and spare PCI I/O slots.

  References: https://docs.oracle.com/cd/E41033_01/html/E55032/bbgiabie.html http://docs.oracle.com/cd/E80920_01/DBMMN/updating-exadata-software.htm#DBMMN-GUID-AB25ED9A-7920-441A-9A60-14ED2753B01C

• Question 4:

  You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.

  You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.

  You issue this command on the first cell:

  

  You examine the output from the first cell which contains:

  

  Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

  A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
  B. CT_IO_UTIL_SM and CT_IO_UTIL_LG
  C. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
  D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ
  D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

  ---

  CT_IO_RQ_SM

  The cumulative number of small I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category.

  CT_IO_RQ_LG

  The cumulative number of large I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category.

  CT_IO_WT_SM_RQ

  The average IORM wait time per request for small I/O requests issued to hard disks by an IORM category.

  CT_IO_WT_LG_RQ

  The average IORM wait time per request for large I/O requests issued to hard disks by an IORM category.

  Incorrect Answers:

  A: CT_IO_RQ_SM_SEC

  This metric is derived from CT_IO_RQ_SM. It specifies the rate of small I/O requests issued by the category for hard disks. Its units are number of I/O requests per second. A large value indicates a heavy I/O workload from this category in the

  past minute.

  B: CT_IO_UTIL_SM

  The percentage of disk resources utilized by small requests from this category.

  References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm

• Question 5:

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

  A. The down time allowed for the migration
  B. Endian format of the source database
  C. Number of tablespaces in the source database
  D. The type of database workloads
  E. Size of the source database
  B. Endian format of the source database
  D. The type of database workloads
  E. Size of the source database

  ---

  B: Endian format: Non-Exadata format

  D: Use Real Production Workload ?Real Application Testing (RAT)

  1.

  Database Workload Replay

  2.

  SQL Performance Analyzer (SPA)

  Reference: http://www.oracle.com/technetwork/database/availability/xmigration-11-133466.pdf Exadata MAA Best Practices, Migrating Oracle Databases

• Question 6:

  Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?

  A. Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
  B. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelogmode.
  C. cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
  D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelogmode.
  E. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.
  D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelogmode.
  E. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.

  ---

  D: Whenever data blocks change, the Change Tracking Writer (CTWR) background process tracks the changed blocks in a private area of memory.

  When RMAN performs an incremental backup on the Exadata platform, cellsrv filters out unwanted blocks and sends back only those that have changed since the last level 0 or level 1 backup.

  E: For the Exadata platform, you may choose to allow cellserv to do all the blocking filtering for incremental backups.

  Note: RMAN block change tracking is used to improve the performance of incremental backup. The level 0 incremental backup scans the entire database but level 1 incremental backups use the block change tracking file to scan only the

  blocks that have changed since the last backup. This significantly reduces the amount of reads that are required on the database.

  References: Expert Oracle Exadata (29 Aug 2015), page 319

• Question 7:

  Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

  A. The Infiniband subnet master location can be determined by using the getmaster command run on any database server.
  B. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.
  C. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.
  D. The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility.
  E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.
  F. The InfiniBand port monitoring is automatic on the database servers and is managed by Enterprise Manager.
  B. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.
  C. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.
  E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.

  ---

  B: From any InfiniBand switch in the network (leaf switch or spine switch), log in as root and run the getmaster command to obtain the location of the master SM as follows:

  # getmaster

  This command displays the host name or IP address and the IP address of the switch where the master SM is running.

  C: CellCLI> list ibport - Will display InfiniBand configuration details

  E: The DBMCLI utility is the command-line administration tool for configuring database servers, and managing objects in the server environment. The LIST IBPORT command displays attributes for InfiniBand ports determined by the specified attributes and filters.

  References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadata-dbmcli.htm

  https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-108CBD7EB989.htm

• Question 8:

  Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

  A. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
  B. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
  C. Cloud control can monitor and manage a Database Machine compute node expansion rack.
  D. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.
  E. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
  F. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
  G. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.
  B. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
  C. Cloud control can monitor and manage a Database Machine compute node expansion rack.
  F. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
  G. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.

  ---

  B (not A): Oracle Exadata components--including database and storage servers, switches, and power distribution units (PDUs)--use SNMP to raise alerts and report monitoring information. Oracle's CellCLI interface is a Java-based framework delivered by the storage cell's management server process (MS) that provides administrative capabilities to your storage server entities.

  C: Cloud control can monitor the Exadata Database Machine.

  Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers.

  

  G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units.

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

• Question 9:

  Which two statements are true about Database Server Metrics and Alerts on an X5 Database Machine?

  A. Database Server Metrics are collected my MMON.
  B. Database Server Metrics are collected by the MS process and stored in an internal disk-based repository.
  C. Database Server hardware sensor alerts are detected by the MS process on the database server.
  D. Database Server Metrics are collected by the RS process.
  E. Database Server Threshold Alerts may be forwarded by the MS process as SNMP traps.
  B. Database Server Metrics are collected by the MS process and stored in an internal disk-based repository.
  E. Database Server Threshold Alerts may be forwarded by the MS process as SNMP traps.

• Question 10:

  Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

  A. There is one plug-in for Cloud Control.
  B. There are several separate plug-ins for Cloud Control.
  C. Some components of the Database Machine require SNMP trap forwarders.
  D. All components of the Database Machine require SNMP trap forwarders.
  A. There is one plug-in for Cloud Control.
  C. Some components of the Database Machine require SNMP trap forwarders.