SQL Interview Questions-Vocab And Terminology

The Test Lead
3 min readNov 27, 2023

If your interview involves anything from databases to tables or SQL, it is important that you prepare properly for it. This article will cover some questions that you experience.

What is SQL?

SQL stands for Structured Query Language. It is a domain-specific language used to manage and manipulate relational databases.

What are the main types of SQL commands?

SQL commands can be broadly categorized into four types: Data Query Language (DQL), Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).

Explain the difference between SQL and MySQL.

SQL is a language used to communicate with databases, while MySQL is an open-source database management system that uses SQL to manage its databases.

What is a database?

A database is a structured collection of data organized in a way that allows easy retrieval, storage, and manipulation of the data.

What is a table in a database?

A table is a collection of data organized in rows and columns. It is the basic unit of storage in a relational database.

What is a primary key?

A primary key is a unique identifier for each record in a table. It ensures that each record can be uniquely identified.

Explain the concept of a foreign key.

A foreign key is a field in one table that refers to the primary key in another table. It establishes a relationship between the two tables.

What is a WHERE clause used for?

The WHERE clause is used to filter records based on a specified condition.

What is the difference between DELETE and TRUNCATE?

DELETE is used to remove specific records from a table, while TRUNCATE removes all records from a table, effectively resetting it.

What is an index in a database?

--

--

The Test Lead

SDET at fintech company in NYC. Visit personal page http://thetestinglead.com// Twitter @juss_bailey Youtube @The Test Lead