Explain various types of locks in a transaction? Which is better and why?
What is sharded database?
what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
How does rows store in Teradata
A design problem was given in which I was supposed to make a design for the data base for a given problem.
Explain inner and outer joins with examples.
What is difference between data and database?
What is ole db in ssis?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
Explain about ur projets on teradata???
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
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.
Give the syntax of exception handling used in DBMS?