Oracle 1Z0-027 問題集

質問 1：
Identifiy the three components that serve a purpose only in the Database Machine.
A. Intelligent Database Protocol (IDB)
B. Database Resource Manager (DBRM)
C. The DISKMON process
D. I/O Resource Manager (IORM)
E. ASM intelligent Data Placement (IDP)
F. Database Filesystem (DBFS)
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three are true about Exadata storage server alerts?
A. Storage server alerts are all stateless alerts.
B. Storage server alerts notifications may be sent using SNMP.
C. A storage server alert is only ever issued as a warning or at a critical situation.
D. Storage server alerts are all statefiul alerts.
E. Storage server alerts notifications may be sent using SMTP.
F. A threshold based alert gets cleared automatically when the measured value no longer violates the threshold.
正解：B,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are examining the existing IORM configuration on the cells ofi Database Machine, to see ifi they require my
modifications based on recent changes to various workloads.
All seven cells in your X3-2 halfi-rack shown the fiollowing:

Which two are true about I/O to the cells using this plan?
A. I/O requested in the interactive category may use flashdns ifi the I/O is firom the sales or finance databases, and
these I/O requests are guaranteed to get 90% ofi the I/O ifi the enough I/Os are issued in this category.
B. I/O requests firom the sales database may use flashing regardless ofi the I/O category.
C. I/O requests made by sessions in the marketing database may use flashing and flashcache ifi no other categories or
database or database are using flashing and flashcache at the same time.
D. No I/Os in any category or firom any database may use flashing or flashcache because the objective is off.
E. I/O requests in the batch category may use flashcache ifi the I/O is firom the sales finance database, and these I/O
requests are guaranteed to get 80% ofi the I/O ifi the interactive category I/Os use no more than 20%.
正解：B,E

質問 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：
A table in one ofi your database schemas contains only varchar, number, and date data types fior the columns.
Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, ifi
no other situations arise that prevent Smart Scan firom occurring?
A. Virtual column filtering
B. Nested loop Join filtering
C. Hash join filtering
D. Predicate filtering
E. Sort merge join filtering
F. Column filtering
正解：C,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two are regarding the case ofi storage indexes?
A. To increase the chance ofi using the a storage index, you can make table indexes invisible.
B. The cell physical 10 bytes saved by storage index statistic returns multiple rows, one fior each storage server.
C. Storage indexes are retained after a cell is rebooted.
D. To maximize the benefit ofi storage Indexes, load your data stored on the filtered columns.
E. Avoid the use ofi bind variables because Storage Indexes do not work with bind variables.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
To troubleshoot a possible hardware problem, you consider moving all disk drives firom one Exadata storage server to a replacement chassis.
You must contain storage availability while perfiorming task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not partitioned.
Which two fiactors would prevent you firom moving the disks firom one Exadata storage server to another one?
A. Offline or inactive celldisks in another Exadata server
B. The existence ofi an external redundancy ASM diskgroup
C. The existence ofi an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
D. The existence ofi an ASM diskgroup with the repair_time attribute set to 0.
E. The existence ofi a normal redundancy ASM diskgroup
正解：B,C
解説: (Topexam メンバーにのみ表示されます)