Interview Questions

State is quite an innovative concept in Web development because it eliminates the drawback of losing state data due to reloading of a Web page. By using states in a Web application, you can preserve the state of the application either at the server or client end. The state of a Web application helps you to store the runtime changes that have been made to the Web application. For example, as already described earlier, a change in the data source of the Web application might be initiated by a user when he/she selects and saves some products in the shopping cart.

If you are not using states, these changes are discarded and are not saved. You may think that the whole concept of storing states is optional. However, under certain circumstances, using states with applications is imperative. For example, it is necessary to store states for Web applications, such as an e-commerce shopping site or an Intranet site of a company, to keep track of the requests of the users for the items they have selected on the shopping site or the days requested for vacation on the Intranet site.

The intention of the interviewer by asking this question is to discover the pain points for the candidate.

Here this can be explained with an example like this :

The administrative assistant might seem like someone whose job is simply keeping everything filed and organized and scheduled. But they actually are the building block of the entire office, making everyone's lives function more smoothly and with good access to information when they need it.

Sometimes I have so many things crossing my desk at a given time that I can get a bit overwhelmed. When this happens I take a deep breath and focus on prioritizing the work. Then I get a clear head again and can dive back in.

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

A web application resides in the server and serves the client’s requests over internet. The client access the web page using browser from his machine. When a client makes a request, it receives the result in the form of HTML which are interpreted and displayed by the browser.

A web application on the server side runs under the management of Microsoft Internet Information Services (IIS). IIS passes the request received from client to the application. The application returns the requested result in the form of HTML to IIS, which in turn, sends the result to the client.

Method contains name, parameters, return type and executable body. But block does not contains name, parameters, return type.It contains only executable body.

Methods are executed by method call statements. Blocks are executed automatically with class loading and with object creation.

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

I like new challenges and fortunate to develop. As long as I keep doing these, I don’t think I’ll need to alter. I’d like to consider that this relationship lasts for many years. However, I haven’t set a period of time limit as such.

Tips :

Make your answer relevant to the specific nursing job. For example common qualities required for successful performance as an ER Nurse include adaptability, resilience, critical thinking, organization and planning, emotional stability and high stress tolerance.