DML

Question 1

INSERT

VALUES

Answer 1

INSERT dataset.Inventory (product, quantity)
VALUES('top load washer', 10),
      ('front load washer', 20),
      ('dryer', 30),
      ('refrigerator', 10),
      ('microwave', 20),
      ('dishwasher', 30),
      ('oven', 5)

Question 2

INSERT SELECT

Answer 2

INSERT dataset.Warehouse (warehouse, state)
SELECT *
FROM UNNEST([('warehouse #1', 'WA'),
      ('warehouse #2', 'CA'),
      ('warehouse #3', 'WA')])

Question 3

열 이름이 없는 INSERT

Answer 3

INSERT dataset.Warehouse

VALUES(‘warehouse #4’, ‘WA’), (‘warehouse #5’, ‘NY’)

Question 4

DELETE 문

Answer 4

DELETE dataset.Inventory

WHERE quantity = 0

Question 5

서브 쿼리가 포함된 DELETE

Answer 5

DELETE dataset.Inventory i
WHERE i.product NOT IN (
SELECT product from dataset.NewArrivals)

Question 6

TRUNCATE TABLE

Answer 6

TRUNCATE TABLE dataset.Inventory

Question 7

UPDATE

Answer 7

UPDATE dataset.Inventory
SET quantity = quantity - 10
WHERE product like ‘%washer%’