Chapter 06 Manipulating Data

Question 1

The [Blank] statement is used to add new rows to a

table.

Answer 1

INSERT
INSERT INTO [schema.]table_name [(column_list)]
VALUES (data_values)
You can insert using subqueries

Question 2

The [Blank] statement is used to modify existing rows in a table

Answer 2

UPDATE
UPDATE 
SET  = 
[, =  … … …]
[WHERE ]

Question 3

The [Blank] statement is used to remove rows from a table.

Answer 3

DELETE
DELETE [FROM]
[WHERE ]

Question 4

What is the DESCRIBE command?

Answer 4

list the table columns, the columns are listed in that order.

Question 5

COMMIT statement

Answer 5

Ends the current transaction, making data changes permanent

and visible to other sessions.

Question 6

ROLLBACK statement

Answer 6

Undoes all data changes in the current transaction.

Question 7

ROLLBACK TO SAVEPOINT

Answer 7

Undoes all data changes in the current transactions
going chronologically backward to the optionally
named savepoint.

Question 8

SAVEPOINT

Answer 8

Sets an optional marker within the transaction to be

able to go back to this position if needed.