Interview Questions

SQL*plus allows SQL and PL/SQL scripts to interactively run in command line.

It allows three kinds of commands to run; SQL, PL/SQL and SQL * Plus commands. It’s most commonly used by DBA’s to interact with the oracle database.

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.

All those activities which have been planned out by the marketing department must be tried out in the market several times in order to be able to conclude if such activities are worthwhile or not. Such activities may be repeated several times over a period say six months or a year in order to be able to decide whether to stick to them or replace them with other better alternatives. Monitoring and controlling the marketing activities entails keeping proper records of the various activities and tracking them time and again particularly when it comes to the media, when to promote the product, cost factor, reach or the number of persons towards whom the promotions have been targeted, responses generated, sales generation and return on sales

When communicating complex ideas, you keep your message simple and straightforward – avoiding technical jargon and overusing statistics. You don’t expect people to have the same background knowledge as you and are careful to introduce your idea in clear, concise terms. You find that giving examples, using pictures and graphs helps clarify difficult concepts and can be useful as people have different learning styles. You always encourage questions and if somebody is having difficulty understanding, you are quick to adapt your style.

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  

Standard interview tips and techniques still apply. Do not speak negatively about any supervisors, coworkers or former jobs. It is acceptable to share a specific situation that occurred with a former boss, but do not go into detail about the disagreement. Focus instead on what you did to help the supervisor see your point of view.

You may be asked a follow up question, such as “Did they ultimately see your point of view?” Be honest. Did they follow your advice or didn’t they? The answer is not as important as the presentation. Do not sound bitter in your response if they did not. “They did see my point of view. They chose a different path, but they understood my concerns and beliefs in the end.”

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