sql-insert/update/delete

Question 1

How do you add a row to a SQL table?

Answer 1

insert into statement

Question 2

What is a tuple?

Answer 2

a list of values

Question 3

How do you add multiple rows to a SQL table at once?

Answer 3

add multiple tuples separated by commas

Question 4

How do you get back the row being inserted into a table without a separate select statement?

Answer 4

returning *

Question 5

How do you update rows in a database table?

Answer 5

update statement and set clause

Question 6

Why is it important to include a where clause in your update statements?

Answer 6

so that it targets a specific row and not all rows

Question 7

How do you delete rows from a database table?

Answer 7

delete from statement

Question 8

How do you accidentally delete all rows from a table?

Answer 8

only putting delete statement