Explanation
A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.

Explanation/Reference:
NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.
The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.
Incorrect answers:
D: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services.

Explanation
Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users.
Steps:
1. Login to Repository using OBIEE Admin Tool
2. Navigate to Manage > Identity
3. Go to Application Role tab, choose the role and double click on it to open.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-25-38.png

4. Click on Permissions tab
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-13.png

5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-45.png

Explanation/Reference:
Enterprise Install: This installation type assumes some familiarity with Oracle Business Intelligence. All software components are downloaded onto one computer. You can accept the default configuration settings or use your own. You use this installation type when you have an established Oracle WebLogic domain, and you want to extend it to the Oracle Business Intelligence application. This install option is typically used for more advanced deployments with multiple users, such as to scale out a deployment on additional computers.
Incorrect answers:
D, E: Simple Install
The default selection. All software components are downloaded onto one computer and configured with default settings. Oracle Business Intelligence runs after the installation is completed. This install option is typically used for a single user deployment, such as for demonstration or development purposes.

If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.
Figure:

Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at Essbase, and other OLAP server, customers; the new hierarchical columns feature brought proper OLAP analysis to OBIEE, and coupled with OLAP-oriented features such as hierarchical prompts and selection steps, made OBIEE 11g a much more conducive environment for Essbase users.
There's much better support for Essbase-native features such as value-based hierarchies, alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based hierarchy feature in particular is very welcome as it can avoid the need to completely re-import your Essbase database if your outline gains additional hierarchy levels.
So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps, scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on, there's a lot to recommend OBIEE 11g to users of the "legacy" Hyperion tools looking for a bit of a refresh of their BI environment.