Tester interview questions and answers are completely based on the interview I and my friends attended during last years of working experience as Quality Assurance Testers. These SQA questions and scenarios are based only on real experience and were asked during actual QA interviews. Therefore, QA Tester who is looking for a Quality Assurance job will greatly benefit from this. If you are the first time job seeker as a QA Tester, then it can help you even better. Finally, if you are plant to attend an interview, you have to know these questions and answers by heart and must be very smooth in answering these questions. Practice in front of the friends or just a mirror, speak loud and clear. Most of the time, when you study the questions, you feel fine and feel relaxed, but the reality is, at the time of the actual interview, even though you feel you have the knowledge, cannot express it well. It may sound a little rough, but this is everyone’s hard experience. When you come out the interview door, you are deeply regretted. If you cannot remember these by heart, believe me, it may not work. Readers are welcome to post own questions and answers to the following SQA interview questions.

SQL interview questions for QA Testers

Usually SQL interview questions are no surprise for any QA Tester who spent enough time on QA interview preparation. Almost every Software Quality Assurance Tester done black or white box testing of the software application developed with most popular commercial databases like MS SQL, Oracle SQL or open source databases like MySQL, PostgreSQL. As we all know, relational databases based on the concepts of relational algebra, but QA Tester does not need to comprehend relational algebra to test application developed with relational databases or answer on database interview questions, probably with exception for folks working for companies like Google, Microsoft or Oracle.

If QA Tester indicates on the resume that he or she has the database experience, an interviewer will definitely ask QA Engineer a few common SQL interview questions to determine the depth of the knowledge in database area. Common database interview questions are an extremely easy problems that an interviewer might use to determine whether interviewee have ever used T-SQL,PL/SQL or MySQL before or whether you were tailoring your resume when you mentioned it, while another database interview questions would determine your level of particular database knowledge.

First of all while preparing for database interview, software Tester should cover all the database related terminology, for example you should know the answers on any of these DB interview questions.

  • What does RDBMS stand for?
  • What do DDL, DML and DCL stand for?
  • What is a primary key?
  • What is the main role of a primary key in a table?
  • What is a foreign key?
  • Can a table have more than one foreign key defined?
  • What types of joins are possible with database server?
  • What's the difference between an inner join and an outer join?
  • What is a stored procedure?
  • What is trigger?
  • What is view?
  • What is cursor?

The next set of interview questions could puzzle some unexperienced Quality Assurance Engineers.

  • What is difference between DELETE, TRUNCATE and DROP commands?
  • Explain the difference between function and stored procedure?
  • What is SQL Profiler?
  • What default TCP Port is Microsoft SQL Server running under?
  • What default TCP Port is Oracle SQL Server running under?
  • What default TCP Port is MySQL running under?

Lastly QA Manager may ask a few coding interview questions. The candidate should be prepared to writing some SQL code on a whiteboard. Usually it involves a dialogue about written code, and analysis of SQL code correctness, compatibility and testing.

  • How to add record to a table?
  • How to add column to a table?
  • How do you change value of the field?
  • How to remove duplicate rows from a table?
  • Write a code to select the last N rows from a table?
  • Write a code to select the top N rows from a table?
  • Could you implement IF-THEN-ELSE logic in a SELECT statement?

Top Recommended Books For Software Testing Interview Preparation


Anonymous said...

Oh my God.....we totally didn't even learn any single part of these questions and I just looked at them right now, that's just !!! I hate my life

Anonymous said...

I was asked to design a simple database using ER Diagram..I had to also draw tables showing primary key,foreign key relationships etc..I was also asked to write some queries using sql functions such as count, sum etc

Anonymous said...

Thank you very much for these SQL questions. They are very useful.

aspiring said...

it is extremely useful...i know atleast some thing that i can be asked in these areas

Anonymous said...

its very useful..i was asked all the question exactly mentioned..
but read other questions too!

Anonymous said...

i need the answer for all these questions . please help me

Common QA Tester interview questions