SQL Interview Questions and Answers you must Prepare in 2021

What is SQL?

SQL stands for Structured Query Language. It is the primary language to interact with databases.

How to create a table in SQL?

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype,   .... );

How to delete a table in SQL?

There are two ways to delete a table from sql: DROP and TRUNCATE.

How to change a table name in SQL?

This is the command to change a table name in SQL: ALTER TABLE table_name RENAME TO new_table_name;

How to delete a row in SQL?

We will be using the DELETE query to delete existing rows from the table: DELETE FROM table_name WHERE [condition];