InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What are the different ways of assigning permissions to OBIEE repository? |
| Answer» | |
| 2. |
Is it possible to create outer join in Physical layer? |
| Answer» | |
| 3. |
When you have Tables T1 and T2 which are not joined, what will happen in BMM layer? |
| Answer» | |
| 4. |
What is the difference between OBIEE 10g and OBIEE 11g administration? |
| Answer» | |
| 5. |
What are different Application roles in BI system? |
| Answer» | |
| 6. |
What is OBIEE Security? How do you define a Security policy in OBIEE system? |
| Answer» | |
| 7. |
What do you understand by Data Level Security and Object Level Security? |
| Answer» | |
| 8. |
What do you understand by connection pool and how many connection pools did you have in your last project? |
| Answer» | |
| 9. |
What is the use of Column Prompts? Where they are used? |
| Answer» | |
| 10. |
What are Inline prompts? |
| Answer» | |
| 11. |
What is Named prompt? |
| Answer» | |
| 12. |
What is the difference between Prompts and Filters? |
| Answer» | |
| 13. |
What is the use of filters in OBIEE? |
| Answer» | |
| 14. |
What is the use of OBIEE Dashboards? What are the Dashboard alerts? |
| Answer» | |
| 15. |
What are the Session Variables? |
| Answer» | |
| 16. |
What is the difference between Static and Dynamic Repository variables? |
| Answer» | |
| 17. |
What do you understand by Repository Variables? What are different type of Repository variables? |
| Answer» | |
| 18. |
What are the different types of Variable in OBIEE? |
| Answer» | |
| 19. |
How Aggregation works in OBIEE? |
| Answer» | |
| 20. |
What do you understand by Level based measures? |
| Answer» | |
| 21. |
What are the different types of dimension hierarchies? |
| Answer» | |
| 22. |
Have you created Hierarchy in OBIEE 11g, how? |
| Answer» | |
| 23. |
How do you create table alias in OBIEE? |
| Answer» | |
| 24. |
What is the use of table alias in OBIEE 11g? |
| Answer» | |
| 25. |
How will you enable or disable caching in the system level and table level? |
| Answer» | |
| 26. |
What are the different query logging levels? |
| Answer» | |
| 27. |
What is Query logging? |
| Answer» | |
| 28. |
How do you perform testing of a repository? Where do you perform testing of OBIEE Repositroy? |
| Answer» | |
| 29. |
How do you create Logical tables in BMM layer? |
| Answer» | |
| 30. |
What are the different steps involved in defining Business Layer? |
| Answer» | |
| 31. |
What is the use of OBIEE Business Model and Mapping layer? |
| Answer» | |
| 32. |
What is caching concept and how it is linked with Query Performance? |
| Answer» | |
| 33. |
How will you execute Direct SQL in OBIEE? |
| Answer» | |
| 34. |
How can you sort in Reports in OBIEE 11g? |
| Answer» | |
| 35. |
Can we use Physical Join in BMM layer? |
| Answer» | |
| 36. |
What is a Physical Join in OBIEE Repository? |
| Answer» | |
| 37. |
What is the use of Oracle BI Repository? |
| Answer» | |
| 38. |
What is the difference between ODBC and OCI? |
| Answer» | |
| 39. |
What is the use of OBIEE Scheduler? |
| Answer» | |
| 40. |
What are the different OBIEE Server components? |
| Answer» | |
| 41. |
What is Oracle Business Intelligence Enterprise Edition (OBIEE)? |
| Answer» | |
| 42. |
What is Slowly Changing Dimension SCD? Can you give one example? |
| Answer» | |
| 43. |
What do you understand by Granularity in a table? |
| Answer» | |
| 44. |
What is difference between star and Snow flakes schema? |
| Answer» | |
| 45. |
What are common aggregate functions? Why do we use aggregate tables in DW? |
| Answer» | |
| 46. |
What do you understand by Additive, semi additive and non-additive measures? |
| Answer» | |
| 47. |
What is difference between OLAP and OLTP? |
| Answer» | |
| 48. |
What is data mart? |
| Answer» | |
| 49. |
What are the different types of Data Warehouse system? |
| Answer» | |
| 50. |
Why a Data Warehouse is Separate from Operational Databases (Transaction Systems)? |
| Answer» | |