SQL – Interpret and modify

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

What does the SELECT statement do?

Answer 2

SELECT statement is used to collect fields from a given table

Question 3

What does the SELECT * statement do?

Answer 3

SELECT * specify that the query should return all columns of the queried tables

Question 4

What does the FROM statement do?

Answer 4

Can be paired with the SELECT statement to specify which table(s) the information will come from

Question 5

What does the WHERE statement do?

Answer 5

The WHERE statement can be used in conjunction to specify the search criteria

Question 6

What does ORDER BY statement do?

Answer 6

The ORDER BY part of the code specifies whether you want it in ascending or descending
order (values are automatically placed in ascending order)

Question 7

What does the ORDER BY ____ Desc statement do?

Answer 7

Adding ‘Desc’ to the end of statement will cause values to be displayed in descending order

Question 8

What does the JOIN statement do?

Answer 8

JOIN provides a method of combining rows from multiple tables based on a common field
between them

Question 9

What does the CREATE statement do?

Answer 9

The CREATE function allows you to make new databases

Question 10

What does the ALTER statement do?

Answer 10

ALTER is used to add, delete or modify the columns in a table

Question 11

What does the INSERT INTO statement do?

Answer 11

This is used to insert a new record into a database table

Question 12

What does the DELETE statement do?

Answer 12

Used to delete a record from a database table