Fetch Data, Insert/Edit Rows and Tables

Question 1

What do SELECT statements do?

Answer 1

fetch data from a database

Question 2

What do FROM statements do?

Answer 2

specify the name of the table to query data from

Question 3

What is the basic SELECT / FROM statement format?

Answer 3

SELECT column_name FROM table_name;

Question 4

What does the asterisk * mean in the SELECT * FROM command?

Answer 4

It means that you will select every column in the table, without individually listing each column name

Question 5

What do INSERT INTO statements do?

Answer 5

insert new rows into a table

Question 6

What is the basic INSERT INTO statement format?

Answer 6

table_name (column1_name, column2_name, column3_name) VALUES (row1_value, row2_value, row3_value);

Question 7

How do you denote text in SQL?

Answer 7

place it within a set of apostrophes (example, ‘Batgirl’)

Question 8

What do UPDATE statements do?

Answer 8

edit existing rows

Question 9

What do SET statements do?

Answer 9

indicate the column to edit

Question 10

What do WHERE statements do?

Answer 10

indicate which rows to update with the new column value

Question 11

What is the basic UPDATE statement format?

Answer 11

UPDATE table_name SET column_name = new_value WHERE row_identifier1 = row_identifier2;

Question 12

What do DELETE FROM statements do?

Answer 12

remove rows that meet a certain criteria

Question 13

What is the basic DELETE FROM statement format?

Answer 13

DELETE FROM table_name WHERE column_name IS value;

Question 14

What do ALTER TABLE statements do?

Answer 14

add or remove columns

Question 15

What do ADD COLUMN statements do?

Answer 15

add a column to the table

Question 16

What do REMOVE COLUMN statements do?

Answer 16

remove a column from the table

Question 17

What is the basic ALTER TABLE statement format?

Answer 17

ALTER TABLE table_name ADD COLUMN column_name DATA_TYPE;

Question 18

What is a NULL value?

Answer 18

a special value in SQL that represents missing or unknown data