Softpath System, Llc. Interview Questions.

It's always hard to know what to expect when going in for that interview -- and preparation can make all the difference. What is the interview process like at Softpath System, Llc.?

Any advice on striking the right note?

Here are the interview questions they asked me when i had interview with them last year.. I dont thing much has changed since then.. they ask the same question to all the interview candidates... Good luck for your interview..

what is primary key?
what is foreign key?
what is composity key?
what is cardinality?
difference between where and having
explain about group by clause
write a query to get records from students table using group by clause..
difference between delete and truncate
what is Unique Key
different type of constaints (Unique, check, default, Not Null)
what is Revoke and Grant
Aggregate functions (Count, Avg, sum, max, Min, etc)
How do you find the duplicate values in a table
Why do you use Alter
difference between stored procedure and function
what is Normalization?