Oracle 1Z0-027 問題集

質問 1：
Identifiy the correct sequence ofi commands to completely power off a Database Machine in an Orderly fiashion:
1. Execute "crsctl stop cluster -all" as the grid user firom one database server.
2. Execute "crsctl stop cluster -all" as the root user firom one database server.
3. Power off all network switches using their power switch.
4. Execute "crsctl stop cluster -all" as the root user firom one database server.
5. Execute "crsctl stop cluster -all" as the grid user firom one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
9. Execute "shutdown -h now" on all servers.
A. 2, 8, 7, 3 and 6
B. 1, 9, 3 and 6
C. 2, 7, 8 and 6
D. 2, 8, 7 and 6
E. 5, 8, 7, 3 and 6
F. 1, 8, 7, 3 and 6
G. 4, 7, 8, 3 and 6
H. 2, 9 and 6
正解：C

質問 2：
You plan to migrate a database supporting an an OLTP workload to your Database Machine
This is part ofi a consolidation project and several other databases already exist on the Database Machine.
Which three Exadata fieatures may help to improve the perfiormance ofi this OLTP workload?
A. Hybrid Columnar Compression
B. Smart Flash Cache
C. I/O Resource Manager
D. Smart Flash Log
E. Smart Scan
F. Storage Index
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which statement is true about operating systems on database Machine multi-rack configuration consisting ofi two fiull
racks and one Exadata storage rack?
A. All Exadata storage servers and all database servers must run the Oracle Linux O/S and X3-8 database server may
run the Oracle Solaris O/S.
B. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run
the Oracle Linux O/s.
C. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run
the same O/s.
D. All Exadata storage servers in the same cluster must run the same O/S but Exadata Storage Servers in different
clusters may run a different O/S.
E. All Exadata Storage Servers must run the Oracle Solaris O/S and all database servers within the same cluster must
run the same O/S.
正解：C

質問 4：
Which three statements are true regarding the configuration ofi Auto Service Request (ASR) on your Database
Machine?
A. ASR Manager may be installed on any type ofi server running Oracle Linux.
B. SMTP must be enabled on at least one database server.
C. Oracle Solaris must be used on the server where ASK Manager is installed.
D. Oracle Linux must be used on the server where ASR Manager is installed
E. HTTPS connectivity must be enabled firom the ASK Manager host to the internet.
F. ASR Manager must be installed on one ofi the database servers.
G. ASR Manager may be installed on any type ofi server running Oracle Solaris.
正解：A,E,G
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true concerning the allocation ofi I/O resources by the IORM within the CELLSRV process?
A. Ifi two consumer groups P and Q In the PROD database get 20% and 10% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they got 10% and 5% respectively, and the Interdatabase plan
has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the
same categories.
B. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
C. Ifi two consumer groups A and B in the PROD database get 10% and 15% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they got 20% and 30% respectively, provided that the category
plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.
D. Ifi two consumer groups C and D In the PROD database get 10% and 15% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they still got 10% and 15% respectively and were remapped to a
different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.
E. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes ofi the IORM
plan.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 メンバーにのみ表示されます)

質問 7：
Which three must be true fior Smart Scans to be done?
A. Having direct path reads used at run time
B. Cell_offload_process = true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
are stored.
C. Having a 4 meg AU size fior the ASM diskgroup containing the tablespace in which tables accessed by a query are
stored
D. Executing a query in parallel
E. Setting _serial_direct_read=true in the session issuing the SQL statements
F. cell.smart_scan_capable=true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
are stored.
正解：A,E,F