Technology Questions

'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.

- Web browser supports HTTP secure method that allows more security for the sites that are involved in day to day basis transaction. 

- Security offers quick and easy way to remove the unwanted material or the things that are stored without permission like cache, cookies and history. 

- Security is being provided by the use of blockers that blocks unwanted access to the websites from the outside. 

- Web browser uses other features like disabling of JavaScript and pop up blockers to block any unwanted scripts or messages to run on the system.

- Web browser also uses the security concerns in regard of blocking the access to the secure sites that provides money transfer facilities, etc.

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

We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection. SQL statements that cannot be executed in the solidDB front-end server are passed over to the back end. 

SQLPASSTHROUGH mode can be set as per session or per transaction. The connection between the front end and back end is made with a back-end compatible ODBC driver which is loaded dynamically in solidDB server.

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

bcoz the static method does not contains the 'this' reference.

Notices, Warnings and Fatal errors are the types of errors in PHP

Notices: 

Notices represents non-critical errors, i.e. accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all but whenever required, you can change this default behavior.

Warnings: 

Warnings are more serious errors but they do not result in script termination. i.e calling include() a file which does not exist. By default, these errors are displayed to the user.

Fatal errors: 

Fatal errors are critical errors i.e. calling a non-existent function or class. These errors cause the immediate termination of the script.