【正文】 WHERE region_id = 5。Transaction T3 UPDATE SET region_name=39。 WHERE region_id = 5。Transaction T2 UPDATE SET region_name=39。)。You configure the file in the client machine to set a nonzero value for theOCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?A. to avoid round trips to the server by enabling caching of query results in client memory為了避免往返服務器通過啟用緩存查詢結果的客戶機的記憶B. to improve performance by storing a copy of the data from the private SQL area of the PGAC. to enhance the query performance by creating a cache in the client memory for sorting operationsD. to avoid the storing of query plans and results in the server by creating a cache in the client memory plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose allthat apply.)A. the SQL textB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN) the following SQL statements:Transaction T1 INSERT INTO VALUES (5,39。END。MY_QUICKTUNE_TASK39。39。CA39。SELECT COUNT(*) FROM customersThe safer , easier way to help you pass any IT exams.13 / 193WHERE cust_state_province =39。 SQLVARIABLE sql_stmt VARCHAR2(4000)。語句）的影響，以確定性能是否有凈提高。創(chuàng)建一個新索引可能會對查詢有幫助，但也可能增加DML 的響應時間。優(yōu)化指導會分別考察指導任務中包括的每個SQLD. Run the Segment Advisor for remendations. 運行部分顧問的建議。 SQL Tuning Advisor configuration has default settings in your database instance. Which remendation is automatically implemented after the SQL Tuning Advisor is run as part of theautomatic maintenance task?SQL調優(yōu)顧問配置默認設置在你的數(shù)據(jù)庫實例。B. It checks whether the alias metadata directory and the file directory are linked correctly.C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location ondisk if the blocks on the original location cannot be read properly.、讀取塊從一個好復制的ASM鏡子,重寫他們另一個磁盤上的位置如果原始位置上的塊不能正常閱讀。C. The backup is deleted after one day, regardless of the default retention policy settings.D. The backup bees obsolete after one day, regardless of the default retention policy settings. 備份變得過時的一天后,無論默認保留策略設置。RESTORE POINT TESTDB06。 the following RMAN mand:BACKUP DATABASETAG TESTDBKEEP UNTIL 39。C. ALTER DISKGROUP data CHECK FILE。 two statements are correct about database transportation? (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database andcannot be changedD. The COMPATIBLE parameter must be set to or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format恢復管理器(RMAN)用于將必要的數(shù)據(jù)文件的數(shù)據(jù)庫,如果目標平臺是不同的,有不同的端字節(jié)格式 your production database, you:Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regularintervals Set the control file autobackup to onAre maintaining image copies of the database filesYou have lost the server parameter tile (SPFILE) and the control file. Which option must you consider before restoring the SPFILI: and the control file by using the control file autobackup?A. setting DBID for the databaseB. using the RMAN SWITCH mandC. Using the RMAN SET NEWNAME mandD. starting up the database Instance In the NOMOUNT state須啟動到nomount狀態(tài)來restore spfile和control file want to perform the following operations for the DATA ASM disk group:Verify the consistency of the disk.The safer , easier way to help you pass any IT exams.11 / 193Crosscheck all the file extent maps and allocation tables for consistency. heck whether the aliasmetadata directory and file directory are linked correctly.Check that ASM metadata directories do not have unreachable allocated blocks.Which mand acplishes these tasks?A. ALTER DISKGROUP data CHECK。如果ORACLE_BASE環(huán)境變量已設置，則DIAGNOSTIC_DEST被設置為$ORACLE_BASE two statements are true with respect to the maintenance window? (Choose two.)A. A DBA can enable or disable an individual task in all maintenance windows.DBA可以啟用或禁用一個單獨的任務在所有的維護窗口。C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to故選C，正確The safer , easier way to help you pass any IT exams.10 / 193 two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)關于Oracle數(shù)據(jù)庫11g中的自動診斷信息庫（ADR）哪兩個陳述是真實的?A. A single ADR can support multiple ADR homes for different database instances.B. The alert files are stored in XML file format in the TRACE directory of each ADR home.C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.A. A single ADR can support multiple ADR homes for different database instances. You need statistics to be collected more quickly. What can you do to achieve this?A. Set DYNAMIC_SAMPLING to level 4.B. Set the STATISTICS_LEVEL parameter to BASIC. C. Set the INCREMENTAL value to TRUE for thepartition table.D. Increase the value of STALE_PERCENT for the partition table.默認情況下INCREMENTALGLOBAL39。SALES39。SH39。使用RMAN交叉檢查命令回收歸檔記錄空間。你會意識到，閃回恢復區(qū)被噴射似地非常快地填充起來且運行空間不足， 你的數(shù)據(jù)庫閃回恢復區(qū)空間不足，你沒有更多的空間在磁盤上。您正在使用閃回恢復區(qū)（11g第2版中的快速恢復區(qū)）在你的數(shù)據(jù)庫中存儲與備份相關的文件。The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You wantto check the impact on the performance of the queries if the index is not available. You do not want theindex to be dropped or rebuilt to perform this te