Oracle 1z0-338 問題集

質問 1：
Which options does not benefit from storage offload processing?
A. incremental backups with block change tracking
B. table scans
C. column filtering
D. joins and aggregation
E. indexes that rely on B-Tree pointers
正解：E

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

質問 3：
Which three statements describe the memory capabilities of the X6-2 Exadata system?
A. The database server can contain 768GB memory.
B. The database server come with 512GB memory by default.
C. The HC and EF storage servers contain 128GB memory.
D. The HC and EF server come with 512GB memory default.
E. The database server come with 256GB memory default.
正解：A,C,E

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

質問 5：
Which two statements appropriately describe the backup and recovery procedures on Exadata? (Choose two.)
A. The data that is stored in a database is backed up and restored by using CellCLI commands.
B. The database server software backup is automatic and recovery is accomplished by using a rescue procedure.
C. The cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.
D. The data that is stored in a database is backed up and restored by using RMAN commands.
E. The cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
正解：C,D

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

質問 7：
A customer has received an email notification about a temperature alert on one of the storage servers on their Exadata system.
What action can the customer take to further investigate the alert?
A. Log in to the Oracle database and query v$temperature.
B. SSH to the storage server and use the CeIICLI sensor_check command to get information about the storage server's health.
C. Log in to the ILOM service processor and view the current status of the sensors and indicators on the system.
D. Run exachk to find the system component that might be having a problem.
E. Enter the data center and immediately power off the storage server.
正解：B

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