Which statement is true about Oracle compression?
Answer : C,D
Explanation: C: Tables are organized by column and compressed. This makes it much easier to get similar values together, which enhances the compression greatly. D: It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations. If frequent DML operations are planned on a table or partition, then the Oracle Advanced Compression
Option is better suited for such data.
Which statement is true about instance caging setup?
Answer : D
Explanation: * In 11.2G there is new option called Instance Caging which enables to limit number of CPUs which can be seen/used by a database.
* Enabling Instance Caging
1. Manually set dynamic parameter cpu_count on instance level. As default this parameter is set to maximum number of cpu available on a hosts. alter system set cpu_count=2;
2. Enable any resource manager plan that manages CPU. Most easy is to turn on default
Oracle plan DEFAULT_PLAN.
alter system set resource_manager_plan=DEFAULT_PLAN;
* Provisioning CPU
There are generally 2 ways to distribute your CPU between databases
Partitioning sum of all CPUs assigned to all your databases equals number of CPUs on a host. Databases dont interfere with each other.
Over-provisioning sum of all CPUs assigned to all your databases is higher that number of CPUs on a host. Databases can impact on each other performance.
Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.
Answer : B
What are the three customer options for hosting the Platinum Services Advanced Support
Answer : A,C,E
Explanation: Oracle provides a flexible model for deployment of the Oracle Advanced
Support Gateway via no charge software that can be
installed in three configurations:
1. On x86 customer provided servers;
2. On x86 servers purchased from Oracle;
3. Installed on Oracle Exalogic Elastic Cloud or Oracle SuperCluster systems.
Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers running certified configurations of Oracle Exadata
Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster, at no additional cost.
Which statement is true about Enterprise Manager 12c for Exadata?
Answer : D
Explanation: All the code required for monitoring the various Oracle Exadata hardware components has been bundled into the Oracle Exadata plug-in that is pushed to the agents running on the Oracle Exadata Compute (or Database) nodes. Once the plug-in is deployed on the compute nodes, the database machine is ready for discovery with Oracle
Not A: Since agents only run on the compute nodes it is important to assign specific agents to different Oracle Exadata components. Not B: Oracle Exadata Discovery in Oracle
Enterprise Manager 12c -
Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.
Answer : C
Explanation: Parallelizing loads with external tables enables a more efficient space management compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.
A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance of the control file, Oracle recommends that the control file be __________?
Answer : D
What are three ways to be informed of an Exadata Storage Server disk failure?
Answer : A,D,E
Explanation: A: A disk status change would be associated with an entry in the storage cell alerthistory.
D: The Cell Alert Delivery Configuration Worksheet allows you to provide SMTP details to allow for e-mail communication of various cell alerts and failures.
Not F: Use the iostat command to report statistics about disk input and output, and to produce measures of throughput, utilization, queue lengths, transaction rates, and service time.
Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.
Answer : B,D
Explanation: Patch Installation and Testing
1. Review patch documentation
README and referenced Support Notes
2. (B) Validate in test environment
Verify patch installation (HealthCheck Note 1070954.1)
Verify functionality and performance
Define and test fallback plans
3. Apply in production environment
(D) Data Guard Standby-First Patch Apply
Monitor for regressions
Support Note 1262380.1 -
Which two statements appropriately describe the backup and recovery procedures on
Answer : A,D
Explanation: A: Your Exadata Storage Servers do not need to be backed up; Exadata automatically backs these up using a self-maintained internal USB drive.
D: Backup your Oracle databases using Oracle RMAN
Which two actions are permitted with Exadata Database Machine?
48-port Gigabit Ethernet switch
B. installing a second Ethernet switch in the Exadata rack for client access network connectivity
C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand
Gateway Switch -
D. configuring a Linux active-active channel bonding on the database servers by using two
10-Gigabit Ethernet port
E. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers
Answer : A,C
Explanation: There are total two category of network switches used to prepare computing environment inside the rack.
* InfiniBand Switches - two models used depending on requirements
Sun Oracle 36-port InfiniBand Switch
Sun Oracle InfiniBand Gateway Switch
* Ethernet Switch - primarily for management purposes
Cisco Catalyst 4948 -
Common information that applies to both of these InfiniBand switches
Form Factor: One rack unit (1U) height
Power Supplies: Two -
Cooling Fans: Five -
IB Subnet Management: Yes -
Firmware Upgradeable: Yes -
Command Line Access: Yes. Via ssh and usb-serial access
Web Based Management: Yes -
SNMP Access: Yes -
As you might have figured out by now that the IB Gateway switch is almost like a super set of 36-port switch in terms of features and capabilities.
Not E: Since the Exadata hardware cannot be modified, it is not supported to add HBA cards to any of the Exadata servers. It is supported to present storage via the network ports on the database servers via NFS or iSCSI, although Fibre Channel over Ethernet (FCoE) is not supported.
Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on
Answer : B,D,E
Explanation: B (not c): To enable the features in 11g Release 2, use the parallel_degree_policy parameter (by default this stuff is off - parameter is set to manual).
For Auto DOP, setting this to limited is sufficient. If you want more functionality (in-memory parallel processing and parallel statement queuing parallel_degree_policy should be set to auto).
* What if you dont have Exadata? Chances are that if your system is large enough to warrant Auto DOP, it is similar enough to Exadata to behave nicely with this number.
* Auto DOP is only useful in systems with enough CPUs and disks to make concurrent parallel processing feasible. It was designed mostly for Exadata, or for systems of similar size. 48 CPUs and 84 disks sound like a nice start
Which two statements are true about Exadata memory capabilities?
Answer : D,E
Explanation: D: ORACLE EXADATA DATABASE MACHINE X3-8 features include:
160 CPU cores and 4 TB of memory for database processing
E: Database servers X3-2 -
A third generation was announced in 2012. Each Database Server with
2 x Eight-Core Intel Xeon E5-2690 Processors (2.9 GHz)
128 GB Memory (expandable to 256GB)
What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?
Answer : B,D
Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.
Answer : D
Explanation: The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must run Solaris or Linux as the operating system.