The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）

单项选择题Youcreatedatabularreportforthesalesdepartmenttodisplayeachcustomerandthesalespersonassigntothecustomer.Thedataissortedbycustomerusingtheorderbyclauseinthisquery.Thisisdepartmentmanagerasksyoutoalterthereportsothatdataissortedbysalespersonratherthanbycustomer.Whatisthebestwaytomaketheneededchange?（）

A.Recreate the query and default the layout. 
B.Alter the query, default the layout and redo the boiler plates. 
C.Query and manually change the layout to save the boiler plate. 
D.Alter the query and make no further change.

单项选择题Youcreatedadepartmentreportandpreviewitinlifepreview.Thefontforthedepartmentnameistoosmallandyouwanttoenlargeitbutdonotwanttochangethefontforanyotherfields.Whatistheeasiestwaytomakethischange?（）

A.Select the text to be enlarged in the life previewer and make the size change using the style bar. 
B.Select the text to be enlarged in the layout mode and make the change. 
C.Open the report wizard in the re-entrant mode and make the change. 
D.Make the copy of the report, open the copy, make the changes and then delete the original report. 

单项选择题Youcreatedatabularreportforhumanresourcesdepartment.Afterviewinglayoutusershaverequestedthatyouchangethelabelofthedeptcolumntosomethingmoremeaningful.Howwouldyouchangethelabelinthelivepreviewer?（）

A.Use the report wizard to change the column label. 
B.Click and high light the column label and replace it with desired text. 
C.Click the column label and alter its property palette. 
D.Click the dept column and alter its property palette. 

单项选择题HowaremessagesdisplayedwhenyouusetheSRW.MESSAGEpackagedprocedure?（）

A.Dialogue box that implicitly determines report execution. 
B.Message line that implicitly determines report execution. 
C.Message line that suppresses the default oracle message. 
D.Dialogue box that does not terminate report execution. 
E.Dialogue box that suppresses the default oracle message.

单项选择题UsingthereportwizardyoucreateatabularreporttodisplayallthecolumnsintheEMPtable.Therecordsareorderedbythedeptnameandjobcolumns.Youneedtocreateahierarchicalreportthatbreaksonthedeptnameandjobvalues.Usingthedatamodelhowwouldyoucreatethisbreakstructure?（）

A.Specify the break order on the gemp group Property palette. 
B.Specify a break order on the dept_name and job columns property palettes. 
C.Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
D.Change the position of the dept_name and the job columns within the gemp group.