Oracle 1z0-338 問題集

質問 1：
Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)
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

質問 2：
Which two statements are true about metrics in the DBMCLI utility? (Choose two.)
A. Metric values are computed and stored in memory, and then permanently stored on disk.
B. DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.
C. Fields in AlertHistory cannot be modified.
D. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.
E. DBMCLI can be used to report on Exadata storage server metrics.
正解：A,D

質問 3：
Storage indexes are unique to Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:
1 . The Exadata cell services software conducts I/O requests on 1 MB storage regions.
2 . cellsrv checks the high and low values, and determines that the storage region does not contain any values that meet the predicate.
3. The database is started.
4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.
5. A query is issued against the MYOBJ_CTRL table that has a predicate
OBJECT_ID=1500.
6. A subsequent query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
7. The MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the l/O request.
A. 3, 5, 1, 7, 6, 2 and 4
B. 3, 5, 2, 1, 6, 7, and 4
C. 3. 6, 1, 7, 2, 5, and 4
D. 3, 7, 5, 2, 1, 6, and 4
E. 3, 7, 1, 5, 6, 2, and 4
正解：B

質問 4：
Which three options describe the flash memory capabilities of the Exadata X6-2 database and storage servers? (Choose three.)
A. 8 x 3.2 TB NVMe flash cards on the EF storage server
B. 8 x 3.2 TB NVMe flash cards on the HC storage server
C. 4 x 3.2 TB NVMe flash cards on the HC storage server
D. no flash storage on the database server
E. 4 x 3.2 TB NVMe flash cards on the database server
正解：A,C,D

質問 5：
When preparing to install ASR on your customer's Exadata Database Machine, which user account will you use first to configure the Exadata Database Server?
A. asmadmin
B. celladmin
C. root
D. oracle
E. asradmin
F. asruser
正解：C

質問 6：
Which characteristics of DBFS on Exadata would you suggest as being a key benefit?
A. Tens of thousands of files are the perfect use case for DBFS on Exadata.
B. DBFS in an Exadata environment is faster than an NFS mount system because of smart scan performance gain.
C. When using DBFS customers will not need to use FUSE or any client software to administer the file system.
D. DBFS offers tremendous I/O bandwidth.
E. DBFS allow customer to store LOB and CLOB files external to database for more flexibility.
正解：A

質問 7：
Which statement is true about Oracle compression?
A. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.
B. A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each partition.
C. Hybrid Columnar Compression can be defined for a single column.
D. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.
正解：D

質問 8：
Which statement is true about the Exadata CELLBOOT USB?
A. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.
B. Each patch that is performed on the Exadata storage servers requires manual resync of the CELLBOOT USB.
C. Regular Exadata storage server patches make sure that the internal USB is updated so that it can be used for recovery.
D. changes to network configurationles are possible without using ipconf.p1 as long as all the relevant files are updated.
E. Some space from the CELLBOOT USB is used for cache metadata when write-back flash cache is enabled.
正解：C