Member-only story
SQL Interview Questions-Entry Level Part 2
Whether you go for a QA or automation job, you will be interviewed in your SQL knowledge. You are still new to the QA or Automation field, but want to start preparing for your potential interviews. The earlier you start preparing the better you will be at answering the questions. This article will give you 10 questions that you may get asked in an interview. Because you are new to the field, questions will be mainly geared toward your knowledge and not your experience.
This is part 2, Part 1 can be accessed here.
- What are constraints in SQL? Can you name some used in SQL?
Constraints are a way to set rules in regard to the data inside of a table. It can be applied when creating or updating a table. Some examples include NOT NULL, DEFAULT, UNIQUE, INDEX, PRIMARY KEY, and FOREIGN KEY
2. What are the 4 different types of joins in SQL?
Inner join or regular join when used will return the rows that have matching values in both of the tables involved in the join.
Left join when used will return all the rows from the left table and all of the matched rows from the right table.
Right join when used will return all the rows from the right table and all of the matched rows from the left table.
