Online Access Free 1z0-485 Practice Test

Which statement is true about the patching features provided in Platinum Services?

• A.Patching services are available for the full software stack up to twice per year.
• B.Rolling window and complete down time approaches are two options to patching.
• C.Patching support includes Exadata, Exalogic, and Database Appliance.
• D.Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

• A.COMPRESS FOR ARCHIVE
• B.COMPRESS BASIC
• C.COMPRESS
• D.COMPRESS FOR QUERY
• E.COMPRESS FOR OLTP

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

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

Identify two tasks that the Database Resource Manager can perform, which the I/O Resource Manager cannot.

• A.Manage the number of parallel sessions for a query.
• B.Terminate database sessions when certain limits have been reached.
• C.Manage I/O based on the application that is connected to the database.
• D.Manage the throughput of an I/O-bound application based on the service name used for the connection.
• E.Manage I/O and CPU between databases on the same cluster or physical database host.

What are two choices that a customer must make that impact diskgroup creation?

• A.What is the level of redundancy required?
• B.What OS will be run?
• C.How many databases will run on the cluster?
• D.Where will disk backups be written?