1z0-485 | Renewal Oracle 1z0-485 vce
Q21. 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
Answer: D
Q22. When should you use Hybrid Columnar Compression?
A. always
B. on large active tables where deeper compression is desired
C. on tables or partitions that have fairly static data
D. on every table where Advanced Compression is not used
Answer: C
Q23. Identify three Exadata Storage Server software processes and their purpose?
A. CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.
B. CELLSRV: The Cell Server is responsible for balancing workload to other storage servers.
C. MS: The Management Server is responsible for storage cell management and configuration.
D. MS: The Management Server is responsible for starting a local Enterprise Manager agent.
E. RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.
F. RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.
Answer: ACF
Q24. 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
Q25. How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?
A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.
B. Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadatashould be used wisely
C. Partition pruning is not a supported option in the11gR2database codethatruns on an Exadata Machine, due to issues with Cost Based Optimizer plans.
D. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
E. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.
Answer: E
Q26. 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
Q27. Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?
A. adding a High Capacity Storage expansion rack
B. expanding the Exadata rack from a Half Rack to a Full Rack
C. moving underutilized grid disks from the RECO diskgroup to DATA
D. adding a ZFS storage appliance
E. adding a High Performance Storage expansion rack
Answer: AB
Q28. Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.
A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.
B. External tables allow transparent parallelization inside the database.
C. Parallelizing loads with external tables enables more efficient space management.
D. External tables can take advantage of storage indexes to speed up data loads.
Answer: C
Q29. Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exadata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).
A. Host information can be gathered and sent to Oracle for license compliance.
B. Potential issues can be addressed before they impact operations.
C. Priority handling can be extended for SRs, with attached configuration.
D. Exadata patching cannot be done successfully without the Oracle Configuration Manager.
E. Root cause analysis can be accelerated.
Answer: BCE
Q30. 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