1. What are BOUSER and BOPASS in Business Objects? How and where do u use? 2. Does Universe Shield the Complexity of the Data base from the end user? Yes/No? How? 3. What is a loop? And why there are no loops in the Data base while there are loops in Business Objects? 4. What is the difference between View and Derived table? 5. What is the difference between a View and Materialized view? 6. What happens to a view when its base table is deleted? 7. What is a Data provider and Give the different types of Data providers in BO. 8. Why and when does u prefer to use stored procedure as Data provider? 9. List some of the Data provider functions you know (Business Objects reporting level) – Mention the purpose of those functions as well. 10. List some Document functions used In Business Objects reporting level. Mention the purpose of those functions as well 11. What is Multi cube function? When and how it is useful? 12. What types of joins can be used to join the tables in the Universe. 13. Which techniques are used to solve the join problems in the Universe? 14. What is purpose of creating Objects in the Universe? 15. Why should we qualify the objects as Dimension, Measures or Detail? 16. Define Object and Row level security. In which module of Business objects can u incorporate them and how? 17. Difference between Case and Decode. Give examples for each of them. 18. Define hierarchy. 19. Define Drill-down, Drill-up and Drill across 20. What is the difference between Drill Across and Drill through? 21. What is the difference between char and varchar data types? 22. What is chasm trap? How can u resolve it? 23. What is fan trap? How can u resolve it? 24. Define Business Objects. 25. Overlapping of table … scenario 26. Difference between Ranking and Rank function 27. How can u find out the author name and title, last printout date and the Data provider name of a particular report? ( variable or options ) 28. How to display each block present in a report in separate pages? 29. Which command can we use to replicate/update the data structure of the Universe? 30. What is staging area? When does u suggest staging? 31. What is the Difference between Top-down and Bottom-up approach? 32. Different types of SCD’s? Which one is better? 33. What is a slowly growing Dimension? 34. What are the sources for the Dimension tables present in the DWH? 35. While loading the Fact and Dimensions into the target which tables should be loaded first and why? 36. Why does an Enterprise need to DWH when there is OLTP database? 37. select * from emp e1 where (N-1) = (select count (distinct (e2.sal)) from emp e2 where e1.sal<e2.sal;
What type of query is this? i. Inline view ii. Sub query iii. Correlated sub query iv. None of the above Suggest Ur answer 38. What will be the result of the following query? Select 2*2 from dual; 39. select * from (select Deptno from emp); Is the above query correct? If not what’s wrong with the query? If yes what type of query is it? 40. What is the difference between Rownum and RowID? 41. What is a Materialized view? 42. Define cube. 43. Connect by prior 44. What is the difference between Derive table and a view? 45. What is input context / Output context in report level? 46. What is the difference between Where and having clause? 47. How to group the values in the report? Explain with an example? (Grouping Quarter1, Quarter2, Quarte3, Quarte4 into Year) 48. What is the difference between sub query and Correlated sub query? 49. What role does cardinality detection play in Universe Design? 50. Difference between cross tab and Slice and dice? 51. Difference between variable and Function. 52. Can we create a Cross tab report using Dimensions Objects only or Measure Objects are compulsory? Yes/NO 53.