Interview Questions

The main differenc between View and Materialized View states that -

1. View means it stores the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.

2. Materialized view means it stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Advantage include quick query results.

Financial management refers to the efficient and effective management of money (funds) in such a manner as to accomplish the objectives of the organization. It is the specialized function directly associated with the top management.

Hence, it deals with Financial decisions.

I think its 8 because even if i have strength i still have weaknesess.

BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.

The main purpose in measuring the effectiveness of any advertising campaigns is to evaluate its effect on the sales and also brand recall factor. The mathematical equation for measuring the effectiveness of an advertising campaign is:

Advertising campaign effectiveness = Revenue + Return on investment (ROI)

There are various ways to measure the effectiveness of advertising campaigns:

         - Conducting a survey after the campaign ends

         - Proportionate increase in the sales of that particular product/service

         - More customers calling to a toll-free and prescribed lines

         - Redemption of coupons and vouchers

         - Increased footfalls in the store to purchase product/service

         - Increased click on the company’s website  

State Bank of India (SBI) is the largest public sector banks in India. It was the first bank established in India as Bank of Calcutta in 1806 and then Imperial Bank of India and then it became State Bank of India on 1st July 1955. The Headquarters of State Bank of India is in Mumbai, Maharashtra.

An advertisement campaign must comprise of the following:

      - A solid marketing plan

      - Advertising budget

      - Media buying and planning

      - Choosing the right target audience

      - Selection of relevant advertising medium

      - Consistency in campaign theme 

      - Frequency 

A foreign exchange rate is the price of the domestic currency stated in terms of another currency.