SQL - Manipulation

Question 1

relational database

Answer 1

A relational database is a database that organizes information into one or more tables.

Question 2

table

Answer 2

A table is a collection of data organized into rows and columns.

Question 3

_______ creates a new table.

Answer 3

CREATE TABLE

CREATE TABLE celebs (
id INTEGER,
name TEXT,
age INTEGER
);

Question 4

_______ adds a new row to a table.

Answer 4

INSERT INTO

INSERT INTO celebs (id, name, age)
VALUES (1, ‘Justin Bieber’, 29);

Question 5

_______ queries data from a table.

Answer 5

SELECT

SELECT name FROM celebs;

SELECT * FROM celebs;

Question 6

_______ changes an existing table

Answer 6

ALTER TABLE

ALTER TABLE celebs
ADD COLUMN twitter_handle TEXT;

Question 7

_______ edits a row in a table

Answer 7

UPDATE

UPDATE celebs
SET twitter_handle = ‘@taylorswift13’
WHERE id = 4;

Question 8

_______ deletes rows from a table

Answer 8

DELETE FROM

DELETE FROM celebs
WHERE twitter_handle IS NULL;

Question 9

What does SQL stand for?

Answer 9

Structured Query Language

Question 10

What is a relational database?

Answer 10

A database that organizes information into one or more tables.

Question 11

Which clause is used with the ALTER TABLE statement?
- INTO
- ADD COLUMN
- JOIN
- SELECT

Answer 11

ADD COLUMN

Question 12

UPDATE ________
SET height = 6
WHERE id = 1;

• column name
• the keyword INTO
• row name
• table name

Answer 12

Table name

Question 13

What is a NULL value?

Answer 13

A value that represents missing or unknown data

Question 14

What are the four common data types in SQL?

Answer 14

Integer, Text, Date, Real

Question 15

Which of the following statements is correct and complete?

DELETE FROM icecream
WHERE flavor IS NULL;

WHERE flavor IS NULL;

WHERE flavor IS NULL
DELETE FROM icecream;

DELETE icecream
WHERE flavor NULL;

Answer 15

DELETE FROM icecream
WHERE flavor IS NULL;

Question 16

What is the purpose of the * character?

SELECT *
FROM celebs;

Answer 16

It selects every column in the table.

Question 17

What does the INSERT statement do?

Answer 17

Insert new rows into a table.

Question 18

What would be correct syntax for a CREATE TABLE statement?

CREATE meals
name TEXT
rating INTEGER

CREATE TABLE meals (
name TEXT,
rating INTEGER
);

NEW TABLE meals (
name TEXT,
rating INTEGER
);

CREATE meals (
name TEXT,
rating INTEGER
);

Answer 18

CREATE TABLE meals (
name TEXT,
rating INTEGER
);