1Z0-485 Online Practice Questions and Answers

How would you execute CellCLI commands and scripts?

A. using SQL*Plus on database nodes

B. by CellCLI commands executed on the database nodes

C. using third party tools after installing the CellCLI RPM plug-in

D. directly executing the commands and scripts on the Exadata storage cell

E. remotely by connecting to Port 1521 using SSL

Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

A. database views

B. InfiniBand networking

C. Flash Cache

D. high performance SAS2 disk drives

E. cell offloading

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

A. Enable Smart Flash Log.

B. Execute alter table ... cell_flash_cache=keep on heavily scanned tables.

C. Enable Write Back Flash Cache.

D. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

A. Enable Write-Back Flash Cache due to heavy DBWR usage.

B. Enable Write-Back Flash Cache due to heavy LGWR usage.

C. Swap hard disks to High Capacity disks.

D. Tune the application to reduce I/O requests. 100% Real QandAs | 100% Real Pass

E. Leverage IORM to give priority to critical workloads.

100% Real QandAs | 100% Real Pass

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. Patching support includes Exadata, Exalogic, and Database Appliance.

C. Rolling window and complete down time approaches are two options to patching.

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

B. COMPRESS BASIC

C. COMPRESS FOR OLTP

D. COMPRESS FOR QUERY

E. COMPRESS FOR ARCHIVE

Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

A. using GoldenGate

B. using SQL Developer migration tools

C. using Data Guard Physical Standby

D. using cross-platform transportable tablespaces

E. using incremental cross-platform RMAN restore

Which statement is true about instance caging setup?

A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.

B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.

C. Database instances need to be restarted to make changes to cpu_count effective.

D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing

E. The init.org parameter resource_manager_plan should be set.

Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

A. DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.

B. Tens of thousands of files are the perfect use case for DBFS on Exadata. 100% Real QandAs | 100% Real Pass

C. DBFS offers tremendous I/O bandwidth.

What are three ways to be informed of an Exadata Storage Server disk failure?

A. review of the output of LIST ALERTHISTORY

B. review of the output of SELECT STATUS FROM VSDATAFILE

C. review of the ILOM log

D. alert notifications through email when SMTP notification is configured

E. alert notifications in the Enterprise Manager Exadata Plug-In 100% Real QandAs | 100% Real Pass

F. review of database server iostat output