Member-only story
SQL Interview Questions-Entry level
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 towards your knowledge and not your experience.
1. What is SQL vs MySQL?
SQL is a query programming language that manages a relational database management system(RDBMS). Whereas MySQL is an example of a relational database management system that uses SQL.
2. What is a primary key and why is it important?
A primary key is the column or columns that contain values that uniquely identify each row in a table. No 2 rows can have the same primary key values. It is important because it ensures row-level accessibility when creating queries.
3. What are some of the different commands that you can use to manipulate data in a table?
Insert, Update, Delete
4. What is a Database Schema?
A database schema represents the configuration of all or part of a relational database. It is considered the “blueprint” and describes how data may relate to other tables.
5. What is the difference between DROP, DELETE, and TRUNCATE?
The DROP command deletes a table and all of the records inside of it.
The DELETE command is used to remove 1 or more rows from a table.
The TRUNCATE command deletes all of the data in the table, but the table still exists after, unlike with the DROP command.
6. What is normalization in a database?
Database normalization is the process of structuring a relational database in accordance with a series of normal forms to reduce data redundancy and increase data integrity.
