SQL Query Quiz

Create a database table to store information about employees.

Avni is working on a project and needs to modify an existing database table by adding a new column. Write a SQL query to accomplish this task.

Write a SQL query to remove a column from the employee table.

Write a SQL query to rename an existing table.

Grant a user named Aarush permission to access a confidential database containing sensitive information.

Write a SQL query to revoke a user's permission to insert data into a table.

Write a SQL query to start a new transaction in a banking database.

Write a SQL query to set a savepoint within a transaction.

Write a SQL query to roll back to a specific savepoint.

Write a SQL query to delete a record from an existing database table.