单项选择题

A.Recreate the query and default the layout. B.Alter th……

You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）

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.

单项选择题Youcreateasalaryreporttodisplayemployeesalariesgroupedbythedeptcolumn.Youneedtochangethebreakorderfromascendingtodescendingusingthemodel.Howwouldyoureversethedisplayorderofthedepartment?（）

A.Double click the dept column in the group to alter the property palette and change the break out order value.
B.Double click the dept column in the group to open the property palette and change the set break order value.
C.Double click the g_dept group object to change the break order.
D.Click the dept column in the group to change the break order.