Question { TCS, 113283 }

Write a query to find second highest salary of an employee.

Answer

SELECT max(salary) as salary FROM Employee WHERE salary <
(SELECT max(salary) FROM Employee)

Question { TCS, 8326 }

1.Where are the sessions storing ?
2.What are the contents of a session file ?
3.If the server is loaded with too many session files there
is a possibility of server crash. How can we solve this
issue?
4. How does php server identify that the particular session
belongs to particular user ? For ex: If two users A and B
logged from different machine, separate session files (say
1 and 2) will be created in the server. But how the php
knows that 1 belongs to A and 2 belongs to B ?

Answer

4. When session_start() a session id will be generated and
it will be placed in a client machine in a cookie. If
suppose the cookie is disabled in client machine then the
session id will send through the url.