Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 72 of 95
Use reports profile executable statement. Use SQL trace facility. 52. Why is it preferable to create a fewer no. of queries in the data model. Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data. 53. What are the various methods of performing a calculation in a report ? 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model. 54. Which of the above methods is the faster method? performing the calculation in the query is faster. 55. Why is a Where clause faster than a group filter or a format trigger? Because, in a where clause the condition is applied during data retrieval than after retrieving the data. 56. What is the main diff. bet. Reports 2.0 & Reports 2.5? Report 2.5 is object oriented. 57. What is the diff. bet. setting up of parameters in reports 2.0 reports 2.5? LOVs can be attached to parameters in the reports 2.5 parameter form. 58. How is link tool operation different bet. reports 2 & 2.5? In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field. REPORT 2.5 SPECIFIC ISSUES. 59.What are the two types views available in the object navigator(specific to report 2.5)? View by structure and view by type . 60. Which of the two views should objects according to possession? |