Databases and SQL

Question 1

Give the format for creating a table.

Answer 1

CREATE TABLE (name)
(
Attribute1, INT(numDigits), PRIMARY KEY
Attribute2,VARCHAR(numCharacters)/TEXT, FOREIGN KEY
Attribute3, DATE
)

Question 2

Give the format for adding values into a table.

Answer 2

INSERT INTO (name)
VALUES (‘value1’,’value2’,’value3’),
(‘value4’,’value5’,’value6’)

Question 3

Give the format for updating values in a table.

Answer 3

UPDATE (name)
SET (Attribute2) = ‘value3’
WHERE (Attribute1) = ‘value1’

Question 4

Give the format for deleting values in a table.

Answer 4

DELETE FROM (name)
WHERE (Attribute1) = ‘value1’

Question 5

Give the format for selecting items/values.

Answer 5

SELECT *(everything) / (Attribute1), (Attribute2)
FROM (name)
WHERE (Attribute1) = ‘value1’ / > (value2)
ORDER BY (Attribute3) DESC # default is ascending

Question 6

Give the line for selecting the first value from the first entity found.

Answer 6

SELECT DISTINCT (Attribute1)

Question 7

What is the format for DATE?

Answer 7

YYYY-MM-DD

Question 8

What is the format for TIME?

Answer 8

HH:MM:SS

Question 9

What is the definition of a primary key?

Answer 9

An attribute/field which uniquely identifies a record.

Question 10

What is the definition of a foreign key?

Answer 10

A attribute/field in one table which refers to the primary key in another table.