Oracle 1Z0-485 Exam Questions

Patch Installation and Testing

Guidelines

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

* Automate

* Define and test fallback plans

3. Apply in production environment

* (D) Data Guard Standby-First Patch Apply

* Monitor for regressions

Support Note 1262380.1

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

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.

Incorrect:

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.

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

Incorrect:

Not A:

* What if you don't 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

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)