Online Access Free 1z1-485 Practice Test

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

• A.Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.
• B.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.
• C.Oracle's Auto DOP algorithms calculate the Degree ofParallelism based on the table's block counts.
• D.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.
• E.Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features.

Why is ASM High redundancy an important configuration choice when rolling Exadata Storage Server patching is planned?

• A.High redundancy forces ASM rebalance before allowing disks to be taken offline.
• B.High redundancy speeds up ASM fast mirror resync when a cell is brought back online after patching.
• C.High redundancy protects from partner disk failure while a cell is offline being updated.
• D.Normal redundancy provides the same protection during rolling patching, so High redundancy is not important inthis case

You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?

• A.Log in as root on the database node using the Net1 IP address.
• B.Use the ILOM Web GUI.
• C.Attach a terminal device to the back panel of the server with a serial cable.
• D.Use the dcli command at the root prompt on a database node.
• E.Connect by using SQL *Plus.

Which is a best practice for High Availability (HA) in an Exadata environment?

• A.When a standby database is in place, DB_BLOCK_CHECKING is not required and thus not recommended.
• B.Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.
• C.Due to the different architecture that Exadata has with storage servers, compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.
• D.Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.
• E.Checksums performed on the Exadata Storage Server ensure logical consistency of block content.

In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?

• A.Execute alter table ... cell_flash_cache=keep on heavily scanned tables.
• B.Enable Smart Flash Log.
• C.Enable Write Back Flash Cache.
• D.Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.