Interview Questions

When you're asked what didn't like about your previous job, don't be too negative. The reason is that you don't want the interviewer to think that you'll speak negatively about the new job or the company when you're ready to move on, if you get this job.Rather, it makes sense to talk about yourself and what you're looking for in a new role.

I enjoyed the people I worked with. It was a friendly and fun atmosphere and I actually enjoyed going into work each morning. I felt the leadership team was great as well.

One of the reasons I am leaving is that I felt I was not challenged enough at the job. As a new employee in the working world, the company offers a great opportunity for a good entry level position. However, after being there for so many years, I felt I was not able to reach my full potential because of the lack of challenge and there was no room for advancement in the company. While I did enjoy working there and appreciate the skills I developed while with the company, I feel my  skill set can be better utilized elsewhere, where my capabilities are more recognized and there is the opportunity for growth.

The people I worked with at ABC Company were top notch at what they do. Through my experience there, I learned a lot about different management styles, and strategies for maintaining cooperation in a large group project setting. I feel that as valuable as that experience has been, I am anxious to work on more specialized projects where I will have the opportunity to be more of a leader.

While the people at XYZ Company were terrific to work with, I felt that the opportunities for me there were limited by the structure and size of the company. I believe that a larger company with an international presence can offer challenges, as well as opportunities unavailable at a smaller firm. The position with your company is a great match for my skill set, and I feel that I would be an asset in your marketing (or HR or IT) department.

Run VERIFY.

Because these exps are paid/payable to persons. person includes Sole Proprietor, Partnership Firms, HUF, Co; etc.Personal accounts always appear in B/S until it is transfered to expenditure by debiting to P&L A/C.

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

A heap is a way to organize the elements of a range that allows for fast retrieval of the element.

Static (embedded) SQL:

1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.

2.It is more swift and efficient.

3.SQL statements are compiled at compile time.

4.Parsing, validation, optimization, and generation of application plan are done at compile time.

5.It is generally used for situations where data is distributed uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.

7. It is less flexible 

Dynamic (interactive) SQL:

1.In dynamic SQL, how database will be accessed is determined at run time.

2.It is less swift and efficient.

3.SQL statements are compiled at run time.

4.Parsing, validation, optimization, and generation of application plan are done at run time.

5.It is generally used for situations where data is distributed non-uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.

7.It is more flexible.

Testing an executable application for portability across system platforms and environments, usually for conformation to an ABI specification.

Public relations includes promotional activities that work to create a strong public image of the company. Public relations activities include helping the public to understand the company and its products. Public relations if done right can reach a large audience without the expensive cost of traditional advertising and marketing.