SQL

Question 1

What SQL datatypes could be used for a fractional number?

Answer 1

FLOAT

REAL

Question 2

What SQL datatypes can be used for dates and time

Answer 2

DATE
TIME
DATETIME

Question 3

What is one way of defining a customer ID (int) value?

Answer 3

CustomerID INT PRIMARY KEY

Question 4

What are the main clauses of a select query?

Answer 4

SELECT
FROM
WHERE

Question 5

What symbol denotes all fields in a table?

Answer 5

*

Question 6

What clause orders items?

Answer 6

ORDER BY

Question 7

Write a query to select all fields from a sales table where value is more than £500

Answer 7

SELECT * FROM SALES WHERE Value > 500;

Question 8

What is the format to add values into a SQL table

Answer 8

INSERT INTO VALUES ;

Question 9

What are the main clauses of an update query?

Answer 9

UPDATE
SET
WHERE