All Oracle Apps

Frequently Asked Interview Questions

Oracle Reports

61) Can you define a Summary Column at a group Level?

      Yes we can.

62) Does links are created by default?

      No

63) Because of the creation of Links the relationship between which two objects is created?

      Group and Query.

64) To produce control break reports, to produce maximum reports and to summarize data at intermediate kevel which object is need?

      Group Object.

65) If you change a query name after the group has been created, can you change the name of the group?

      No, You cannot.

66) If we take one query ex: select d.id, e.salry from emp e, dept d where e.dept_id = d.id order by salary And if we create break group with d.id. What will happen?

      Here order by clause is modified just like order by l, salary.

67) A link defines a Parent/Child relationship between a group and a query. Is it true? If yes via which two keys?

      Primary and Foreign

68) Which term in SQL is related to “link” in reports?

      Join

69) Can you create a link from child query to parent query?

      No, always creates a link from parent query to child query.

70) What is Bind reference?

      A bind reference replaces a single value or an expression.

71) What is Lexical reference?

      A Lexical reference replaces any part of a select statement such a s column name, from clause, where clause order by clause.

72) In which case parameter is created by default?

      In case of bind reference parameter is created by default.

73) Bind reference is used to replace which clause?

      WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

74) Lexical reference is used to replace which clause?

      SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

75) What is a User Parameter?

      It is an object that you can hold values that user can change at runtime.

76) What are the properties of Parameter?

      Datatype, width, Input Mask, Initial Value and Validation Trigger.

77) What is the function of ‘Restrict the list of pre-determined values?

      It is used to determine whether to prevent users from entering any value not included in your list.

78) If you uncheck the restricted values checkbox what will happen?

      User can also enter values to the List Box.

79) Does Oracle Reports allow DML operation in Format Trigger?

      No

80) When you use Group Filter in Data Model?

      group filter is a PL/SQL function that determines which records to include in a group, if the Filter Type property is PL/SQL. The function must return a boolean value (TRUE or FALSE). Depending on whether the function returns TRUE or FALSE, the current record is included or excluded from the report. You can access group filters from the Object Navigator, the Property Palette (the PL/SQL Filter property), or the PL/SQL Editor.

Group Filter restrictions:

  • Group filters cannot be added to groups if Filter Type is First or Last.
  • Group filters cannot be added to cross-product groups.
  • In a group filters, you can read the values of Report Builder columns and parameters of the correct frequency (look at the rule below), but you cannot directly set their values. For example, you can use the value of a parameter called COUNT1 in a condition (e.g., IF :COUNT1 = 10), but you cannot directly set its value in an assignment statement
  • (e.g., :COUNT1 = 10). Note also that the use of PL/SQL global variables to indirectly set the values of columns or parameters is not supported. If you do this, you may get unpredictable results. You also cannot reference any page-dependent columns (i.e., Reset At of Page) or columns that rely on page-dependent columns in a group filter.
  • The function that you enter for a group filter can only depend upon the following columns:
  • a database column owned by the group's query or a query above it in the data model hierarchy
  • Computed columns (formulas or summaries) that depend on unrelated queries (i.e., computed columns that do not depend upon columns in the group, the group's ancestors, or the group's descendants)

81) Why you need to restrict records in a specific group?

82) Whenever a where clause in q query is not applicable which data model trigger is Useful?

      A Group Filter.

83) Do you add a filter to a Matrix Cross Product group?

      No, you cannot.

84) A Matrix Report is also referred to as “CROSS TAB” report. Is it True?

      Yes

85) How many types of Matrix Reports are there? Tell me their names?

      There are 4 types. Simple Matrix, Nested Matrix, Multi Query Matrix with Break ad Matrix Break.

86) If you build a Matrix report with only one query, how many groups are require in addition to one created by default?

      3 Groups are required.

87) How many types of query structures are there? Tell me the Names?

      Two. They are: One_query_Matrix and Multi_query_Matrix.

88) Matrix reports are build with for or more groups. Is it True?

      Yes

89) What is the difference between Nested Matrix and a Matrix Break?

      In case of Matrix Break, one or more groups are a parent of the cross product group. And in case of Nested matrix, three or more groups are surrounded by he cross product group.

90) What are the components of a Report Builder?

      Object Navigator, Layout Model, Data Model, Property Pallet and PL/SQL Editor.

                                                                                                                       Previous    Next