3i Infotech Placement: Sample Questions 267 - 267 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 267

Question

MCQ▾

What are the types of calculated columns available?

Choices

Choice (4)

a.

Summary, Formula, & Placeholder columns

b.

Summary, Procedure, & Formula columns

c.

Summary, Placeholder, & Procedure column

d.

Procedure, Formula, & Placeholder columns

Answer

a.

Explanation

Define Placeholder Column
  • Summary, Formula & Placeholder columns are the three types of calculated columns.

Summary Column

  • Used for calculating summary information like sum, average etc. on particular columns of a data group.
  • Use a set of oracle aggregate functions.
  • Datatypes of summary column depend on the data type of the source of the summary.

    Following Standard Functions Are Provided by a Summary Column

    • Average
    • Count
    • First
    • Last
    • Maximum
    • Minimum
    • % of Total
    • Sum
    • Variance

Formula Column

  • Allows user-defined computation on the data from of one or more columns.
  • Used to apply some custom logic on input data and return some value.
  • Written using PL/SQL syntax and use PL/SQL function for computation on the data.
  • Value can be character, number, or data and returned value match data type.

Place Holder Column

  • An empty container at design time.
  • Used to hold some value at runtime.
  • Like local or global variables- used in the logic of a formula column or in report triggers.
  • Value can be directly accessible in the report layout.

Developed by: