SQL CRUD Operations Quiz

Last Updated :
Discuss
Comments

Question 1

Which SQL statement is used to create a new table?

  • INSERT

  • CREATE

  • ADD

  • MAKE

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

Question 3

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

  • UPDATE

  • INSERT

  • ADD

  • APPEND

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

Question 5

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

  • MODIFY

  • ALTER

  • UPDATE

  • CHANGE

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

Question 7

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

  • REMOVE

  • DROP

  • DELETE

  • DESTROY

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

Question 9

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

  • MODIFY

  • CHANGE

  • ALTER

  • UPDATE

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

There are 10 questions to complete.

Take a part in the ongoing discussion