Oracle 1Z0-027 問題集

質問 1：
You recently upgraded your Exadata image to the latest release; previously you were using 11.2.0.3.
At the same time, you decide to address some perfiormance problems as fiollows:
You noticed increased latency fior the database log writer, especially during the quarterly battery learn cycle on the
cells.
You have complaints ofi erratic perfiormance firom certain write-intensive applications.
Which two actions could improve perfiormance in these areas?
A. Configure Smart Flash Log on the cells to use some ofi these ofi the space on the cell flash devices.
B. Enable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.
C. Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP fior the tables belonging to the affected
application.
D. Configure Smart Flash Log on the database server to use server flash memory.
E. Configure the table belonging to the affected application using CELLCLI, to the set CELL_FLASH_CACHE = KEEP.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three are true abort Enterprise Manager plug- in configuration fior the Database Machine?
A. Some plug-ins require SNMP trap fiorwarders.
B. All plug-ins require SNMP trap fiorwarders.
C. There is one plug-in fior Grid Control.
D. There are several separate plug-ins fior Grid Control.
E. There are several separate plug-ins fior Cloud Control.
F. There is one plug-in fior Cloud Control.
正解：A,D,E

質問 3：
Which three are among the software components that constitute the QoS Management firamework?
A. Cluster Health Monitor (CHM)
B. Grid Infirastructure fior a cluster
C. Cluster Verification Utility (CLUVFY)
D. OC4J cluster resource
E. Grid Infirastructure fior a standalone server
F. O/S Resource Manager
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three fiactors should you consider when choosing a method fior migrating a database to the Database Machine?
A. Size ofi the source database
B. Number ofi tablespaces in the source database
C. Endian fiormat ofi the source database
D. ASM attributes and allocation unit (AU) size ofi the diskgroups used by the source database
E. Type ofi database workload
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You have used setupem.sh to deploy a plug in fior Grid Control.
In which two ways do all the targets supported by the plug-in get configured?
A. The targets must be configured by an O/S administrator manually.
B. The targets must be configured by a database administrator manually.
C. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.
D. There may be more than one target fior each plug-in.
E. Setupem.sh is used again to configure the targets.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You are evaluating the perfiormance ofi a SQL statement that accesses a very large table, and have run the fiollowing
query producing the output shown:

For which two reasons would the; "physical read total bytes" statistic be greater than the "cell physical IO bytes
eligible fior predicate offload" statistic?
A. There is an uncommitted transaction that has modified some ofi the table blocks, causing some "cell single block
physical reads" to be requested by the database instance, resulting in additional I/O fior block in the cells.
B. There are migrated rows in the table, causing some "cell single block physical reads" to be requested by the
database instance, resulting in additional I/O fior blocks in the cells.
C. There is an index on the column used in the where clause, causing "cell multiblock physical reads" to be requested
by the database instance, resulting in additional I/O fior blocks in the cells.
D. The table is an IOT and has an overflow segment, causing "cell multiblock physical reads" to be requested by the
database instance, resulting in additional I/O fior block in the cells.
E. The table is an indexed clustered table, causing "cell single block physical reads" to be requested by the database
instance, resulting in additional I/O fior blocks in the cells.
正解：D,E

質問 7：
You are about to replace one memory DIMM in an Exadata storage server and need to power off the affected cell.
Which fiour commands must you execute to safiely power off the storage server in your standard deployed quarter rack
Database Machine assuming that redundancy is not compromised?
A. 'shutdown -h now' on the affected cell
B. CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != 'Yes'
C. 'crsctl stop cluster -all' on one ofi the database servers
D. CellCLI> LIST GRIDDISK WHERE STATUS != 'inactive'
E. CellCLI> ALTER GRIDDISK ALL INACTIVE
正解：A,B,D,E
解説: (Topexam メンバーにのみ表示されます)