Oracle 1z0-485 問題集

質問 1：
Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?
A. IPMI commands can be executed by using SNMP traps.
B. IPMI can be used to remotely log in to the operating system.
C. IPMI settings can be secured by backing up the Oracle Linux installation on the storage system.
D. IPMI can be used to remotely start and stop servers.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
What are the three customer options for hosting the Platinum Services Advanced Support Gateway?
A. Provide individual x86 64-Bit gateway hardware.
B. Install in Oracle Virtual Machine with required hardware.
C. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
D. Install on Exadata Engineered System.
E. Install on Oracle Database Appliance.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

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

質問 4：
Which two statements are true about troubleshooting failed patching activities?
A. Database server OS updates can be rolled back using opatch auto -rollback.
B. Failed OS patches on database servers can be rolled back.
C. Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
D. Dependency issues found during yum updates should be ignored using the force option.
E. Failed storage cell patches are rolled back to the previous release automatically.
F. Dependency issues found during yum updates require rolling back to a previous release before retrying.
正解：A,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements appropriately describe the backup and recovery procedures on Exadata?
A. Data stored in a database is backed up and restored by using RMAN commands.
B. Database server software backup is automatic and recovery is accomplished by using a rescue procedure.
C. Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
D. Data stored in a database is backed up and restored by using CellCLI commands.
E. Cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
CORRECT TEXT
Which two statements are true about migrating your database to Exadata?
A) Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
B) Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
C) ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,
D) Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.
E) All indexes should be dropped when migrating to Exadata.
正解：
C,E
Reference:http://www.slideshare.net/monowar94ru/migrating-databases-to-exadata-databasemachine

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