053 (45)

221.

221. toGenerate recommendations toImprove the performance ofASet  ofSQL queriesinchAn application, youExecuteThe following blocks ofCode:BEGINDbms_advisor.create_task (Dbms_advisor.sqlaccess_advisor,'TASK1'); END;/BEGINDbms_advisor.set_task_parameter ('TASK1','Analysis_scope',' All'); Dbms_advisor.set_task_parameter ('TASK1','MODE','Comprehensive');END;/BEGINDbms_advisor.execute_task ('TASK1');d bms_output.put_line (Dbms_advisor.get_task_script ('TASK1'));END;/The blocks ofCodeExecuteSuccessfully; However, do notget the required outcome. What could is the reason? A. A template needs toBe associated withThe task. B. A workload Needs toBe associated withThe task. C. The partialorComplete workload Scope needs toBe associated withThe task. D. The type ofStructures (indexes, materialized views,orpartitions) toBe recommended need tobe specified forThe task.

222.

222. You is managing an OracleDatabase11g instance withASM storage. The ASM instance isDown . toKnow the details ofThe disksinchThe DATADisk Group, you issued the following asmcmd Command:asmcmd>Lsdsk-I-d DATA which statement isTrue regarding the outcome ofThis command? A. The command succeeds but it retrieves onlyTheDisknames. B. The command produces an error because the ASM instance isDown . C. The command succeeds but it shows onlyThe status ofThe ASM instance. D. The command succeeds andRetrieves information byScanning theDiskHeaders based onAn asm_diskstring value.

223.

223 Plan  to Set  for  ComputeStatisticsfor the baseline .

224.

224. You need to CreateA partitionedTable  toStore historical data andYou issued the following command:CREATE TABLEPurchase_interval PARTITION byRANGE (time_id) INTERVAL (Numtoyminterval (1,'Month')) STOREinch(TBS1,TBS2,TBS3) (PARTITION p1VALUESLess THAN (To_date ('1-1-2005','dd-mm-yyyy')), PARTITION P2VALUESLess THAN (To_date ('1-1-','dd-mm-yyyy')))  as SELECT *  fromPurchasesWHEREtime_id<To_date ('1-1-2007','dd-mm-yyyy'); what isThe outcome ofThe above command? A. ItreturnsAn error because the range partitions P1 andP2 should be ofThe same range. B. It creates the partitions (P1, P2). Within each range partition, it creates monthwise subpartitions. C. It creates the partitions of varyingRange. forData beyond'1-1-2007,'It creates partitions withA width ofOneMonthEach . D. ItreturnsAn error because the Number  ofTablespaces (TBS1,TBS2,TBS3) specified does notMatch the Number  ofRange partitions (P1,P2) specified.

225. View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executed the following commands:

Sql> VAR tname VARCHAR2 (60);
sql> begin:tname: = ' my_instance_analysis_mode_task ';
DBMS_ADDM. Insert_segment_directive (: Tname, ' sg_directive ', ' SCOTT ');
END;
Which statement describes the consequence?

A. The ADDM task isFiltered toSuppress the Segment Advisor suggestions forThe SCOTTSchema. B. The ADDM task isFiltered toProduce the Segment Advisor suggestions forThe SCOTTSchema  only. C. The PL/SQL Block produces an error because the My_instance_analysis_mode_task task have notbeen reset toIts initial state. D. AllSubsequent ADDM tasks including My_instance_analysis_mode_task is filtered toSuppress the Segment Advisor suggestions forThe SCOTTSchema.

053 (45)