Oracle 1z0-338 問題集

質問 1：
Which three items are the main elements of Oracle Database Resource Manager? (Choose three.)
A. IORMPLAN object
B. resource consumer group
C. resource plan
D. resource plan directive
E. SQL Explain Plan
正解：B,C,D

質問 2：
You are measuring the I/O savings provided by storage indexes for Table A.
One of your scripts displays the I/O sayings as a result of the storage indexes.
Which two statements are true? (Choose two.)

A. The accumulated I/O saved by the storage index is 1.68 MB.
B. The storage index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
C. The storage indexes reduced the amount of physical I/O bytes significantly for this query.
D. The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.
E. Since the database was started, no queries were run against this table with the same predicate.
正解：B,C

質問 3：
A cloud user is assigned the Service Administrator role.
Which cloud actions can this user perform?
A. View, create, update, and delete Oracle Compute Cloud Service resources.
B. Work with one or more Oracle Cloud services only and use the My Services application to manage his or her own password and security challenge questions.
C. Perform cloud backups of a specific instance.
D. Perform all tasks in the My Services application, including user and role management tasks.
E. View only the Oracle Compute Cloud resources.
正解：A

質問 4：
Which two statements are true about migrating your database to Exadata? (Choose two.)
A. ASM and the database best practice configuration that is supplied during Exadata deployment should be retained during and after migration.
B. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
C. All indexes should be dropped when migrating to Exadata.
D. The logical migration methods allow more flexibility in changing the database structure for best performance than the physical methods.
E. 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.
正解：A,D

質問 5：
Where would your customer go to find the latest Exadata patches?
A. My Oracle Support note 888828.1.
B. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID: 835032.1).
C. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.
D. The Exadata owner guide.
E. The patch database in my Oracle support.
正解：A

質問 6：
Which statement is true about the patching features provided in Platinum Services?
A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
B. Patching support includes Exadata, Exalogic, and Database Appliance.
C. Patching services are available for the full software stack up to twice per year.
D. The rolling window and complete down time approaches are two options to patching.
正解：C

質問 7：
To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the compute node. exadbcpatchmulti uses the exadbcpatch.cfg file to provide information about the location of files related to patching operations as well as additional parameters related to these operations.
What is the purpose of the sw_bkup_needed=1 parameter that can be set in the exadbcpatch.cfg file?
A. performs a backup of each Oracle home directory before a patch is applied
B. adds a dialog box that prompts for a backup before the patch can be applied
C. creates a backup of the patch in case of an error in the patching routine
D. creates a backup of the Oracle database data files
E. forces the software to create a backup of the exadbpatch.cfg file
正解：D

質問 8：
Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.
Which architecture would you suggest to solve this deployment issue?
A. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.
B. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.
C. Define the split by setting up database services that are specific to department A and department B.
D. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.
正解：C