This test is run by .
Note that your final mark will not be saved in the system.
Note that your final mark will not be saved in the system.
20 - Databases Typeit
Target Level
C
Running Total
0
0%
Attempt
1 of 3
Type the correct answers into the spaces. Fill all the spaces before clicking ‘Check Answers!’
The following table is called numbers, and it is subject to a series of SQL queries. If a query results in a single value being generated, type that output into the 'result' box. If a query results in multiple values, type in the leftmost value of the top row that would be generated. Note that the top row comprises only field headers.
| A | B | C | D | E | F | G |
| 1 | 5 | 2 | 6 | 7 | affix | 22/02/1980 |
| 2 | 3 | 9 | 8 | 4 | suffix | 21/03/1980 |
| 3 | 7 | 1 | 7 | 5 | fix | 23/01/1980 |
| 4 | 4 | 8 | 5 | 3 | fixed | 20/04/1980 |
| 5 | 1 | 3 | 2 | 9 | fixing | 21/02/1980 |
| 6 | 8 | 4 | 4 | 6 | affixed | 22/01/1980 |
SELECT * FROM numbers |
|
SELECT B, A FROM numbers ORDER BY B DESC |
|
SELECT * FROM numbers WHERE F = 'fix' |
|
SELECT D FROM numbers WHERE F LIKE 'fix%' |
|
SELECT E FROM numbers WHERE B > 5 ORDER BY A |
|
SELECT * FROM numbers WHERE G < '23/01/1980' |
|
SELECT D FROM numbers WHERE E < 5 OR A > 3 |
|
SELECT * FROM numbers WHERE F LIKE '%fix' ORDER BY G DESC |
|
SELECT B FROM numbers WHERE A > B |