TABLE MANAGEMENT

Question 1

INSERT INTO

Answer 1

Key work to add data

INSERT INTO order(name, id, price)
VALUE(‘Teddy beer’, 6578, 13);

Question 2

VALUES

Answer 2

It lets you add data to a newly created columns.

INSERT INTO order(name, id, price)
VALUE(‘Teddy beer’, 6578, 13)

Question 3

DELETE FROM

Answer 3

It lets you remove specific data from a existing table based in the condition.

DELETE FROM order
WHERE price > 7

Question 4

UPDATE

Answer 4

Renames or changes a data in a table.

UPDATE user
SET time = ‘19:00’
WHERE name = ‘smith’ ;

Question 5

SET

Answer 5

Sets an instruction to update.

UPDATE user
SET time = ‘19:00’
WHERE name = ‘smith’ ;

Question 6

CREATE TABLE

Answer 6

A keyword that lets you create a column.

CREATE TABLE name(floor INTEGER, company TEXT)

Question 7

What are 3 common data types.

Answer 7

INTEGER, REAL and TEXT

Question 8

ALTER TABLE

Answer 8

keyword to makes changes to an existing table.

ALTER TABLE data
ADD discount INT;

Question 9

ADD

Answer 9

Adds a new column.

ALTER TABLE data
ADD discount INT;

Question 10

DROP COLUMN

Answer 10

Removes a whole column.

DROP COLUMN column

Question 11

RENAME

Answer 11

Renames the column name.

ALTER TABLE order
RENAME order TO bill;