Interview Questions

It refers to the possibility for an investor to experience  losses due to  factors that affect the overall performance of the financial markets. Market risk cannot be eliminated through diversification, though it can be hedged against. The sources of market risk include natural disasters, recessions, political turmoil, changes in interest rates and terrorist attacks.

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.

Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.

Differences:

- A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.

- The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.

Good customer service means having thorough knowledge of your inventory, experience with your products, and being able to help customers make the best choices for them.

The backup strategies that are provided by Oracle are as follows:

- Logical backup using Exports and import.

- Physical file system backup

- RMAN Recovery Manger which is also known as incremental files system backup.

Debenture holder are those who provides long term loan at specific interest rate in term of cash and creditor provides only short term credit in term of cash for purchasing of goods.

Oracle Real Application Clusters (RAC) is a software component we can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance. RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology. To support this architecture, the machines that host the database instances are linked by a high-speed interconnect to form the cluster. Oracle RAC offers features in the following areas:

- Scalability

- Availability

- Load balancing

- Failover

to get the ping back from other computer with no packet loss

These days channel members are being accepted by companies as their partners. The intermediaries are even being asked to integrate their business with the companies which results in lesser costs, greater efficiency and improved customer service. Corporates like Airtel are adopting PRM (Partner relationship management) software to give that added advantage to their supply chain. They organise rewards and recognition programs for their channel partners and also organise proper channels though which partners can vent any of their grievances relating to payments, violation of codes etc.