Oracle 1z0-338 問題集

質問 1：
Which statement is true about Hybrid Columnar Compression (HCC)?
A. HCC is a good choice for LOBs, BLOBs, and CLOBs.
B. HCC data resides compressed in flash.
C. HCC is best suited for OLTP type databases with a large number of ongoing transactions.
D. HCC being a database feature will work with all types of storage hardware.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true about troubleshooting failed patching activities? (Choose two.)
A. Bundle patches applied by usingopatch autocannot roll back only the database or the grid infrastructure home.
B. Dependency issues found duringyumupdates should be ignored by using theforceoption.
C. Dependency issues that are found duringyumupdates require rolling back to a previous release before retrying.
D. Failed OS patches on database servers can be rolled back.
E. Database server OS updates can be rolled back by usingopatch auto -rollback.
F. Failed storage cell patches are rolled back to the previous release automatically.
正解：B,E

質問 3：
Which two steps are needed to set up instance caging on an Exadata system? (Choose two.)
A. Specify the optimization objective as low_latency or high__throughput.
B. Set PGA_AGGREGATE_LIMIT to an acceptable level for the intended instances.
C. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.
D. Enable a resource plan to manage the CPUs.
E. Change the initialization parameter THREADED_EXECUTION to TRUE and restart the instance.
正解：C,D

質問 4：
Which statement explains the difference between Normal and High redundancy ASM failure groups?
A. High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.
B. Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a single disk failure or an entire storage server failure.
C. Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.
D. Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.
E. Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.
正解：D

質問 5：
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

質問 6：
Which two statements are true about enabling write-back flash cache? (Choose two.)
A. Write-back flash cache requires a minimum required software version.
B. The setting flashCacheMode should be set to Writeback by updating cellkey.ora and restarting cellsrv.
C. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
D. When enabling write-back flash cache in a non-rolling manner, it is important to ensure that asmdeactivationoutcome is set to YES and asmModeStatus is set to ONLINE for all grid disks.
E. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
正解：A,E

質問 7：
Which two options would you use to allow direct path loads to run in parallel on your Exadata platform? (Choose two.)
A. setting the PARALLEL clause on both the external table and the table where you are loading the data
B. creating the required environment by using Smart Scan parallelization
C. adding the PARALLEL hint to the CTAS or IAS statement
D. setting the PARALLEL_FORCE_LOCAL parameter to TRUE
E. setting the initialization parameter PARALLEL_ENABLED to TRUE to enable parallel direct path loads
正解：A,C

質問 8：
Your customer is implementing a storage consolidation strategy on their existing Exadata.
Which step represents the Oracle recommended action that the customer should take in their approach?
A. Do not use IORM because it will interfere with the shared database functionality on Exadata.
B. Use IORM to distribute disk bandwidth among the databases.
C. Set up a resource consumer group within each database instance and manage it individually.
D. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
E. Use ASM to create separate diskgroups for each database instance that is running on Exadata.
正解：B