【文章內(nèi)容簡介】 ecovery before TSPITR with the Log Sequence Number (LSN)D. Perform Inplete Recovery before TSPITR with the System Change Number (SCN) INV_HISTORY table is created using the mand:SQLCREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))partition by range (inv_date) interval(numtoyminterval(1,39。month39。)) (partition p0values less than (to_date(39。0101200539。,39。ddmmyyyy39。)), partition p1 values less than(to_date(39。0101200639。,39。ddmmyyyy39。)))。The following data has been inserted into the INV_HISTORY table :INV_NO INV_DATE INV_AMT 1 30dec2004 1000 2 30dec2005 2000 3 1feb2006 3000 4 1mar20064000 5 1apr2006 5000You would like to store the data belonging to the year 2006 in a single partition and issue the mand:SQL ALTER TABLE inv_history MERGE PARTITIONSFOR(TO_DATE(39。15feb200639。,39。ddmonyyyy39。)), FOR(TO_DATE(39。15apr200639。)) INTO PARTITION sys_py。What would be the oute of this mand?A. It executes successfully, and the transition point is set to 39。1apr200639。.B. It executes successfully, and the transition point is set to 39。15apr200639。.不在同一分區(qū)C. It produces an error because the partitions specified for merging are not adjacent.D. It produces an error because the date values specified in the merge do not match the date valuesThe safer , easier way to help you pass any IT exams.7 / 193stored in the table. create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following mand:SQL SELECT (39。my_instance_analysis_mode_task39。) FROM dual。You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT39。s segments.What would you do to achieve this?A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task. PL/SQL procedure queries only those columns of a redefined table that were unchanged by theonline table redefinition. What happens to the PL/SQL procedure after the online table redefinition?重新定義A. It remains B. It bees invalid for all options of online table redefinition but automatically gets revalidated the nexttime it is used.C. It bees invalid for all options of online table redefinition and is automatically repiled duringonline redefinition of the table.D. It bees invalid only if the storage parameters have been modified and it automatically getsrevalidated the next time it is used. the Exhibit and examine the resource consumption details for the current plan in use by thedatabase instance.Which two statements are true based on the output? (Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user belonging to DSS_QUERIES can log in to a new session but the session will be queuedC. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource managementD. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited forthe CPU due to resource management, I/O waits, and latch or enqueue contentionThe safer , easier way to help you pass any IT exams.8 / 193 are managing an Oracle Database 11g instance. You want to create a duplicate database fortesting purpose.What are the prerequisites for performing the active database duplication? (Choose all that apply.) 執(zhí)行活動的數(shù)據(jù)庫復制的先決條件是什么A. The source database backup must be copied over the net for test database.B. The source database must be run in ARCHIVELOG mode if the database is open.C. The source database must be shut down cleanly if the database is in mounted state.D. A net service name should be set up and a listener configured with the target as well as the source database.A,從活動數(shù)據(jù)庫復制，不需要拷貝備份。錯誤。B,源數(shù)據(jù)庫必須是歸檔模式，正確。C，如果數(shù)據(jù)庫是mount狀態(tài)，那么源數(shù)據(jù)庫一定是shut down cleanly。正確。D，需要建立網(wǎng)絡(luò)服務(wù)名和配置監(jiān)聽。正確。 index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERStable using the following mand: SQLCREATE INDEX ord_custname_ix ON orders(custname)。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 test.Which is the most efficient method of performing this task?A. disabling the indexB. making the index invisible（無形的）C. making the index unusableD. using the MONITORING USAGE clause for the index tasks can be acplished using the DBMS_LOB. SETOPTIONS procedure?A. only encryption and pression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBsC. deduplication（兩分）, encryption（加密）, and pression（壓縮） settings for all SecureFile LOBsD. deduplication, encryption, and pression settings only for SecureFile CLOBs of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQLrelated problems? (Choose all that apply.)下面哪個SQL收集的信息將被測試用例生成器的問題用于修飾或說明sql相關(guān)問題?A. ADR diagnostic filesB. all the optimizer statistics優(yōu)化程序統(tǒng)計C. initialization parameter settings初使化參數(shù)D. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported onthe table after enabling Flashback Data Archive?A. Drop the table.B. Partition the tableC. Truncate the table.The safer , easier way to help you pass any IT exams.9 / 193D. Add a column to the table.E. Rename a column in the table. are working on a CATDB database that contains an Oracle Database version catalog schemaowned by the user RCO11. The INST1 database contains an Oracle Database version catalogschema owned by the user RCAT10.You