Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 12 March 2017

TOP 135 OBIEE INTERVIEW QUESTIONS


By on 03:57:00


During the interview be as cool as possible. Don’t think that is the end.

If you do not click this interview don’t think that’s the end. Be confident while answering the questions. At the same time do not show attitude. Behave as simple as you behave with your friend but your physical appearance should be Formal.

Formal dress, do not make faces, do not shake leg and chair. Sit normal and comfortably but don’t push back the chairs and all.



While starting the Interview Interviewer may ask you

So how are you doing in OBIEE 12C?

Ans: I am good thanks how are you doing in OBIEE 12C?



If the Interviewer did not introduce himself ask him.

I am Sorry I did not get your name in OBIEE 12C?

Interview Question are below prepare for each of them with examples



Q1. Tell me about you and your technical expertise.

Ans: your personal details, with studies job experience and highlighting the projects and your technical skills



Q2. Which versions of OBI/ Siebel Analytics you have worked in in OBIEE 12C?



Q3.Have you worked in Informatica in OBIEE 12C? Which version



Q4. Explain me about your recent Project in OBIEE 12C?

Ans: Explain the Domain of the Project, Company from which you have worked in that project, who is the Client,

Technologies used in this application like OS, Database, OBI, Source Application (Mention as Siebel CRM)



Q5. Have you worked on OBIEE 12C or OBIA in OBIEE 12C?

Ans: OBIA



Q6.What is OBIA in OBIEE 12C?



Q7.What is OBAW in OBIEE 12C?



Q8.What is the Components of OBIEE 12C and OBIA in OBIEE 12C?



Q9.What is the Difference in OBIEE 12C and OBIA in OBIEE 12C?



Q10. Explain the Architecture of OBIA in OBIEE 12C?



Q11. Explain the architecture of OBIEE 12C in OBIEE 12C?



Q12. What have you done in RPD in OBIEE 12C?



Q13. What have you done in Reports what kind of reports / views you have worked in



Q14. Explain about one of the complex situation you have faced in your project and how did you solve that. (While answering Provide Example)



Q15. What is Connection Pool in OBIEE 12C?(While answering Provide Example)



Q16. What do you mean by Shared Log On option in the Connection Pool in OBIEE 12C?(While answering Provide Example)



Q17. How do you create a DSN in OBIEE 12C?



Q18. RPD UserID and Password and Connection Pool user ID Password are usually same or different in OBIEE 12C? Why in OBIEE 12C? (While answering Provide Example)



Q19. What are the Physical Layer Objects in OBIEE 12C?



Q20. Why do you need to create an Alias in OBIEE 12C? (While answering Provide Example)



Q30. How do you create a view in the Physical Layer of RPD in OBIEE 12C?(While answering Provide Example)



Q31. How many Layers are there in the RPD in OBIEE 12C?



Q32. What is the Use of BMM Layer in OBIEE 12C? (While answering Provide Example)



Q33. What is the Use of RPD in OBIEE 12C? (While answering Provide Example)



Q34. What is the use of Presentation Catalogue in OBIEE 12C? (While answering Provide Example)



Q35. RPD is Holds Data or Metadata in OBIEE 12C?



Q36. What is the use of Config.INI File (While answering Provide Example in OBIEE 12C?)



Q37. Where is this file located in OBIEE 12C? (While answering Provide Example)



Q38. Where is the Presentation Catalogue located (While answering Provide Example in OBIEE 12C?)



Q39. How do you enable Cache (While answering Provide Example in OBIEE 12C?)



Q40. What are the other properties that you can set in the Config File (While answering Provide Example)



Q41. Where is Instance Config.xml located and what is the use of this File(While answering Provide Example)



Q42. What is Cache Persistence in OBIEE 12C? Where do you set that in OBIEE 12C? (While answering Provide Example)



Q43. How do you make a table "Cacheable" (While answering Provide Example in OBIEE 12C?)



Q44. Suppose In the Config file I have enabled the Cache still cache is Not generating what could be the possible reason in OBIEE 12C?(While answering Provide Example)



Q45. Based on What criteria or situation a report / query will hit the cache in OBIEE 12C? (While answering Provide Example)



Q46. What do you understand by Cache in OBIEE 12C? (While answering Provide Example)



Q47. What is a Fact Table in OBIEE 12C? (While answering Provide Example)



Q48. What is a dimension table in OBIEE 12C? (While answering Provide Example)



Q49. What is Measure in OBIEE 12C? (While answering Provide Example)



Q50. What is Attribute in OBIEE 12C? (While answering Provide Example)



Q51. What is star schema in OBIEE 12C? (While answering Provide Example)



Q52. What is snowflake Schema in OBIEE 12C? (While answering Provide Example)



Q53. What are the Difference BW OLTP and OLAP in OBIEE 12C? (While answering Provide Example)



Q54. What is Normalized and what is De-normalized in OBIEE 12C? (While answering Provide Example)



Q55. Why the Fact is on the many side and Dimension is at the One Side of a star schema (While answering Provide Example)



Q56. How many LTS can a logical table have in OBIEE 12C? (While answering Provide Example)



Q57. How many Physical Sources a LTS can have in OBIEE 12C? (While answering Provide Example)



Q58. In which scenario you will have more than one logical table source under one logical table in OBIEE 12C? (While answering Provide Example)



Q59. Under which scenario you will have one LTS and More than one Physical Sources inside that in OBIEE 12C? (While answering Provide Example)



Q60. Why do we need to create a complex/logical join in the BMM layer in OBIEE 12C? (While answering Provide Example)



Q61. What is the difference b/w Logical join and Physical Join in OBIEE 12C?(While answering Provide Example)



Q62. One Logical Column can be mapped to how many Physical Columns in OBIEE 12C? (While answering Provide Example)



Q63. One Logical Column can be mapped to how many logical columns in OBIEE 12C? (While answering Provide Example)



Q64. If you create a Logical column based on an existing logical Column, and a similar column based on two physical columns what would be the difference in OBIEE 12C? (While answering Provide Example)



Q65. How do you create a calculated measure in OBIEE 12C? (While answering Provide Example)



Q66. How do you create Dimension Hierarchy in OBIEE 12C? Tell all the steps(While answering Provide Example)



Q67. Why Dim Hierarchy is required in OBIEE 12C? (While answering Provide Example)



Q68. What do you understand about content level of a Fact Table in OBIEE 12C? (While answering Provide Example)




Q69. What do you understand about Granularity of a fact and Dimension table in OBIEE 12C? (While answering Provide Example)



Q70. What is the Significance of providing the content specification in the Fact Table in OBIEE 12C? (While answering Provide Example)



Q71. How do you implement Aggregate Fact Table in OBIEE 12C? (While answering Provide Example) provide all the steps



Q72. Why do we need to use Aggregate table in OBIEE 12C? (While answering Provide Example)



Q73. While implementing aggregate table how many LTS will be there in the logical table in OBIEE 12C? (While answering Provide Example)



Q74. One presentation catalogue can be mapped to how many Business Model in OBIEE 12C? (While answering Provide Example)



Q75. One How many Presentation catalogue can be mapped to one Business Model.(While answering Provide Example)



Q76. How many Types of variables are present in OBIEE 12C? (While answering Provide Example)



Q77. What is the use of Each Type of Variable in OBIEE 12C? (While answering Provide Example)



Q78. What is a Initialization Block in OBIEE 12C? (While answering Provide Example)



Q79. What is a Row Wise Initialization block in OBIEE 12C? (While answering Provide Example)



Q80. What is a Level Based Measure in OBIEE 12C? (While answering Provide Example)



Q81. What is the use of a Level Based Measure in OBIEE 12C? (While answering Provide Example)



Q82. How do you create Level Based Measure in OBIEE 12C? (While answering Provide Example)



Q83. I want to create the Following Measure Explain how you will do that.

# of SR closed in last 14 Days. (While answering Provide Example)



Q84. Want to create a measure.

# Of SR Closed Till Date (While answering Provide Example)



Q85. What is the Time Series Function in OBIEE 12C? How to use Time Series Function. (While answering Provide Example)



Q86. How to create following measure in OBIEE 12C?

# of SR Closed Monthly / No of SR Closed Total



Q87. What is Fragmentation Content in OBIEE 12C? (While answering Provide Example)



Q88. What is Where Clause Filter in OBIEE 12C? Where do you apply such filter in OBIEE 12C? Why do you apply such filter in OBIEE 12C? (While answering Provide Example)



Q89. What is Authentication in OBIEE 12C? What is Authorization in OBIEE 12C? (While answering Provide Example)



Q90. How many type of Authentication are present in OBIEE 12C? (While answering Provide Example)



Q91. What do you mean by Database authentication in OBIEE 12C? (While answering Provide Example)



Q92. What do you mean by External Table authentication in OBIEE 12C? (While answering Provide Example)



Q93. How do you authenticate the users using the variables in OBIEE 12C? What kind of variable you use for this purpose (While answering Provide Example)



Q94. What is the Difference between Non system Session Variable and Dynamic Repository Variable in OBIEE 12C?(While answering Provide Example)



Q95. How do you provide access to different Subject Areas in OBIEE 12C? (While answering Provide Example)



Q96. Can a Group be member of another Group in OBIEE 12C? (While answering Provide Example)



Q97. Suppose a User U1 is member of a Group1. Group1 has access to Subject Area A1. Group1 Does not have access to Subject Area A2, Group1 is member of Group2. Group2 has no Access for Subject Area A2 , but has Access for Subject Area Sa3.

User U1 will have access to which subject Areas in OBIEE 12C? Question from Group Inheritance (While answering Provide Example)



Q98. Want to replace the Null Values as 0 for the Measure Sales Value in OBIEE 12C? How would you do that in OBIEE 12C?(While answering Provide Example)



Q99.What is the difference between Pivot and Tabular report in OBIEE 12C?(While answering Provide Example)



Q100. Why do we need exclude column option in Pivot report in OBIEE 12C? (While answering Provide Example)



Q101. What is section in a pivot table report in OBIEE 12C? (While answering Provide Example)



Q.102 what is Pages in a pivot table report in OBIEE 12C? (While answering Provide Example)



Q103. What is calculated item in a pivot table report (While answering Provide Example in OBIEE 12C?)



Q104. What is conditional formatting (While answering Provide Example)



Q105. I want to compare if actual is greater than the target then we need to highlight the sales rep column how to do this (While answering Provide Example)



Q106. What do you mean by Scope of a Dashboard prompt (While answering Provide Example in OBIEE 12C?)



Q 107. What is Dashboard prompt how to create dashboard prompt (While answering Provide Example)



Q108. Difference between Column selector and View Selector (While answering Provide Example)



Q109. What do you understand by Report Defaults in Dashboard prompt (While answering Provide Example in OBIEE 12C?)



Q110. What is the difference between Dashboard prompt and Global Filter (While answering Provide Example in OBIEE 12C?)



Q111. What is the Difference between dashboard Prompt and Report Prompt (While answering Provide Example)



Q112. How many Type of Graphs are supported in OBI (While answering Provide Example)



Q113. Can we navigate from graph how in OBIEE 12C? (While answering Provide Example)



Q114. How do you navigate from report in OBIEE 12C? (While answering Provide Example)



Q115. I have a parent report with Region and sales. Once i click on a particular Region Value it should drill down to other report with Region and Pending order, for that particular region I clicked on. How to achieve this in OBIEE 12C? (While answering Provide Example)



Q116. What is the difference in Report prompt and dashboard prompt in OBIEE 12C? (While answering Provide Example)



Q117. What is guided navigation (While answering Provide Example in OBIEE 12C?)



Q118. How to attach document in the Dashboard (While answering Provide Example)



Q119. How to Create Combined Request (While answering Provide Example)



Q120. How to use Filter based on another request (While answering Provide Example)



Q121. What is narrative view in OBIEE 12C?




Q122. I want to remove the download to excel option in the dashboard Reports - how (While answering Provide Example)



Edit Dashboard -> select Property of Report -> Select Report link -> uncheck the download option.



Q123. How to create dashboard in OBIEE 12C?



Settings -> Administration -> Manage Interactive Dashboard -> Create Dashboard -> Give the dashboard name and builder to create.



Q124. How to give access to the different dashboards to different groups (While answering Provide Example).



Settings -> Administration -> Manage Interactive Dashboard -> Select Lock Symbol for the specific Dashboard and give access to the users.



Q125. How to deny Permission to use answers to a particular group. (While answering Provide Example)



Settings -> Administration -> Managed Privileges -> Access -> Access to Answers



Q126. What are the major changes in architecture for OBIEE 12C?

Q127) What are the common concepts of multitenant database in OBIEE 12C?

Q128) Methods to create Multitenant Database

Q129) How to convert a normal database to Container enabled database in OBIEE 12C?

Q130) How to create a new PDB database in OBIEE 12C?

Q131)How to distinguish you are in CDB or PDB in OBIEE 12C?

Q132). How to connect to PDB from a CDB in OBIEE 12C?

Q133) How about the datafiles system, sysaux , undo, redo etc , does they create when you create PDB in OBIEE 12C?

Q134) As you said, if SGA and background process are shared, is there any performance impact,

Q135) How does the data dictionary works to manage multiple database, for example if I used PDB1 to select a query from emp.

Q136) How about creating a user in OBIEE 12c in OBIEE 12C?

0 comments:

Post a Comment

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)