NEW QUESTION 1
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.1
Active image activated: 2011-05-09 16:26:36- 0400 Active image status: success
Active image partition on device: /dev/md6 Active software partition on device: /dev/md8
In partition rollback: Impossible
Cell boot usb partition: /dev/sdm1
Cell boot usb version: 11.2.2.3.1.110429.1
Inactive image version: 11.2.1.2.6
Inactive image activated: 2010-10-04 23:59:16 -0400 Inactive image STATUS: success
Inactive system partition on device: /dev/md5
Inactive 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 physical disk 1
• B. /dev/md6 and /dev/md8 are located only on physicaldisk1
• 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

Answer: BC

NEW QUESTION 2
You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5 Database Machine?

• A. ‘shutdown -h now’on the affected storage servers
• B. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’
• C. CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’
• D. ‘crsctl stop cluster –all’on one of the database servers
• E. CellCLI> ALTER GRIDDISK ALL INACTIVE

Answer: CE

Explanation:
C: 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.
E: 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.

NEW QUESTION 3
Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

• A. IPMI can be used for server configuration and management on each database server.
• B. The Baseboard Management Controller (BMC), which supports IPMI, runs as amultithreaded process on the storage server O/S.
• C. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single- threaded process on the storage server O/S.
• D. IPMI can be used for server configuration and management on each storage server.

Answer: AC

Explanation:
A: IPMI – short for Intelligent Platform Management Interface – is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now
C: Like the KCS interface, the SSIF Interface is only specified as a ‘Single Threaded Interface’ for standard IPMI commands. That is, the BMC implementation is not expected to process more than one IPMI request at a time. While an implementation is allowed to have a degree of ‘command queuing’, for standard IPMI messages the SSIF lacks a ‘Seq’ field that software can use to match up particular instances of requests with responses.
References:https://www.intel.com/content/dam/www/public/us/en/documents/specification-updates/ipmi-intelligent-platform-mgt-interface-spec-2nd-gen-v2-0-spec-update.pdf

NEW QUESTION 4
Which two are true about Smart Scan?

• A. A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.
• B. Column projection does not contribute to the performance benefit of Smart Scan.
• C. A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
• D. It is possible to offload single row functions to the Exadata Storage Servers.
• E. Join processing can be partly offloaded to Exadata Storage Servers.
• F. Join processing can be fully offloaded to Exadata Storage Servers.

Answer: DE

Explanation:
D: 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.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References:http://www.centroid.com/blog/exadata-smart-scan-processing

NEW QUESTION 5
Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

• A. The “keep” cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
• B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
• C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
• D. Single block reads can benefit from Smart Flash Cache.
• E. Multiblock reads can benefit from Smart Flash Cache.

Answer: BDE

Explanation:
D: By default Exadata stores only small I/Os in the Exadata Smart Flash Cache. Small I/Os in most cases are single-block reads. During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are

NEW QUESTION 6
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

Answer: ABD

NEW QUESTION 7
Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5?

• A. Improved performance for Oracle Network traffic
• B. Improved reliability for Cache Fusion RAC network traffic
• C. Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
• D. Improved performance for ASM rebalance network traffic
• E. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands

Answer: BC

Explanation:
Active-passive bonding provides reliability through failover.

NEW QUESTION 8
Which two statements are true about the X5 Exadata storage server rescue procedure?

• A. The rescue procedure can be executed from the CELLBOOT USB flash drive.
• B. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
• C. The rescue procedure can be used to repair corruption in an ASM diskgroup.
• D. The rescue procedure can be used to restore a corrupt system area.
• E. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.

Answer: AD

Explanation:
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage- servers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE

NEW QUESTION 9
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 17b
Port 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 Gbps LinkState: ......................Active
PhysLinkState: ................LinkUp
LinkSpeedActive: ..............10.0 Gbps
LinkSpeedEnabled: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

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

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

NEW QUESTION 10
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

Answer: AC

NEW QUESTION 11
You plan to partition the database and storage grids in an X5-2 full rack, creating two clusters and two storage grids without using virtualization.
One cluster will be used for production and should consist of six database servers and nine storage servers.
The other cluster will be used for test and development, and should consist of two database servers and five storage servers.
The storage must be partitioned so that the storage servers are visible only to the appropriate database servers that are meant to access them.
What must be done to achieve this?

• A. Configure Exadata realms using Oracle ASM-scoped security mode.
• B. Configure Exadata realms using Database –scoped security mode.
• C. Edit the CELLI
• D. ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.
• E. Edit the CELLINI
• F. ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.
• G. Edit the CELLI
• H. ORA file on each database server to contain IP addresses of database servers which are allowed access to specific storage servers in the same storage grid.
• I. Edit the CELLI
• J. ORA file on each storage server on contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.

Answer: C

Explanation:
The cellinit.ora file is host-specific, and contains all database IP addresses that connect to the storage network used by Oracle Exadata Storage Servers. This file must exist for each
database that connect to Oracle Exadata Storage Servers.
The cellinit.ora file contains the database IP addresses. The cellip.ora file contains the storage cell IP addresses. Both files are located on the database server host.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-configuring.htm#SAGUG20369

NEW QUESTION 12
You plan to consolidate multiple mission-critical databases onto a single rack Exadata X6
database Machine.
You do not plan to use virtualization on the database servers.
You have identified two database categories, based on differing availability and maintenance objectives.
Which two choices will be the best solution?

• A. Create a single database cluster that accesses a single storage grid.
• B. Create a single database cluster that accesses multiple storage grids.
• C. Partition the Exadata storage servers into two separate storage grids.
• D. Create a single storage grid and share space on the celldisks using Exadata storage realms.
• E. Partition the database servers into two separate clusters.

Answer: BE

NEW QUESTION 13
Which three statements are true about bulk data loading capabilities in an X5 Database Machine environment?

• A. DBFS must use the DBFS_DG diskgroup for any DBFS store.
• B. DBFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• C. DBFS must be used to have a POSIX-compliant shared storage solution that is accessible from the database servers on a Database Machine.
• D. DBFS must be used to bulk load data into a production database on the Database Machine.
• E. ACFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• F. ACFS must be used to have a POSIX –compliant shared storage solution that is accessible from the database servers on a Database Machine.
• G. ACFS may use the DBFS_DG diskgroup to contain the ADVM volume file.

Answer: BCD

Explanation:
External tables on DBFS file-systems provide the probably the most high-performance way to bulk load data into your database.
Bulk Data Loading
Describe the various options for staging data to be bulk loading into Database Machine Configure the Database File System (DBFS) feature for staging input data files
Use external tables based on input data files stored in DBFS to perform high-performance data loads

NEW QUESTION 14
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.

Answer: AC

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

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

Answer: BCF

Explanation:
B: Oracle ASR Manager only processes SNMP traps that are sent from IP addresses that Oracle ASR Manager recognizes.
Example of Exadata Storage Server SNMP Trap
This example shows the SNMP trap for an Exadata Storage Server disk failure. The corresponding hardware alert code has been highlighted.
2011-09-07 10:59:54 server1.example.com [UDP: [192.85.884.156]:61945]:
RFC1213-MIB::sysUpTime.0 = Timeticks: (52455631) 6 days, 1:42:36.31 SNMPv2-SMI::snmpModules.1.1.4.1.0 = OID: SUN-HW-TRAP-
MIB::sunHwTrapHardDriveFault
SUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database Machine
Etc.
C (not D): The ASR Manager uses the SNMP GET protocol to query ASR assets for additional fault information.
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
References: http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm
https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD 331

NEW QUESTION 16
Which three must be true for a Smart Scan to occur for a table?

• A. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
• B. The query must be executed serially.
• C. The query must be executed in parallel.
• D. Direct path reads must be used at run time.
• E. The ASM diskgroup containing the table’s tablespace must have a 4 Mbyte AU size.
• F. The ASM diskgroup containing the table’s tablespace must have cell.smart_scan_capable set to true.

Answer: ADF

Explanation:
A: pt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.

NEW QUESTION 17
You plan to monitor the status of the motherboard, memory, power, fans, and network
cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

• A. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.
• B. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.
• C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
• D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Answer: D

NEW 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 filesystem-based repository.
• E. Cell alerts are written to disk every hour by default.

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

NEW QUESTION 19
Which three statements are true about the CELLCLI command?

• A. It can execute commands on multiple storage servers in parallel.
• B. It has command-line history.
• C. It requires root privileges to create CELLDISKS and GRIDDISKS.
• D. It can be executed on storage servers.
• E. It can be executed using the DCLI utility.

Answer: BDE

Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- cellcli.htm

NEW QUESTION 20
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

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-transportable-tablespace.html

NEW QUESTION 21
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

Answer: ACF

NEW QUESTION 22
......