Databases (Paper 2)

Question 1

What is a primary key?

Answer 1

A unique identifier for the records of the table

Question 2

What are records in a table?

Answer 2

The rows

Question 3

What are fields in a table?

Answer 3

Columns

Question 4

What does SQL stand for?

Answer 4

Structured query language

Question 5

What is the format of an SQL statement?

Answer 5

SELECT …
FROM ….
WHERE ….
ORDER BY ….

Question 6

What is the format of an SQL statement when doing a count statement?

Answer 6

SELECT COUNT(….)
FROM ….
WHERE

Question 7

What is the format of an SQL statement when doing a sum statement?

Answer 7

SELECT SUM(….)
FROM ….
WHERE ….

Question 8

Which validation rules can you use on fields in a datatbase?

Answer 8

-Length check
-Format check
-Range check
-Presence check