OBIEE Interview Questions
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
New questions will be added regularly so keep Visiting the blog for updates.
OBIEE Interview Questions And Answers
I.Introduction:
1.What is the end to end life cycle of OBIEE?
2.what are the type of obiee 11g installations and port configurations.
3.what are the obiee 11g components and types.
4.what are the types of tables and columns in obiee.
5.what is schema and types scheme in obiee.
6.what is obiee history and latest versions.
7.Differece between obiee 10g and 11g.
8.what is meant by conformed dimensions.
9.Difference between snow flake and star schemas.
10.What is surrogate key?
11.What is mixed schema?
12.Which OBIEE Versions did you worked on in your projects?
Keep Visiting the blog Updates!
II.Practionser Level:BI Admin Tool(RPD)
A.Introduction:
1.what is use of BI admin tool.
2.what do u mean by metadata and rpd.
3.what are the three layers in rpd.
4.What did a rpd stores and what is it size general and in your Project.
5.What are modes of using RPD?
B.Physcial Layer:
1.what are objects of physical layer.
2.Is OBIEE supports multiple databases?
3.Can we access all the tables of a database using one connection pool.
4.what are the connection types to import metadata in rpd.
5.can we import pk,fk,views into rpd.
6.what are the steps of importing metadata from DWH to rpd.
7.what are the joins in obiee 11g.
8.Is outer join is possible in physical layer?
9.How self join is done in physical layer.
10.what are the joins not supported by obiee 11g.
11.can we import joins from DB to physical layer.
12.How we synchronize rpd and db.
13.How can we remove unused objects from physical layer.
14.How types of analytics are there and which analyticsis used in your project.
15.Give some table and column names from Datawarehouse of your project.
16.What is a connection pool and how many are there is your project.
17.Can we access all the tables in the database using one connection pool?
18.What is your source system and give some table and column names of AP,AR,GL,PO,PA etc.,
19.What are the types of tables present in Datawarehouse.
20.How to check what version of joins or any fucntionality is supported by your Datawarehouse.
21.What is OCI and ODBC?
C.BMM/logical Layer:
1.For what BMM(Business Model and Mapping) layer is required.
2.what are objects of BMM layer.
3.How many Business models or data mart or subject areas can be created in BMM layer.
4.why we have do logical join and what is driving table.
5.what is cardinality.
6.how can we rename all columns at a time in BMM layer.
7.How can we identify a column is measure column or what is the condition for it.
8.Can a Business Model be mapped to multiple DB's in physical layer.
9.Can a logical table be mapped to multiple LTS in physical layer.
10.Can a LTS be mapped to multiple physical tables in physical layer.
11.Can a logical column be mapped to multiple physical columns in physical layer.
12.What is complex join?
13.What is dummy fact table?
14.If we want to use only one table for reports.How it is joined in Logical Layer?
D.Presentation Layer:
1.which layer is visible to the user or developer
2.what are objects of Presentation layer.
3.How many Business Models can a subject area have at time?
4.Can two or more subject areas have same Business Model?
5.on what basis subject areas are created?
6.Can we create nested folders in Presentation Layer.
E.Testing RPD
1.What will be checked when Consistency Check Manager is invoked or ran.
2.what are the difference between Online and offline mode in RPD.
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
F.OFMW EM
1.what are the uses of EM.
2.How many ways are there to start and stop BI servers.
Keep Visiting the blog Updates!
G.Files:Logs,Paths
1.what is the path for storing rpd.
2.what are the files in which rpd details stores.
3.what are the log levels present in obiee 11g.
4.what is the default log level and what is it in production and test.
5.How is the results of a report stored in obiee system.
H.OBIEE 11g Architecture
1.How many tiers are in OBIEE 11g Architecture?
2.What are the main servers in obiee.what is start and stopping sequence of servers.
3.what is node manager and opmnctl.
4.what are configuration and log files present in obiee 11g.
5.which server maintains data security in obiee 11g.
6.we cannot open Analytics application,if which server is down.
7.What is the use of BI java host server in obiee.
I.Adding Multiple Sources
1.what are the conditions to add physical tables to LTS or LT.
2.How to convert a snow flake scheme to star.
3.What is granularity or content logical level.
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
J.Calculations
1.In general calculations can be done at what levels.
2.In OBIEE BMM Layer we can do calculations in how ways and how?
3.When and why we use calculation wizard.
4.We can access expression wizard from?
5.What is INDEXCOL function?
6.How aggregation is referred in logical and physical calculations.
7.What is best practice for calculations and why?
8.What are the aggregate time functions in expression builder?
9.What is CAST Function used for?
10.What are the Display functions and uses?
11.What are the Evaluate/database functions and uses?
12.What are the Time series functions and uses?
K.Creating Dimensional Hierarchies
1.What are the types of Hierarchies?
2.What do u mean by level based Hierarchies?
3.In level based Hierarchies, one column can be mapped with how many levels ?
4.What do u mean by Content Logical level or Granularity.
5.How many level are there in level based Hierarchies.
6.Why we have to use Hierarchies?
7.What is Drill Down,Drill Up,Drill across.
8.What is Chronological Keys?why it is used.
9.What is use of 'Number of Elements at this Level' option.
L.Level Based Measures (LBM)
1.Can we use nested aggregate functions in RPD.
2.What is LBM and what is its use?
New questions will be added regularly so keep Visiting the blog for updates.
III.Learner Level:
A.Analytics
1.What is analytics?
2.To access analytics what servers should be up?
3.What is URL format and port for Analytics.
B.Creating Web Catalog and Reports
1.What is Web Catalog?What is its path?
2.Which server controls Catalog and what is it configuration and log files.
3.What are the folders present in the Catalog and for what purpose.
4.What are the Catalog folders available to users in Analytics.
5.How filters and dashboards are saved in Catalog.
6.What is catalog Manager and uses?
7.Can we get all the reports in excel format.How?
C.Working with Analysis
1.What are the tab present in Analysis.
2.What are the properties of any column in analytics.
3.What are the column properties of a column in analytics.
4.How to hide unnecessary columns in reports.
5.How sorting is done at RPD level.
6.How to avoid duplicates or repeating values in reports.
7.Can we partially format column heading.
8.How can we remove decimals and highlight the negative values?
9.How to highlight data based on conditions?
10.How calculations are done at report level.
11.What are global variables.
12.What is Filter function.
13.What are Bins and uses of it.
14.What is a subject area?
D.Working with Filters
1.How many ways can we develop filters?
2.What is Advanced SQL Filter?
3.What is a prompt?
4.what is presentation variable and its syntax?
5.What is a global filter?
E.Advanced Features of Analysis
1.can we take columns from two subject area and create reports.
2.Can we combine two requests from different subject areas or same?
3.What is Direct database request(DDR)?How to get access?
F.Building Views
1.What is a view and what are default views.
2.How many types of views are there and where they are integrated.
3.What is the difference between Table and Pivot Table view.
4.Why we use graph views?
5.What are gauge and funnel views?
6.What is a filters view.
7.What is Selection Steps.
8.What did the column selector,view selector,Narrative,Ticker,Static text and Legend views do?
9.what are the use of analysis properties.
G.Dashboards
1.What is a Dashboard and how many types are there?
2.What is the use of Smart Rename.
H.Dashboard prompts
1.What are the Dashboard Prompt and how many types are there?
2.How data is returned by a report when a dashboard prompt is used(link).
3.What is a protected filter?
4.What is a server variable?
5.What is a variable prompt?
6.What is a currency prompt?How to configure it and where?
7.What is a presentation variable?
8.What is a request variable?
I.Dashboard objects
1.What are the Dashboard objects?
2.What are the main Dashboard objects?
3.using same dashboard can two users see different reports?how?
4.can we navigate from dashboard to other.How?
5.How can we add comments in dashboards.
6.What is the use of Folder dashboard object?
Click Here!OBIEE Interview Questions And Answers for Experienced
Click Above link new questions are added.
J.Oracle BI Delivers
1.What is the use of Oracle BI Delivers?
2.what is Agent or Job or Schedules or IBOT?
3.Which server maintain Oracle BI Delivers and where it is configured.
4.Where did scheduler details are stored?
5.what is delivery device and delivery profile?what are the locations it is found?
6.How many ways a Agent can be created?
7.How is alerts displayed in dashboards?
8.What is the use of Job Manager?
IV.Specialist level:
A.Aggregate Tables
1.Why we have to go for Aggregate Tables?
2.What is granularity?
B.Partitions and Fragments
1.What is Partitioning and Partitioning types and uses?
2.What is Fragmentation?
3.What is Value based partitioning?
4.What is Fact Based Partitioning?
5.What is Level Based Partitioning?
C.Variables
1.What are Variables and its types?
2.Where we use repository and session variables?
3.Where we use Presentation and request variables?
4.What are the types of repository variables and there syntax.
5.Difference between static and dynamic repository variables?
6.What is a Initialization Block?
7.If the repository variable value is changed in online mode.what happen to result of the result?
8.What are the types of session variables and there syntax.
9.Give some examples of system variables.
10.Difference between system and non system session variables?
11.How data level security or Row Level Security is achieved?
12.What is Data filters?
13.What is Object Permissions?
14.What is Query limit?
15.Can we restrict a user for a particular time period?
16.What is LDAP?How is it managed in OBIEE?
17.What are the default users,groups and roles in obiee 11g.
18.How we Synchronize Application Roles between LDAP and RPD.
19.Is it mandatory to create a connection pool for Initialization block?
2o.What is Row Wise Initialization Blocks and its use?
21.Difference between repository and session variables?
22.What is a presentation variable and its syntax.
23.What is a request variable and its syntax.
D.Modeling Time Series Data
1.Are there any analytical function in obiee?
2.What are Time series functions and uses?
3.What is the analytical function used in period rolling function in obiee 11g?
3.What is Chronological key?
4.Can we created skipped and ragged Hierarchies in time dimension?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
E.Configuring Many to Many Relationships
1.What is Bridge table and its use?
2.What is Helper table and its use?
3.Tell me one feature of OBIEE not available in other BI Tools?
4.What are weight factor and Gap physical columns?
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
F.Setting Implicit Fact Column
1.What is Implicit fact coulmn and its use?
2.What is dimension only query?
3.Can we reports only by taking dimensions or facts?
4.On what bases BI server decides a economical source?
G.Security
1.What are the levels of Security available in obiee 11g?
2.How OBIEE security is divided?
3.What is Authentication and Authorization?
4.How Authentication is preformed in obiee 11g?
5.How External table authentication is done in obiee 11g?
6.If we need to pass external table intilization block,what should be done?
7.Can we run Authorization initialization block after Authentication initialization block?How?
8.Where is new users,groups and roles are created?
9.How to get all users,groups and roles in excel format?
10.How user folders are created in catalog for LDAP amd external table user?
11.What are catalog groups and uses?
12.What are the levels of Authorization a user can be assigned?
13.What authorization user can be assigned at RPD level?
14.What is global header?What does it contain.
15.How we give privileges to create analysis,KPI,dashboards etc., to user?
16.What authorization user can be assigned at Presentation Catalog level?
17.What are types of permissions in OBIEE 11g?
18.What is traverse permission means?
19.What is inheritance precedence among users,groups and roles?
20.What is Globally Unique Identifier (GUID)?
21.What is Impersonation in obiee 11g security?
22.How many users can a LDAP stores?
23.How users know what roles they are assigned?
24.What do you mean by Single Sign on (SSO)?
25.Can you bypass obi server security ?if so how?
H.Cache Management
1.In OBIEE how many types of caches are there?
2.What is the order of report execution?
3.How to bypass and clear OBIPS cache.How?
4.How OBI Server cache is handled in OBIEE 11g?
5.Will obi server cache get deleted on server start or restart?
6.What are advantages and disadvantages of caches?
7.What is Cache Management?
8.What is Purging?How types are there?
9.Can we enable caches on few tables only?If yes,How?
10.What is the use of Event Pooling Table (EPT) and mention table name used for it?
11.What is the accurate method for purging caches?
12.What are ODBC functions or How cache is purged programmatically?
13.Where can we use ODBC functions?
14.How can we issue a SQl statement directly to BI server?
15.What is meant by seeding and types and uses?
16.What is Auto seeding?
I.Usage Tracking
1.How is Usage tracking is done?
2.From which table Usage tracking reports are developed?
3.Where did we configure usage tracking parameter?
4.What is the use of system Mbean Browser?
J.Multi User Development Environment (MUDE)
1.can two or more developer work on RPD at time.How?
2.Is MUDE available in online mode?
3.What is project means in RPD or OBIEE?
4.What is Setup required for MUDE?
5.How to use MUDE Environment?
6.What is merging process?
7.Can we trim a RPD?
8.If two users created same column in same logical table with same formula then what will happens in merging process?
9.Can you compare two different RPDs?
10.Can you merge two Different RPDs.
New questions will be added regularly so keep Visiting the blog for updates.
K.Opaque View / Select Table
1.What is Opaque View and what are its uses?
2.What is deploying view?
L.Alias
1.What is Alias?
2.On one table how alias will be created?
3.To create number of alias depends on what?
4.What are the uses of alias?
5.Difference between Alias and Duplicate Table.
V.OBIEE 11G Advanced New Features
A.Parent Child Hierarchies
1.What is Parent Child Hierarchy or value based Hierarchy.
2.When we go for Parent Child Hierarchies?
3.How levels are present in Parent Child Hierarchies?
4.What is memeber key and parent key?
5.What is relationship distance and Leaf node identifier?
B.Unbalanced Hierarchies (Ragged and Skipped)
1.What is Unbalanced Hierarchy?
2.What is skipped Hierarchy and Ragged Hierarchy?
C.Actions Links
1.What are Actions Links and uses?
2.What is the use of Interaction Tab?
3.What are Actions?
D.Master Detail Report
1.What is a Master Detail Report?
2.can we develop a report Using Hierarchy Object?
3.What is a condition?How it is used?
E.Upgrade or Migration
1.How do you Upgrade or Migrate from OBI 10g to OBI 11g?
F.Deployment or Migration
1.What do you means by Deployment?
2.What are the Deployment components in obiee 11g?
3.Can we do partially deployment of catalog and rpd?
4.Recommended mode for catalog deployment?
5.What is purpose of archive option?
6.Can we get all reports in catalog in excel format?How?
7.How to get a document of the repository?
G.KPI (Key Performance Indicator)
1.What are KPI's and uses of it?
2.Can KPI dimensionalized?
3.What is KPI Watch List?
4.What is Score Card?
I.ID Column
1.What is the use of ID Column?
J.ORACLE BI FOR MS OFFICE
1.How to download BI office Plug-in?
Answers will updated soon........Visit again!
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
Click Above link new questions are added.
New questions will be added regularly so keep Visiting the blog for updates.
OBIEE Interview Questions And Answers
I.Introduction:
1.What is the end to end life cycle of OBIEE?
2.what are the type of obiee 11g installations and port configurations.
3.what are the obiee 11g components and types.
4.what are the types of tables and columns in obiee.
5.what is schema and types scheme in obiee.
6.what is obiee history and latest versions.
7.Differece between obiee 10g and 11g.
8.what is meant by conformed dimensions.
9.Difference between snow flake and star schemas.
10.What is surrogate key?
11.What is mixed schema?
12.Which OBIEE Versions did you worked on in your projects?
Keep Visiting the blog Updates!
II.Practionser Level:BI Admin Tool(RPD)
A.Introduction:
1.what is use of BI admin tool.
2.what do u mean by metadata and rpd.
3.what are the three layers in rpd.
4.What did a rpd stores and what is it size general and in your Project.
5.What are modes of using RPD?
B.Physcial Layer:
1.what are objects of physical layer.
2.Is OBIEE supports multiple databases?
3.Can we access all the tables of a database using one connection pool.
4.what are the connection types to import metadata in rpd.
5.can we import pk,fk,views into rpd.
6.what are the steps of importing metadata from DWH to rpd.
7.what are the joins in obiee 11g.
8.Is outer join is possible in physical layer?
9.How self join is done in physical layer.
10.what are the joins not supported by obiee 11g.
11.can we import joins from DB to physical layer.
12.How we synchronize rpd and db.
13.How can we remove unused objects from physical layer.
14.How types of analytics are there and which analyticsis used in your project.
15.Give some table and column names from Datawarehouse of your project.
16.What is a connection pool and how many are there is your project.
17.Can we access all the tables in the database using one connection pool?
18.What is your source system and give some table and column names of AP,AR,GL,PO,PA etc.,
19.What are the types of tables present in Datawarehouse.
20.How to check what version of joins or any fucntionality is supported by your Datawarehouse.
21.What is OCI and ODBC?
C.BMM/logical Layer:
1.For what BMM(Business Model and Mapping) layer is required.
2.what are objects of BMM layer.
3.How many Business models or data mart or subject areas can be created in BMM layer.
4.why we have do logical join and what is driving table.
5.what is cardinality.
6.how can we rename all columns at a time in BMM layer.
7.How can we identify a column is measure column or what is the condition for it.
8.Can a Business Model be mapped to multiple DB's in physical layer.
9.Can a logical table be mapped to multiple LTS in physical layer.
10.Can a LTS be mapped to multiple physical tables in physical layer.
11.Can a logical column be mapped to multiple physical columns in physical layer.
12.What is complex join?
13.What is dummy fact table?
14.If we want to use only one table for reports.How it is joined in Logical Layer?
D.Presentation Layer:
1.which layer is visible to the user or developer
2.what are objects of Presentation layer.
3.How many Business Models can a subject area have at time?
4.Can two or more subject areas have same Business Model?
5.on what basis subject areas are created?
6.Can we create nested folders in Presentation Layer.
E.Testing RPD
1.What will be checked when Consistency Check Manager is invoked or ran.
2.what are the difference between Online and offline mode in RPD.
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
F.OFMW EM
1.what are the uses of EM.
2.How many ways are there to start and stop BI servers.
Keep Visiting the blog Updates!
G.Files:Logs,Paths
1.what is the path for storing rpd.
2.what are the files in which rpd details stores.
3.what are the log levels present in obiee 11g.
4.what is the default log level and what is it in production and test.
5.How is the results of a report stored in obiee system.
H.OBIEE 11g Architecture
1.How many tiers are in OBIEE 11g Architecture?
2.What are the main servers in obiee.what is start and stopping sequence of servers.
3.what is node manager and opmnctl.
4.what are configuration and log files present in obiee 11g.
5.which server maintains data security in obiee 11g.
6.we cannot open Analytics application,if which server is down.
7.What is the use of BI java host server in obiee.
I.Adding Multiple Sources
1.what are the conditions to add physical tables to LTS or LT.
2.How to convert a snow flake scheme to star.
3.What is granularity or content logical level.
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
J.Calculations
1.In general calculations can be done at what levels.
2.In OBIEE BMM Layer we can do calculations in how ways and how?
3.When and why we use calculation wizard.
4.We can access expression wizard from?
5.What is INDEXCOL function?
6.How aggregation is referred in logical and physical calculations.
7.What is best practice for calculations and why?
8.What are the aggregate time functions in expression builder?
9.What is CAST Function used for?
10.What are the Display functions and uses?
11.What are the Evaluate/database functions and uses?
12.What are the Time series functions and uses?
K.Creating Dimensional Hierarchies
1.What are the types of Hierarchies?
2.What do u mean by level based Hierarchies?
3.In level based Hierarchies, one column can be mapped with how many levels ?
4.What do u mean by Content Logical level or Granularity.
5.How many level are there in level based Hierarchies.
6.Why we have to use Hierarchies?
7.What is Drill Down,Drill Up,Drill across.
8.What is Chronological Keys?why it is used.
9.What is use of 'Number of Elements at this Level' option.
L.Level Based Measures (LBM)
1.Can we use nested aggregate functions in RPD.
2.What is LBM and what is its use?
New questions will be added regularly so keep Visiting the blog for updates.
III.Learner Level:
A.Analytics
1.What is analytics?
2.To access analytics what servers should be up?
3.What is URL format and port for Analytics.
B.Creating Web Catalog and Reports
1.What is Web Catalog?What is its path?
2.Which server controls Catalog and what is it configuration and log files.
3.What are the folders present in the Catalog and for what purpose.
4.What are the Catalog folders available to users in Analytics.
5.How filters and dashboards are saved in Catalog.
6.What is catalog Manager and uses?
7.Can we get all the reports in excel format.How?
C.Working with Analysis
1.What are the tab present in Analysis.
2.What are the properties of any column in analytics.
3.What are the column properties of a column in analytics.
4.How to hide unnecessary columns in reports.
5.How sorting is done at RPD level.
6.How to avoid duplicates or repeating values in reports.
7.Can we partially format column heading.
8.How can we remove decimals and highlight the negative values?
9.How to highlight data based on conditions?
10.How calculations are done at report level.
11.What are global variables.
12.What is Filter function.
13.What are Bins and uses of it.
14.What is a subject area?
D.Working with Filters
1.How many ways can we develop filters?
2.What is Advanced SQL Filter?
3.What is a prompt?
4.what is presentation variable and its syntax?
5.What is a global filter?
E.Advanced Features of Analysis
1.can we take columns from two subject area and create reports.
2.Can we combine two requests from different subject areas or same?
3.What is Direct database request(DDR)?How to get access?
F.Building Views
1.What is a view and what are default views.
2.How many types of views are there and where they are integrated.
3.What is the difference between Table and Pivot Table view.
4.Why we use graph views?
5.What are gauge and funnel views?
6.What is a filters view.
7.What is Selection Steps.
8.What did the column selector,view selector,Narrative,Ticker,Static text and Legend views do?
9.what are the use of analysis properties.
G.Dashboards
1.What is a Dashboard and how many types are there?
2.What is the use of Smart Rename.
H.Dashboard prompts
1.What are the Dashboard Prompt and how many types are there?
2.How data is returned by a report when a dashboard prompt is used(link).
3.What is a protected filter?
4.What is a server variable?
5.What is a variable prompt?
6.What is a currency prompt?How to configure it and where?
7.What is a presentation variable?
8.What is a request variable?
I.Dashboard objects
1.What are the Dashboard objects?
2.What are the main Dashboard objects?
3.using same dashboard can two users see different reports?how?
4.can we navigate from dashboard to other.How?
5.How can we add comments in dashboards.
6.What is the use of Folder dashboard object?
Click Here!OBIEE Interview Questions And Answers for Experienced
Click Above link new questions are added.
J.Oracle BI Delivers
1.What is the use of Oracle BI Delivers?
2.what is Agent or Job or Schedules or IBOT?
3.Which server maintain Oracle BI Delivers and where it is configured.
4.Where did scheduler details are stored?
5.what is delivery device and delivery profile?what are the locations it is found?
6.How many ways a Agent can be created?
7.How is alerts displayed in dashboards?
8.What is the use of Job Manager?
IV.Specialist level:
A.Aggregate Tables
1.Why we have to go for Aggregate Tables?
2.What is granularity?
B.Partitions and Fragments
1.What is Partitioning and Partitioning types and uses?
2.What is Fragmentation?
3.What is Value based partitioning?
4.What is Fact Based Partitioning?
5.What is Level Based Partitioning?
C.Variables
1.What are Variables and its types?
2.Where we use repository and session variables?
3.Where we use Presentation and request variables?
4.What are the types of repository variables and there syntax.
5.Difference between static and dynamic repository variables?
6.What is a Initialization Block?
7.If the repository variable value is changed in online mode.what happen to result of the result?
8.What are the types of session variables and there syntax.
9.Give some examples of system variables.
10.Difference between system and non system session variables?
11.How data level security or Row Level Security is achieved?
12.What is Data filters?
13.What is Object Permissions?
14.What is Query limit?
15.Can we restrict a user for a particular time period?
16.What is LDAP?How is it managed in OBIEE?
17.What are the default users,groups and roles in obiee 11g.
18.How we Synchronize Application Roles between LDAP and RPD.
19.Is it mandatory to create a connection pool for Initialization block?
2o.What is Row Wise Initialization Blocks and its use?
21.Difference between repository and session variables?
22.What is a presentation variable and its syntax.
23.What is a request variable and its syntax.
D.Modeling Time Series Data
1.Are there any analytical function in obiee?
2.What are Time series functions and uses?
3.What is the analytical function used in period rolling function in obiee 11g?
3.What is Chronological key?
4.Can we created skipped and ragged Hierarchies in time dimension?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
E.Configuring Many to Many Relationships
1.What is Bridge table and its use?
2.What is Helper table and its use?
3.Tell me one feature of OBIEE not available in other BI Tools?
4.What are weight factor and Gap physical columns?
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
F.Setting Implicit Fact Column
1.What is Implicit fact coulmn and its use?
2.What is dimension only query?
3.Can we reports only by taking dimensions or facts?
4.On what bases BI server decides a economical source?
G.Security
1.What are the levels of Security available in obiee 11g?
2.How OBIEE security is divided?
3.What is Authentication and Authorization?
4.How Authentication is preformed in obiee 11g?
5.How External table authentication is done in obiee 11g?
6.If we need to pass external table intilization block,what should be done?
7.Can we run Authorization initialization block after Authentication initialization block?How?
8.Where is new users,groups and roles are created?
9.How to get all users,groups and roles in excel format?
10.How user folders are created in catalog for LDAP amd external table user?
11.What are catalog groups and uses?
12.What are the levels of Authorization a user can be assigned?
13.What authorization user can be assigned at RPD level?
14.What is global header?What does it contain.
15.How we give privileges to create analysis,KPI,dashboards etc., to user?
16.What authorization user can be assigned at Presentation Catalog level?
17.What are types of permissions in OBIEE 11g?
18.What is traverse permission means?
19.What is inheritance precedence among users,groups and roles?
20.What is Globally Unique Identifier (GUID)?
21.What is Impersonation in obiee 11g security?
22.How many users can a LDAP stores?
23.How users know what roles they are assigned?
24.What do you mean by Single Sign on (SSO)?
25.Can you bypass obi server security ?if so how?
H.Cache Management
1.In OBIEE how many types of caches are there?
2.What is the order of report execution?
3.How to bypass and clear OBIPS cache.How?
4.How OBI Server cache is handled in OBIEE 11g?
5.Will obi server cache get deleted on server start or restart?
6.What are advantages and disadvantages of caches?
7.What is Cache Management?
8.What is Purging?How types are there?
9.Can we enable caches on few tables only?If yes,How?
10.What is the use of Event Pooling Table (EPT) and mention table name used for it?
11.What is the accurate method for purging caches?
12.What are ODBC functions or How cache is purged programmatically?
13.Where can we use ODBC functions?
14.How can we issue a SQl statement directly to BI server?
15.What is meant by seeding and types and uses?
16.What is Auto seeding?
I.Usage Tracking
1.How is Usage tracking is done?
2.From which table Usage tracking reports are developed?
3.Where did we configure usage tracking parameter?
4.What is the use of system Mbean Browser?
J.Multi User Development Environment (MUDE)
1.can two or more developer work on RPD at time.How?
2.Is MUDE available in online mode?
3.What is project means in RPD or OBIEE?
4.What is Setup required for MUDE?
5.How to use MUDE Environment?
6.What is merging process?
7.Can we trim a RPD?
8.If two users created same column in same logical table with same formula then what will happens in merging process?
9.Can you compare two different RPDs?
10.Can you merge two Different RPDs.
New questions will be added regularly so keep Visiting the blog for updates.
K.Opaque View / Select Table
1.What is Opaque View and what are its uses?
2.What is deploying view?
L.Alias
1.What is Alias?
2.On one table how alias will be created?
3.To create number of alias depends on what?
4.What are the uses of alias?
5.Difference between Alias and Duplicate Table.
V.OBIEE 11G Advanced New Features
A.Parent Child Hierarchies
1.What is Parent Child Hierarchy or value based Hierarchy.
2.When we go for Parent Child Hierarchies?
3.How levels are present in Parent Child Hierarchies?
4.What is memeber key and parent key?
5.What is relationship distance and Leaf node identifier?
B.Unbalanced Hierarchies (Ragged and Skipped)
1.What is Unbalanced Hierarchy?
2.What is skipped Hierarchy and Ragged Hierarchy?
C.Actions Links
1.What are Actions Links and uses?
2.What is the use of Interaction Tab?
3.What are Actions?
D.Master Detail Report
1.What is a Master Detail Report?
2.can we develop a report Using Hierarchy Object?
3.What is a condition?How it is used?
E.Upgrade or Migration
1.How do you Upgrade or Migrate from OBI 10g to OBI 11g?
F.Deployment or Migration
1.What do you means by Deployment?
2.What are the Deployment components in obiee 11g?
3.Can we do partially deployment of catalog and rpd?
4.Recommended mode for catalog deployment?
5.What is purpose of archive option?
6.Can we get all reports in catalog in excel format?How?
7.How to get a document of the repository?
G.KPI (Key Performance Indicator)
1.What are KPI's and uses of it?
2.Can KPI dimensionalized?
3.What is KPI Watch List?
4.What is Score Card?
I.ID Column
1.What is the use of ID Column?
J.ORACLE BI FOR MS OFFICE
1.How to download BI office Plug-in?
Answers will updated soon........Visit again!
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
These questions are asked
in the interviews of
ORACLE INDIA Hyderabad
GEN PACT Hyderabad
GEN PACTGURGAON (NEW
DELHI)
ACCION LABS (MALAYSIA)
AFUAIT (BANGALORE AND
QATAR)
TCS AHAMADABAD (GUJARAT)
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
OBIEE Interview Questions And Answers for Experienced
OBIEE Interview Questions And Answers for Experienced Click Here !
Click above link to get OBIEE 11g Interview Questions 2016.
Upcoming Posts!
OBIEE Interview Questions And Answers for Experienced 2016 Click Here!
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
New questions are added.
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
Click above link to get OBIEE 11g Interview Questions 2016.
Upcoming Posts!
OBIEE Interview Questions And Answers for Experienced 2016 Click Here!
These questions are asked
in the interviews of
ORACLE INDIA Hyderabad
GEN PACT Hyderabad
GEN PACTGURGAON (NEW
DELHI)
ACCION LABS (MALAYSIA)
AFUAIT (BANGALORE AND
QATAR)
TCS AHAMADABAD (GUJARAT)
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
New questions are added.
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
OBIEE Interview Questions And Answers
OBIEE Interview Questions And Answers Click Here!
Click above link to get OBIEE 11g Interview Questions 2016.
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers.
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
SQL interview Questions
SQL Practice Questions
SQL interview Questions also include in
this questions.
This Question seems to be simple in the
beginning but toughness increase gradually, please try all the levels. Solutions for questions are at the end or Click Here!
Moreover, to practice this questions use
Oracle Database 11g with Sample Schemes which consists of tables like
EMPLOYEES, DEPARTMENT,JOB_GRADES etc., and will facing a interview use Oracle
Apps Tables like AP_INVOICES_ALL,PO_HEADERS_ALL,AP_CHECKS_ALL etc.,instead of
this tables for experienced candidates.
Tools Used : SQL*Plus
More Interviews questions will updated
regularly, so visit for updates.
Practice 1 : Questions on SELECT statement
1. The following SELECT statement executes
successfully or not?
SELECT last_name, job_id, salary AS Sal
FROM employees;
2. The following SELECT statement executes
successfully or not?
SELECT *
FROM job_grades;
3. There are four coding errors in this
statement. Can you identify them?
SELECT employee_id, last_name
sal x 12 ANNUAL SALARY
FROM employees;
4. Show the structure of the DEPARTMENTS
table. Select all data from the DEPARTMENTS table.
5. Show the structure of the EMPLOYEES
table. Create a query to display the last name, job code,
hire date, and employee number for each
employee, with employee number appearing first.
Provide an alias STARTDATE for the
HIRE_DATE column. Save your SQL statement to a file
named lab1_7.sql.
6. Create a query to display unique job
codes from the EMPLOYEES table.
If you have time, complete the following
exercises:
7. Copy the statement from lab1_7.sql into
the iSQL*Plus Edit window. Name the column
headings Emp #, Employee, Job, and Hire
Date, respectively. Run your query again.
8. Display the last name concatenated with
the job ID, separated by a comma and space, and name
the column Employee and Title.
If you want an extra challenge, complete
the following exercise:
9. Create a query to display all the data
from the EMPLOYEES table. Separate each column by a
* * * * * * * * * * * *
Practice 2 : Restricting
and Sorting Data
1. Create a query to display the last name
and salary of employees earning more than $12,000.
Place your SQL statement in a text file
named lab2_1.sql. Run your query.
2. Create a query to display the employee last
name and department number for employee number
176.
3. Modify lab2_1.sql to display the last
name and salary for all employees whose salary is not
in the range of $5,000 and $12,000. Place
your SQL statement in a text file named
lab2_3.sql.
4. Display the employee last name, job ID,
and start date of employees hired between February 20,
1998, and May 1, 1998. Order the query in
ascending order by start date.
5. Display the last name and department
number of all employees in departments 20 and 50 in
alphabetical order by name.
6. Modify lab2_3.sql to list the last name
and salary of employees who earn between $5,000
and $12,000, and are in department 20 or
50. Label the columns Employee and Monthly
Salary, respectively. Resave lab2_3.sql as
lab2_6.sql. Run the statement in
lab2_6.sql.
7. Display the last name and hire date of
every employee who was hired in 1994.
8. Display the last name and job title of
all employees who do not have a manager.
9. Display the last name, salary, and
commission for all employees who earn commissions. Sort
data in descending order of salary and
commissions.
If you have time, complete the following
exercises.
10. Display the last names of all employees
where the third letter of the name is an a.
11. Display the last name of all employees
who have an a and an e in their last name.
If you want an extra challenge, complete
the following exercises:
12. Display the last name, job, and salary
for all employees whose job is sales representative or
stock clerk and whose salary is not equal
to $2,500, $3,500, or $7,000.
13. Modify lab2_6.sql to display the last
name, salary, and commission for all employees
whose commission amount is 20%. Resave
lab2_6.sql as lab2_13.sql. Rerun the
statement in lab2_13.sql.
Solutions for questions Click Here!
* * * * * * * * * * * *
Solutions for questions Click Here!
* * * * * * * * * * * *
Practice 3 : Single-Row Functions
1. Write a query to display the current date. Label the
column Date.
2. For each employee, display the employee number,
last_name, salary, and salary increased by 15%
and expressed as a whole number. Label the column New
Salary. Place your SQL statement in
a text file named lab3_2.sql.
3. Run your query in the file lab3_2.sql.
4. Modify your query lab3_2.sql to add a column that
subtracts the old salary from
the new salary. Label the column Increase. Save the contents
of the file as lab3_4.sql.
Run the revised query.
5. Write a query that displays the employee’s last names
with the first letter capitalized and all other
letters lowercase and the length of the name for all
employees whose name starts with J, A, or M.
Give each column an appropriate label. Sort the results by
the employees’ last names.
6. For each employee, display the employee’s last name, and
calculate the number of months
between today and the date the employee was hired. Label the
column MONTHS_WORKED. Order
your results by the number of months employed. Round the
number of months up to the closest
whole number.
Note: Your results will differ.
7. Write a query that produces the following for each
employee:
<employee last name> earns <salary> monthly but
wants <3 times
salary>. Label the column Dream Salaries.
If you have time, complete the following exercises:
8. Create a query to display the last name and salary for
all employees. Format the salary to be 15
characters long, left-padded with $. Label the column
SALARY.
9. Display each employee’s last name, hire date, and salary
review date, which is the first Monday
after six months of service. Label the column REVIEW. Format
the dates to appear in the format
similar to “Monday, the Thirty-First of July, 2000.”
10. Display the last name, hire date, and day of the week on
which the employee started. Label
the column DAY. Order the results by the day of the week
starting with Monday.
If you want an extra challenge, complete the following
exercises:
11. Create a query that displays the employees’ last names
and commission amounts. If an
employee does not earn commission, put “No Commission.”
Label the column COMM.
12. Create a query that displays the employees’ last names
and indicates the amounts of their
annual salaries with asterisks. Each asterisk signifies a
thousand dollars. Sort the data in
descending order of salary. Label the column
EMPLOYEES_AND_THEIR_SALARIES.
13. Using the DECODE function, write a query that displays
the grade of all employees based on the
value of the column JOB_ID, as per the following data:
JOB GRADE
AD_PRES A
ST_MAN B
IT_PROG C
SA_REP D
ST_CLERK E
None of the above 0
14. Rewrite the statement in the preceding question using
the CASE syntax.
* * * *
* * * * * *
* * * *
Practice 4 : Displaying Data
from Multiple Tables
1. Write a query to display the last name, department
number, and department name for all
employees.
2. Create a unique listing of all jobs that are in
department 80. Include the location of the
department in the output.
3. Write a query to display the employee last name,
department name, location ID, and city of all
employees who earn a commission.
4. Display the employee last name and department name for
all employees who have an a
(lowercase) in their last names. Place your SQL statement in
a text file named lab4_4.sql.
5. Write a query to display the last name, job, department
number, and department name for all
employees who work in Toronto.
6. Display the employee last name and employee number along
with their manager’s last name and
manager number. Label the columns Employee, Emp#, Manager,
and Mgr#, respectively.
Place your SQL statement in a text file named lab4_6.sql.
7. Modify lab4_6.sql to display all employees including
King, who has no manager.
Place your SQL statement in a text file named lab4_7.sql.
Run the query in lab4_7.sql
If you have time, complete the following exercises.
8. Create a query that displays employee last names,
department numbers, and all the
employees who work in the same department as a given
employee. Give each column an
appropriate label.
9. Show the structure of the JOB_GRADES table. Create a
query that displays the name, job,
department name, salary, and grade for all employees.
If you want an extra challenge, complete the following
exercises:
10. Create a query to display the name and hire date of any
employee hired after employee Davies.
11. Display the names and hire dates for all employees who
were hired before their managers, along
with their manager’s names and hire dates. Label the columns
Employee, Emp
Hired, Manager, and Mgr Hired, respectively.
Solutions for questions Click Here!
Practice 5 : Aggregating Data
Using Group Functions
Determine the validity of the following three statements.
Circle either True or False.
1. Group functions work across many rows to produce one
result.
2. Group functions include nulls in calculations.
3. The WHERE clause restricts rows prior to inclusion in a
group calculation.
4. Display the highest, lowest, sum, and average salary of
all employees. Label the columns
Maximum, Minimum, Sum, and Average, respectively. Round your
results to the nearest whole
number. Place your SQL statement in a text file named
lab5_6.sql.
5. Modify the query in lab5_4.sql to display the minimum,
maximum, sum, and average salary for
each job type. Resave lab5_6.sql to lab5_4.sql. Run the
statement in lab5_5.sql.
6. Write a query to display the number of people with the
same job.
7. Determine the number of managers without listing them.
Label the column Number of
Managers. Hint: Use the MANAGER_ID column to determine the
number of managers.
8. Write a query that displays the difference between the
highest and lowest salaries. Label the
column DIFFERENCE.
If you have time, complete the following exercises.
9. Display the manager number and the salary of the lowest
paid employee for that manager.
Exclude anyone whose manager is not known. Exclude any
groups where the minimum
salary is $6,000 or less. Sort the output in descending
order of salary.
10. Write a query to display each department’s name,
location, number of employees, and the
average salary for all employees in that department. Label
the columns Name, Location,
Number of People, and Salary, respectively. Round the
average salary to two decimal
places.
If you want an extra challenge, complete the following
exercises:
11. Create a query that will display the total number of
employees and, of that total, the number of
employees hired in 1995, 1996, 1997, and 1998. Create
appropriate column headings.
12. Create a matrix query to display the job, the salary for
that job based on department number, and
the total salary for that job, for departments 20, 50, 80,
and 90, giving each column an appropriate
heading.
Subscribe to:
Posts (Atom)