单项选择题
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?()
A.Programme units.
B.PL/SQL libraries.
C.Database object.
D.Built in packages.
相关考题
-
单项选择题
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.
