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

A.Report level trigger. B.Group filter. C.Format trigge……

You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?()

A.Report level trigger. 
B.Group filter. 
C.Format trigger. 
D.None of the above.

热门试题

单项选择题YouarecreatingtheDEPT_SALdatablockfromthePAYHISTform.UsersshouldbeabletoenteravaliddepartmentIDnumber,whichwillthendisplaytheemployeesalaryinformationforthatdepartment.Thisdatablockcouldpotentiallyretrievealargenumberofrecords.Sinceuserswillprobablyonlyviewasmallnumberoftheserecords,only10recordsshouldbefetchedatonetime.Howwouldyoucreatethedatablock?()

A.Select 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 block on the columns from the tables. 
C.Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
D.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 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
E.Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.