Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is the difference between primary and candidate key?
What is the relationship that exists inside in E-R diagram?
Explain file manager?
What are different types of resources?
What is Stored procedure ?
4 Answers IBM, iGate, Inspira Technologies,
What are the three types of anomalies in database and Explain?
Explain various types of locks in a transaction? Which is better and why?
What is difference between data and database?
What is meant by distributed system?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What are different types of clusters present?
aht is the difference b/w network & hierarchial & relational dbms????