Oracle 1Z0-485 dumps - 100% Pass Guarantee!

The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?

A. Average the mpstat id1 output from all the nodes.

B. Ask application users if they have noticed a slowdown in screen response.

C. Look for an increase in batch job servicing times.

D. A and B above

Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

A. INSERT

B. INSERT with an APPEND hint

C. UPDATE

D. CREATE TABLE AS SELECT

Which two statements are true about migrating your database to Exadata?

A. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.

B. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.

C. ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,

D. Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.

E. All indexes should be dropped when migrating to Exadata.

Which two actions are permitted with Exadata Database Machine?

A. replacing the Ethernet switch with an equivalent 1U 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

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata?

A. Auto DOP is an exclusive feature in Exadata, which allows the database optimizer to evaluate each statement and run it in parallel without special hints.

B. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.

C. Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features.

D. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on the table's block counts.

E. SQL statements that take advantage of Auto DOP am be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.