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.
Which two completely prevent a Smart Scan from occurring?
A. querying a table containing many chained rows
B. querying a table containing many migrated rows
C. performing a minimum or maximum function on an indexed column
D. performing a Fast Full Index scan on a reverse key index
E. referencing more than 255 columns form an OLTP compressed table in a query
F. querying a table containing a JSON column
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
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.
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 a multithreaded 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.
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.
The InfiniBand switches on your X5 Database Machine contain the software version as confirmed using the version command:
[root@exampsw –ib2 bin] # versionSUN DCS 36p version: 1.3.3-2Build time: Apr 4 2015 11:15:19SP board info: Manufacturing Date: 2014.05.05Serial Number: “NCD3X0178” Hardware Revision: 0x0006 Firmware Revision: 0x0102 BIOS version: NOW1R112 BIOS date: 04/24/2014
Which two tools are useful for monitoring the InfiniBand switches for fan problems and by which users should they be run?
A. Run the env_test command on the switches after logging in as the ilom-admin user.
B. Run the getfanspeed command on the switches after logging in as root.
C. Run the env_test command on the switches after logging in as root.
D. Run the showtemps command on the switches after logging in as the ilom-admin user.
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 CELLIP.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.
D. Edit the CELLINIT.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 CELLIP.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.
F. Edit the CELLIP.ORA file on each storage server to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.
Which two must be true for a Smart Scan to occur on a table?
A. Sessions querying the table must set cell_offload_processing = true.
B. It must be stored in an ASM diskgroup with a 4 MByte AU size.
C. It must be heap organized.
D. It must be accessed using direct path reads.
E. The table must not be compressed.
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.
