Technology Questions

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

Data warehousing is a process of repository of electronic data of an organization. For the purpose of reporting and analysis, data warehousing is used. The essence concept of data warehousing is to provide data flow of architectural model from operational system to decision support environments. 

'ViewState' is specific to a page in a session.
'SessionState' is specific to user specific data that can be accessed across all pages in the web application.

A cookie is a small text file on the client machine either in the client’s file system or memory of client browser session.

Both these are used to combine the results of different SELECT statements.

    UNION       - Selects only distinct values 

    UNION ALL - Selects duplicate values also

Syntax:

    SELECT column_name(s) FROM table1

    UNION / UNION ALL

    SELECT column_name(s) FROM table2;

Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.

Windows services, previously known as NT services, are applications that are installed on the system as system services. In other words, Windows services are applications that run in the background with the Windows operating system. The primary use of Windows services is to reduce the consumption of memory required for performing backend operations. Let's take an example to understand this easily. Suppose you want to perform a variety of functions, such as monitor the performance of your computer or application, check the status of an application, and manage various devices, such as printers.

In such a case, you can use Windows services to reduce memory consumption. In addition, Windows services can run on your system even if you have not logged on to your computer. In addition, these services do not have any user interface.

Cache events are processed only when the Postback events occur