Oracle Reports Interview Questions & Answers 2

Oracle Reports Interview Questions & Answers,
16. To execute row from being displayed that still use column in the row which property can be used?
Format trigger.

17. Is it possible to set a filter condition in a cross product group in matrix reports?

18. If a break order is set on a column would it effect columns which are under the column?

19. With which function of summary item is the compute at options required?
percentage of total functions.

20. What is the purpose of the product order option in the column property sheet?
To specify the order of individual group evaluation in a cross products.

21. Can a formula column be obtained through a select statement?

22. Can a formula column referred to columns in higher group?

23. How can a break order be created on a column in an existing group?
By dragging the column outside the group.

24. What are the types of calculated columns available?
Summary, Formula, Placeholder column.

25. What is the use of place holder column?
A placeholder column is used to hold a calculated values at a specified place rather than allowing is to appear in the actual row where it has to appeared.

26. What is the use of hidden column?
A hidden column is used to when a column has to embed into boilerplate text.

27. What is the use of break group?
A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

28. If two groups are not linked in the data model editor, what is the hierarchy between them?
Two group that is above are the left most rank higher than the group that is to right or below it.

29. The join defined by the default data link is an outer join yes or no?

30. How can a text file be attached to a report while creating in the report writer?
By using the link file property in the layout boiler plate property sheet.