Oracle Reports Interview Questions & Answers 3

Oracle Reports Interview Questions & Answers,
31. Can a repeating frame be created without a data group as a base?

32. Can a field be used in a report without it appearing in any data group?

33. For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

34. Is it possible to centre an object horizontally in a repeating frame that has a variable horizontal size?

35. If yes, how?
By the use anchors.

36. What are the two repeating frame always associated with matrix object?
One down repeating frame below one across repeating frame.

37. Is it possible to split the print previewer into more than one region?

38. Does a grouping done for objects in the layout editor affect the grouping done in 
the data model editor?

39. How can a square be drawn in the layout editor of the report writer?
By using the rectangle tool while pressing the (Constraint) key.

40. To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
& physical page no.

41. What does the term panel refer to with regard to pages?
A panel is the no. of physical pages needed to print one logical page.

42. What is an anchoring object & what is its use?
An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself. 

43. What is a physical page? & what is a logical page?
A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

44. What is the frame & repeating frame?
A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.