Interview Questions

Trigger allows us to execute a batch of SQL code when an insert, update or delete command is executed against a specific table.

Triggers are special types of stored procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the insert, delete and update operation.

 Accounts receivables help small businesses by providing quick-time period liquidity. Additionally continued sales on credit provide the  much-needed continuity for small companies.

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.

The purpose of this question is to check your adaptability and flexibility. Did you feel victimized?

Answer this question by mentioning the change that was made but the main focus should be on how you adjusted in that situation and the results you achieved afterwards.

For example you can say something like, “Being an early joiner in the marketing team, I opened a lot of new customer accounts. Over the time the team grew and we had more people in the team opening more accounts. At one point of time, we had to re-distribute the accounts area wise so that a particular territory can be allotted to each one of us. This re-distribution meant loss of my high performing accounts and a requirement to develop new accounts in the assigned territory. Initially, it looked difficult but I could understand the need for this re-distribution and saw more opportunities for the company and myself. I introduced my colleagues to the old accounts I held and started strategizing for better ways to tap the new territory. Within 6 months, I could develop 50 new accounts with the help of new strategy. Usually we would achieve this result in 9 months to a year.”

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

You can use the System.Net.Mail.MailMessage and the System.Net.Mail.SmtpMail classes to send an email in your Web pages. In order to send an email through your mail server, you need to create an object of the SmtpClient class and set the server name, port, and credentials.

In a mapreduce job the master pings each worker periodically. In case a worker does not respond to that system then the system is marked as failed. Even completed tasks are rescheduled because the output was stored in a in a local disk of a worker which failed. Hence mapreduce is able to handle large-scale failures easily by simply restarting a task. The master node always saves itself at checkpoints and in case of any failure it simply restarts from that checkpoint.