找考题网-背景图
多项选择题

You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?()

A.RUN_PRODUCT 
B.SET_REPORT_OBJECT_PROPERTY 
C.RUN_REPORT_OBJECT 
D.FIND_REPORT_OBJECT 
E.REPORT_OBJECT_STATUS 
F.COPY_REPORT_OBJECT_OUTPUT

热门试题

单项选择题YouarecreatingtheSAL_INFOdatablockontheEMP_QUERYform.TheSALARYfieldshouldonlybepopulatedifthelogged-onuserisamanager.Sincethisquerycouldpotentiallyreturnalargeamountofrecords,youhavecreatedastoredprocedurewhichusesarefcursoronwhichtobasethedatablock.Howwouldyoucreatethedatablock?()

A.Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 
B.Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 
C.Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 
D.Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 
E.Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.