Oracle 1z0-485 問題集

質問 1：
Which statement is true about Enterprise Manager 12c for Exadata?
A. EM Agents can communicate to storage cells via SSH.
B. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.
C. EM Agents are installed on each database and storage node.
D. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.
E. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?
A. Normal redundancy provides HA during rolling Storage Server patching.
B. High redundancy provides more usable storage.
C. High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching
D. Normal redundancy provides more usable storage.
E. High redundancy gives you better I/O performance.
正解：C,D

質問 3：
Which two attributes describe key benefits of the InfiniBand network?
A. All Exadata database servers have a direct path link to each Exadata Storage Server.
B. Oracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.
C. Each InfiniBand link provides 10 Gigabits of bandwidth.
D. Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
E. Cell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
A. insert with an append hint
B. UPDATE
C. CREATE TABLE AS SELECT
D. INSERT
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements accurately describe update of software on Exadata Database Machine?
A. Rolling patching is faster than non-rolling patching, but database down time is longer.
B. Storage server updates require access to an Unbreakable Linux Network (ULN) based repository.
C. The database server operating system software (other than kernel and OFED) may be installed or updated from non-Exadata sources
D. The Oracle Database software on Exadata is updated using standard OPatch and the Oracle Universal Installer.
E. Running Exadata with different storage server software versions is supported, but should be minimized to rolling patching scenarios.
F. The Oracle Database patchset software (for example, 11.2.0.3) requires the Exadata-specific version.
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 cross-platform transportable tablespaces
B. using Data Guard Physical Standby
C. using GoldenGate
D. using incremental cross-platform RMAN restore
E. using SQL Developer migration tools
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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. Since the database was started, no quires were run against this table with the same predicate.
B. The storage indexes reduced the amount of physical I/O bytes significantly for this query.
C. The storage indexes were disabled using the disable_storage_INDEX Parameter.
D. Storage Index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two statements are true about enabling write-back flash cache?
A. Before using write-back flash cache, you need to verify the minimum required versions.
B. Before write back-flash cache is enabled, you need to drop the Flash Cache first.
C. When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells 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 non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)