🧪 OBIEE 12C MCQ Quiz Hub

OBIEE 12C Mcq Question Set 2

Choose a topic to test your knowledge and improve your OBIEE 12C skills

1. Which of them is/are not Time Series Function?




2. What cannot be done in presentation layer of Repository?




3. We can set Bridge table from




4. For moving your shared dashboard and reports from dev to QA or Production you should:




5. You can apply restriction/ filtration to data in metadata repository in:




6. Which of these is not Hierarchy type?




7. Repository can be uploaded/ updated from?




8. You can start all BI services from fusion middleware from:




9. A lookup transformation is used to look up data in




10. Which one support heterogeneous join?




11. Which output file is not created during session running?




12. Which is both connected and unconnected?




13. Can we generate alpha-numeric value in sequence generator?




14. What is meaning of tracing level?




15. Which one contains input and output transformations?




16. Which dimension is collection of random transactional codes, flags and/or text attributes?




17. Which one is not a target Option for file on the Servers?




18. Which one is not a designer tool creating transformations?




19. What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?




20. What is the default source option for update strategy?




21. What is default join of joiner?




22. What is the default join of Source Qualifier?




23. What are the types of groups in Router transformation?




24. Dimension tables are denormalized in nature ? True or False.




25. How can we load time dimension?




26. Which are the load types in Informatica session?




27. Which load type we should use in case of less amount of data and recover session?




28. What is a mapplet?




29. Which one is not an option in update strategy?




30. Which transformation acts like CASE.. WHEN in Sql?




31. What will happen if informatica server doesn't find session parameter and variable?




32. If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?




33. Can we run multiple execution plan at the same time in DAC?




34. What are the components of DAC




35. Can DAC send an email just in case of any failures?




36. What kind of DAC Repository Objects Held in Source System Containers?




37. When you open a sales.rpd file in the BI Server repository directory, it displays a message “The repository sales.rpd can only be opened as Read-Only. Do you want to open it ?”. What is the correct statement ?




38. What do you use to Model a schema where the dimension table and the fact table have a many to many relationship ?




39. Which layer within the Oracle BI Repository provides customized, role based views to users who build analyses and other client applications ?




40. What is the name of the object that is used to initialize dynamic repository variable and system session variables for OBIEE Sessions ?




41. You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?




42. Which is not valid type of set operation for combine with similar request?




43. How can you show updated changes made to online rpd, without restarting BI Services?




44. If you want to limit / restrict data based on some dimension attribute, you should:




45. Bins created in function are similar to:




46. .............. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.




47. The data is stored, retrieved and updated in........




48. An ......... system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.




49. Which of the following is not a kind of data warehouse application?




50. In ODI, references can be represented by