Databases & SQL (paper 2)

Question 1

what is a database

Answer 1

a way of holding data in an organised way so that searching for data items meeting certain criteria is quick and easy

Question 2

What is the order of tables fields and records inside a database

Answer 2

Tables are inside a database
There are field (columns) in a table
Records are rows in a database

Question 3

what is A on this diagram

Answer 3

the unique ID

Question 4

whats is B on this diagram

Answer 4

the table

Question 5

what is C on this diagram

Answer 5

a field

Question 6

what is B on this diagram

Answer 6

a record

Question 7

what does SQL stand for

Answer 7

structures query language

Question 8

what is used to search records in a database

Answer 8

SQL

Question 9

What is the structure of SQL code

Answer 9

SELECT … , … , …
FROM (table name)
WHERE (condition)
ORDER BY (field name) ASC / DESC;

Question 10

what is the code used to count the number of records with a condition

Answer 10

SELECT COUNT(…)
FROM (table name)
WHERE …;

Question 11

whats is the code used to find the total of all records in a field

Answer 11

SELECT SUM(…)
FROM (table name)
WHERE …;

Question 12

What is a unique Id

Answer 12

A unique identifier which is different for each record of a table