Oracle Oracle Certifications 1Z0-070 Questions & Answers

• Question 11:

  A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns.

  Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table?

  A. Column filtering

  B. MIN/MAX scans

  C. Virtual column filtering

  D. Nested loop join filtering

  E. Sort-merge join filtering

  F. Predicate filtering

  Correct Answer: AFC

  

  Reference: https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/1367127.pdf

• Question 12:

  Which two statements are true about the EXACLI utility?

  A. It can execute commands on multiple cells in parallel.

  B. It supports all CELLCLI commands.

  C. It requires the same privileges as the celladmin linux user to create CELLDISKS and GRIDDISKS.

  D. It can be executed using the EXADCLI utility.

  E. It can be executed directly on cells.

  F. It requires access through a cell user that has role-based privileges granted.

  Correct Answer: AD

  Explanation:

  The exadcli utility facilitates centralized management across an Oracle Exadata system by automating the

  execution of ExaCLI commands.

  Exadcli executes the commands on a set of remote nodes and returns the output to the centralized

  management location where the exadcli utility was run.

  The exadcli utility runs commands on multiple remote nodes in parallel threads.

  

  Reference: https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/ exadcli.html#GUID-1C738F05-2A69-4B75-BB1E-B578C9081487

• Question 13:

  Which two network switch failure scenarios on a standalone Exadata Database Machine X5-2 Full Rack will affect database availability?

  A. failure of the Ethernet switch only

  B. failure of both the InfiniBand leaf switches

  C. failure of a single InfiniBand leaf switch and the Ethernet switch

  D. failure of a single InfiniBand leaf switch

  E. failure of both the InfiniBand leaf switches and the Ethernet switch

  Correct Answer: BE

  Explanation:

  Ethernet switch for administrative connectivity to servers in the Database Machine

  Connect any combination of up to 18 Exadata Database Machine racks or Exadata Storage Expansion

  Racks via the InfiniBand fabric. Larger Configurations can be built with external InfiniBand switches.

  Connected racks can be any combination of v2, X2, X3 or X4 generation hardware.

  

  Reference: https://www.oracle.com/technetwork/database/exadata/exadata-storage-expansion-x5-2-ds-2406252.pdf

• Question 14:

  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.

  Correct Answer: BCE

  Explanation:

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

  An important application has been migrated to a database on an X5 Database Machine.

  You are examining high-load SQL statements from this application, in an attempt to determine which ones will benefit from the Exadata Smart Scan capability.

  Which three access paths always generate “cell single block physical read” or “cell multiblock physical read” requests?

  A. Index fast full scans executed in parallel

  B. Full table scans on heap organized tables executed in parallel

  C. Full table scans on heap organized tables executed serially

  D. Full table scans on index organized tables executed in parallel

  E. Index unique scan access by primary key to heap organized tables executed in parallel

  F. Index unique scan access by primary key to heap organized tables executed serially

  Correct Answer: ACF

• Question 16:

  You are checking the status of the ports on one of the InfiniBand switches on your X5 Database Machine.

  You run the getportstatus command as shown:

  [root@exampsw-ib2 bin]# getportstatus 17bPort status for connector 17B Switch Port 2 Adminstate:......................Enabled LinkWidthEnabled: ...............1X or 4X LinkWidthSupported:..............1X or 4X LinkWidthActive..................4X

  LinkSpeedSupported: . ....2.5 Gbps or 5.0 Gbps or 10.0 GbpsLinkState: ....................Active PhysLinkState: ................LinkUpLinkSpeedActive: ...........10.0 GbpsLinkSpeedEnabled: .

  ...2.5 Gbps or 5.0 Gbps or 10.0 Gbps

  You have 36 ports to check.

  A. Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root.

  B. Use Enterprise Manager.Cloud Control.

  C. Use Enterprise Manager Express.

  D. Create user-defined metrics for the InfiniBand switch.

  Correct Answer: AB

  Explanation:

  There are two approaches for monitoring Oracle Exadata Storage Servers: using a command-line interface

  (CLI) or using the graphical interface provided by the Oracle Enterprise Manager Cloud Control 12c console.

  You can manually monitor the InfiniBand Switch Ports with the ibqueryerrors.pl command.

  Run the ibqueryerrors.pl command to report on switch port error counters and port configuration

  information using the command:

  # ibqueryerrors.pl -rR -s RcvSwRelayErrors,XmtDiscards,XmtWait,VL15Dropped

  

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

• Question 17:

  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

  Correct Answer: BDE

  Explanation:

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

  Which two statements are true about Exadata X5 cell metrics and alerts?

  A. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository.

  B. Cell metrics are written to disk every hour by default.

  C. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository.

  D. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystembased repository.

  E. Cell alerts are written to disk every hour by default.

  Correct Answer: BD

  Explanation:

  Metrics are a series of measurements that are computed and retained in memory for an interval of time,

  and stored on a disk for a more permanent history.

  On the storage servers, the CELLSRV process provides the majority of Oracle Exadata storage services

  and is the primary storage software component. One of its functions is to process, collect, and store

  metrics. 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.

  

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

• Question 19:

  Which three statements are true about the EXADCLI utility?

  A. It may be run interactively.

  B. It can be used to execute EXACLI scripts on multiple storage servers in parallel.

  C. It can be used to execute O/S commands on multiple storage servers in parallel.

  D. It can be used to execute EXACLI commands on multiple storage servers in parallel.

  E. It uses the same security mechanism as the EXACLI command.

  F. It may be used to execute DBMCLI commands on multiple database nodes in parallel.

  Correct Answer: DEF

  Explanation:

  The exadcli utility runs commands on multiple remote nodes in parallel threads.

  You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.

  Incorrect Answers:

  A: Note that exadcli runs ExaCLI in a “no-prompt” mode. This means that if user interaction is needed (for example, if you need to enter a password or if you need to verify that the certificate from a remote node is valid), then exadcli will exit with an error.

  References:

  

  http://docs.oracle.com/cd/E80920_01/DBMMN/exadcli.htm#DBMMN-GUID-4AE469A6-F291-4737-B975-F1B4B91D0BA0 https://docs.oracle.com/cd/E62172_01/html/E63692/z400007d1478481.html

• Question 20:

  A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.

  The script must run on each cell simultaneously.

  How would you achieve this?

  A. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.

  B. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.

  C. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.

  D. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.

  E. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.

  Correct Answer: C

  Explanation:

  The exadcli utility runs commands on multiple remote nodes in parallel threads.

  You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.

  

  References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadcli.htm#DBMMN-GUID-4AE469A6-F291-4737-B975-F1B4B91D0BA0