nerdexam
Oracle

1Z0-450 · Question #26

A new column called TEMPLATE (In bold below) was added to an existing Interactive Report query as shown below. SELECT title, product, release, subproduct, keywords, id, focus_area, template, type…

The correct answer is A. Select Columns and move the TEMPLATE column to be displayed and move it up between FOCUS- D. Change the Report attributes so that TEMPLATE is displayed between FOCUS_AREA and TYPE. A: The new column need to be added to the report. D: Editing Interactive Report Column Attributes You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. Common Report Column Edits for Interactive Reports include: Alter…

Building Forms and Reports

Question

A new column called TEMPLATE (In bold below) was added to an existing Interactive Report query as shown below. SELECT title, product, release, subproduct, keywords, id, focus_area, template, type, link FROM content-repository Which two actions need to be performed so when the report is run, the columns appear as they do in the query on the report by default?

Options

  • ASelect Columns and move the TEMPLATE column to be displayed and move it up between FOCUS-
  • BAdd a control break on the TEMPLATE column.
  • CSave the Report as Default Settings.
  • DChange the Report attributes so that TEMPLATE is displayed between FOCUS_AREA and TYPE.
  • ECreate a sort on the TEMPLATE column.
  • FReset the Interactive Report.

How the community answered

(16 responses)
  • A
    81% (13)
  • B
    6% (1)
  • E
    13% (2)

Explanation

A: The new column need to be added to the report. D: Editing Interactive Report Column Attributes You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. Common Report Column Edits for Interactive Reports include: Alter column display sequence. Incorrect answer: B: You can create a break group of one or several columns by selecting Control Break from the Actions menu. Creating a break group pulls the columns out of the interactive report and displays them as a master record. C: Saving Default Report Settings Default report settings determine the way a report initially displays to end users. End users can then modify any of the settings. To save default report settings: 1. Click the Actions menu and select Save Report. 2. From Save, select As Default Report Settings. F: Resetting a Report You can reset a report back to the default settings by selecting Reset from the Actions menu. Resetting a report removes any customizations you have made.

Topics

#interactive report#column display#default report settings#report attributes

Community Discussion

No community discussion yet for this question.

Full 1Z0-450 Practice