Interview Questions

Look for the existence of the following items:

- Generic Data Models

- An Enterprise Data Platform

- Identify the Data Sources

- Selection of a MDM Product

- Implementation of a Customer Master Index or appropriate alternative

An application plan or package is generated by the bind to define an access path. 

Overloading allows multiple functions to exist with same name but different parameters. Again if you take bike as an example, it has a function “Start” with two forms i.e. ’Auto Start’ and ’kick start’.

Business facts or measures and foreign keys are persisted in fact tables which are referred as candidate keys in dimension tables. Additive values are usually provided by the fact tables which acts as independent variables by which dimensional attributes are analyzed.

Attributes that are used to constrain and group data for performing data warehousing queries are persisted in the dimension tables.

Generally Accepted Accounting Principles (GAAP) are basic accounting principles and guidelines are concepts that govern the field of accounting.

Accounting principles and guidelines include :

* Business Entity Assumption

* Accounting Period

* Historical Cost Concept

* Full Disclosure Principle

* Cost Principle

* Matching Principle

* Materiality

* Monetary Unit Assumption.

The main difference lies in the motive of the two parties. The main motive of the hedger is to hedge(minimize) the risk from the occurence of some events. 

The motive of the speculator is to gamble in the market in order to make the profit by buying/selling the derivative products.

In economy, the currency value depends on imports and exports, inflation, employment, interest rates, growth rate, trade deficit, performance of equity markets, foreign exchange reserves, macroeconomic policies, foreign investment inflows, banking capital, commodity prices.

Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only.

Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication. It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated.

Differences between Basic and Advanced replications:

- With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system.

- With Basic Replication applications can query data from local data replicas. On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data.