176、
176.Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.) A. Recover from failures in the RAC environment. B. Diagnose and repair a data file corruption online. C. Diagnose and repair a data file corruption offline. D. Diagnose and repair failures on a standby database.
Answer: AD
177、
177.Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.) A. It can be increased up to the value of the SGA_MAX_SIZE parameter. B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components. C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components. D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.
Answer: AB
178、
178.Which statement is true about the Manageability Monitor (MMON) background process? A. It transfers statistics from memory to disk at regular intervals. B. It coordinates the rebalance activity for disk groups when ASM is used. C. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance. D. It performs dynamic memory management when Automatic Shared Memory Management is enabled
Answer: A
179、
179.Which two statements are true regarding transactions in an Oracle database? (Choose two.) A. Multiple transactions can use the same undo segment. B. A transaction is assigned an undo segment when it is started. C. More than one transaction cannot share the same extent in the undo tablespace. D. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.
Answer: AB
180、
180.You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database? A. Use the external table population. B. Use the Oracle Data Pump export and import utility. C. Use the conventional path data load of the SQL*Loader utility. D. Use the INSERT INTO...SELECT command to load the data.
Answer: C A direct path load does not support loading of clustered tables