Allscripts Applications Support Consultant interview questions

Total 5 rounds. EPT (English Grammar Test), Communication round, SQL Test, HM Round and final HR Round. 1st round is Online exam where they check you English Grammar and 2nd round is communication(They will give you topic and you have to talk on same topic for atleat 2 min.) SQL Test: Very basic question : What is a primary key?, What is a foreign key?, What are the types of join and explain each?, What is a stored procedure? and some basic queries. HM Round: Some technical questions and your past experience, reason for leave old company.