Oracle 1z0-070 問題集

質問 1：
You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups.
You want to check for potential space problems that take ASM mirroring requirements into account.
Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?
A. usable_file_mb
B. total_mb
C. free_mb
D. required_mirror_free_mb
E. cold_used_mb
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which type or types of network traffic are transported over the internal InfiniBand interconnect in Exadata Database Machine X5?
A. Both clustered ASM and clustered database instance traffic only
B. IDB protocol traffic and clustered ASM instance traffic only
C. IDB protocol traffic and clustered database instance traffic only
D. IDB protocol traffic, clustered ASM traffic, and clustered database instance traffic
E. IDB protocol traffic only
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an X5 Database Machine?
A. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.
B. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.
C. Hard disks are scanned every two weeks by default in all situations.
D. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.
E. Hard disks are scanned every two weeks by default but only when disks are idle.
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three statements are true about the EXADCLI utility?
A. It may be run interactively.
B. It can be used to execute O/S commands on multiple storage servers in parallel.
C. It can be used to execute EXACLI scripts on multiple storage servers in parallel.
D. It can be used to execute EXACLI commands on multiple storage servers in parallel.
E. It uses the same security mechanism as the EXACLI command.
F. It may be used to execute DBMCLI commands on multiple database nodes in parallel.
正解：D,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:

Identify two reasons why the "physical read total bytes" statistic is greater than the "cell physical IO bytes eligible for predicate offload" statistic.
A. 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.
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.
C. There is an uncommitted transaction that has modified some of the table blocks, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.
D. The table is an index clustered table, causing "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.
E. 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.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements are true about Exadata storage server alerts in an X5 Database Machine?
A. A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.
B. Storage server alerts are all stateless alerts.
C. Storage server alerts notifications may be sent using SNMP.
D. Storage server alerts are all stateful alerts.
E. A storage server alert is only ever issued as a warning or at a critical situation.
F. Storage server alerts notifications may be sent using SMTP.
正解：A,C,E

質問 7：
Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?
A. the RECO_<DBM_Name> ASM diskgroup
B. Exadata Smart Flash Cache using all of the flashdisk space
C. mirrored system area on hard disk 0, hard disk 1, and hard disk 2
D. the DATA_<DBM_Name> ASM diskgroup
E. mirrored system area on hard disk 0 and hard disk 1
F. the DBFS_DG diskgroup with high redundancy
正解：A,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two statements are true about backup performance when using Recovery Manager (RMAN) on an X5 Database Machine?
A. Backups are fast, because all data blocks are read from the Exadata Smart Flash Cache.
B. Backups are fast because the Infiniband network is faster than fiber channel storage, so RMAN read I/O operations are faster than in traditional storage networks.
C. Backups are fast, because data blocks are read from the Database Flash Cache.
D. Backups are fast, because physical I/Os operations are reduced by the use of the Storage Index by cellsrv.
E. For incremental backups using Block Change Tracking, cellsrv filters blocks and returns only those that have changed since the last backup.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)