Verified of 1z0-485 free draindumps materials and braindump for Oracle certification for IT specialist, Real Success Guaranteed with Updated 1z0-485 pdf dumps vce Materials. 100% PASS Oracle Exadata Database Machine 2014 Implementation Essentials exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-485 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1z0-485 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1z0-485-exam-dumps.html
Q21. 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.
Answer: D
Q22. 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
Q23. Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?
A. Exadata DRAM
B. InfiniBand network cache
C. high performance SAS disks
D. Smart Flash Log
E. Hybrid Columnar Compression
Answer: D
Q24. Which two actions are permitted with Exadata Database Machine?
A. replacing the Ethernet switch with an equivalent 1U48-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
Answer: AC
Q25. You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O savings as a result of the storage indexes. Which two statements are true?
SQL> select count (*) from transmap.mymap_comp
2 where map_id between 400 and 500;
COUNT(*)
103000
Elapsed: 00:00:00.08
SQL> select b.name, a.value/1024/1024 value
from vSmystat a, vSstatname b,
where b.statistic# = a.statistic#
and b.nafne in (.cell physical IO bytes eligible for predicate offload',
cell physical IO interconnect bytes',
cell physical IO bytes saved by storage index',
cell physical IO interconnect bytes returned by smart scan') order by 1;
Statistic Value (MB)
cell physical IO bytes eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00 cell physical IO interconnect bytes 1.72 cell physical IO interconnect bytes returned by smart scan 1.68
A. The storage indexes were disabled using the disable_storage_INDEX Parameter.
B. Storage Index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
C. Since the database was started, no quires were run against this table with the same predicate.
D. The storage indexes reduced the amount of physical I/O bytes significantly for this query.
Answer: BC
Q26. 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
Q27. 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
F. review of database server iostat output
Answer: ADE
Q28. Which two statements describe correct network configuration for Exadata Database Machine?
A. The InfiniBand network subnet manager runs on all database servers to achieve High Availability.
B. Oracle Clusterware communication is configured to use the management network.
C. The InfiniBand network interfaces on Linux servers are configured using active-passive bonding.
D. Database connections to the SCAN listener route through the Ethernet switch in the Exadata rack.
E. Database servers are deployed with three logical network interfaces configured: management, client access, and private.
Answer: CE
Q29. Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:
1. The Exadata cell services software conducts I/O requests on I MO storage regions.
2. cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.
3. The database is started.
4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.
5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.
6. A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
7. MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column during the I/O request.
A. 3. 7, 5, 2, 1, 6, and 4
B. 3, 7, 1, 5, 6, 2, and 4
C. 3, 6, 1.7, 2, 5and 4
D. 3,5, 1, 7, 6, 2. and 4
Answer: D
Q30. 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