Questions

SQL profiler is a tool to monitor performance of various stored procedures. It is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries. Capture any problems by capturing the events on production environment so that they can be solved.

The capital of India shift from Kolkata to New Delhi in the year 1911.

Execution Unit receives program instruction codes and data from BIU, executes these instructions and store the result in general registers.

interrupt is a signal send by external device to the processor so as to request the processor to perform a particular work.

A signal informing a program that an events has occurred. when a program receives an interrupt signal, it takes a specified action (which can be to ignore the signal).

Program counter holds the address of either the first byte of the next instruction to be fetched for exectuion or the address of the next byte of a multi byte instruction, which has not beeb completely fetched. in both the cases it gets increnented automatically one by one as the instruction bytes get fetched. Also Program register keeps the address of the next instruction.