It is super fast transforming dynamic society just about every it is transforming we have been always on proceed. This is simply a usual task information that a lot of folks vision to acquire just one, but the truth is must struggle and also qualified you as being a qualified family that matches almost all over requiems, an individual aren?¡¥t heading get the vision task effortlessly, the actual idea that will qualified you so that you can new element from it always be some sort of Oracle 1z0-485 Certificaion.

2016 Aug 1z0-485 exam question

Q11. Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack. 

A. Remove the doors of the 1/8th rack. 

Add the new servers. 

Cable the Database Servers in the rack. 

Cable the Exadata Storage Servers in the rack. 

Close the rack. 


B. Activate all cores by using a software command. 

Activate all hard drives and flash drives. 

Create the grid disks. 

Expand the Oracle ASM diskgroups. 

Review the new configuration. 


C. Remove the doors of the 1/8th rack. 

Add an additional Sun Datacenter InfiniBand Switch. 

Add the new servers. 

Cable the Database Servers in the rack. 

Cable the Exadata Storage Servers in the rack. 

Close the rack. 

Configure the new hardware. 


D. Activate all cores by using a software command. 

Activate all hard drives and flash drives. 


Answer: B 


Q12. Identify the relevant steps in the correct order for activating an Auto Service Request (ASR) configuration. 

1. Add SNMP traps manually or using OneCommand. 

2. Install ASR Manager. 

3. Activate a node on ASR Manager. 

4. Validate the configuration. 

5. Register ASR Manager with Oracle. 

A. 2, 5, 1, 3, and 4 

B. 2, 4, I, 3, and 5 

C. 5, 2, 4, 1, and 3 

D. 5, 4, 2, 1, and 3 

Answer: A 


Q13. Which three statements are true about Automatic Degree ofParallelism (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 ofParallelism 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. 

Answer: BDE 


Q14. When using IORM, which statement accurately describes when redo log file writes take place? 

A. Based on the priority of the user 

B. Immediately 

C. Based on the resource group of the user 

D. Based on the intradatabase resource plan 

Answer: B


Q15. Which two statements are true about enabling write-back flash cache? 

A. When enabling write-back flash cache in a non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks. 

B. Before using write-back flash cache, you need to verify the minimum required versions. 

C. Before write back-flash cache is enabled, you need to drop the Flash Cache first. 

D. The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv. 

E. When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first. 

Answer: BC 


certifyforall.com

Abreast of the times 1z0-485 exam question:

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

Answer: BD 


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

C. DBFS offers tremendous I/O bandwidth. 

Answer: B 


Q18. Which two statements are true about Exadata memory capabilities? 

A. X3-8 can be purchased in a Half Rack configuration with 2 TB of memory. 

B. X3-2 memory can be expanded to 512 GB per node from 256 GB. 

C. X3-2 memory can be upgraded to use Flash in the compute nodes. 

D. X3-8 memory is fixed at 4 TB per a Rack. 

E. X3-2 can be purchased in a Half Rack configuration with 256 GB per node. 

Answer: DE 


Q19. ORRECT TEXT 

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. 

Answer: CE 


Q20. 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. Use the ILOM Web GUI. 

B. Use the dcli command at the root prompt on a database node. 

C. Attach a terminal device to the back panel of the server with a serial cable. 

D. Connect by using SQL *Plus. 

E. Log in as root on the database node using the Net1 IP address. 

Answer: AC