2. Selecting, Updating and Deleting Data

Question 1

To sort data, you must use which clause?

Answer 1

ORDER BY

Question 2

The result set defaults to displaying data in what order?

Answer 2

Ascending order.

Question 3

What statement is used to display a result set, to the opposite of ascending order?

Answer 3

DESC

Question 4

What is a result set?

Answer 4

The result of a select statement which is stored in a result table.

Question 5

Which character is used to close/complete a statement?

Answer 5

Semi colon or ;

Question 6

What are some examples of Comparison Operators?

Answer 6

> Greater than= Greater than or equal to Not equal to

Question 7

What is an AND operator used for?

Answer 7

…

Question 8

What is an OR operator used for?

Answer 8

…

Question 9

To search or retrieve data you must use which statement?

Answer 9

The SELECT statement.

Question 10

Give an example of a statement which would allow you to search for ..

Answer 10

…

Question 11

The data in a table can be removed using which statement?

Answer 11

The ‘DELETE’ statement.

Question 12

Why should you be careful when not using a WHERE clause in a delete statement?

Answer 12

If you don’t specify which row or column you wish to delete, then the whole table can be deleted.

Question 13

True or false, does a DELETE statement require a WHERE condition?

Answer 13

False.

Question 14

What statement allows you to add new data to the table?

Answer 14

INSERT

Question 15

Give an example of a query which will allow you to add new data to specific columns.

Answer 15

INSERT INTO table (column)VALUES (value1)

Question 16

What statement allows you to change existing data in a table?

Answer 16

UPDATE

Question 17

Give an example of a query which will allow you to change data to specific columns.

Answer 17

UPDATE table
SET column = newvalue
Optional:WHERE id = value;