SQL CRUD Operations Quiz

CRUD Operations, which stands for Create, Read, Update, and Delete, is fundamental to working with databases in SQL. This quiz is designed to test your knowledge and understanding of CRUD operations in SQL.

Last Updated :
Discuss
Comments

Question 1

Which SQL statement is used to create a new table?

  • INSERT

  • CREATE

  • ADD

  • MAKE

Discuss it

Question 2

What does the SQL acronym CRUD stand for?

  • Create, Read, Update, Destroy

  • Create, Read, Update, Delete

  • Copy, Read, Update, Delete

  • Construct, Retrieve, Update, Delete

Discuss it

Question 3

Which SQL statement is used to insert new data into a table?

  • UPDATE

  • INSERT

  • ADD

  • APPEND

Discuss it

Question 4

What does the SQL keyword "DELETE" do?

  • Removes specific rows from a table

  • Updates existing records in a table

  • Adds a new column to a table

  • Creates a new table

Discuss it

Question 5

Which SQL statement is used to update existing data in a table?

  • MODIFY

  • ALTER

  • UPDATE

  • CHANGE

Discuss it

Question 6

What does the SQL keyword "SELECT" do?

  • Adds new records to a table

  • Updates existing records in a table

  • Retrieves data from a database

  • Deletes specific rows from a table

Discuss it

Question 7

Which SQL statement is used to delete a table from a database?

  • REMOVE

  • DROP

  • DELETE

  • DESTROY

Discuss it

Question 8

What does the SQL keyword "INSERT INTO" do?

  • Modifies the structure of an existing table

  • Deletes specific records from a table

  • Adds a new column to a table

  • Inserts new records into a table

Discuss it

Question 9

Which SQL statement is used to modify the structure of an existing table?

  • MODIFY

  • CHANGE

  • ALTER

  • UPDATE

Discuss it

Question 10

What does the SQL keyword "UPDATE" do?

  • Adds a new column to a table

  • Retrieves data from a database

  • Modifies existing records in a table

  • Deletes specific rows from a table

Discuss it

There are 10 questions to complete.

Take a part in the ongoing discussion
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy