RHEAL Software Pune Interview Questions

Hello sir, I’m preparing for to getting job in RHEAL Software Pune. For its interview process I want some interview questions for RHEAL Software Pune?

[sumit]

The RHEAL Software Pune is invited candidates for interview process. The Interview at its offices at Pune:

Address:

RHEAL Software Pune
Bldg 4A, SP InfoCity SEZ,
Pune Saswad Road,
Phursungi, Pune

Monday through Friday: 10AM – 1PM & 3PM – 7PM
Saturday: 10AM – 1PM

1st Round:
Please come prepared for a written SQL examination. Unless you clear this, you will not go on to the next round.

2nd Round:

Verbal interview on ASP.Net/VB.Net/C# and .net framework concepts

Some interview questions for RHEAL Software Pune:

What is trigger?
What is Clustered & Non-Clustered Index?
How many types of triggers are there?
What is constraints?
What is the difference between Truncate and Delete?
What Primary key and Unique key?
How to join two tables in Sql Server?
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What's the difference between a primary key and a unique key?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What is a transaction and what are ACID properties?
What's the maximum size of a row?
How to change Database name in SQL Server?
What is cursor in SQL Server?
What is #temp table and @table variable in SQL Server?