Databases

Question 1

What is the SQL for update?

Answer 1

UPDATE Player (Table)
SET (what ur changing)TelNo=“029822223”, Allergies = True
WHERE(what ur doing) Fullname = “Tara Nwolum”

Question 2

What is the SQL for Delete?

Answer 2

DELETE FROM Player
WHERE Number “0976728824” AND Address “2 Tambour”

Question 3

What is the SQL for Insert?

Answer 3

INSERT INTO product (productName,productCode,nO)

VALUES “screwdriver”,”SC11”,31)

Question 4

What is the point in of GDPR?

Answer 4

To make sure that the personal data is kept safe

Question 5

What is a field?

Answer 5

The name of each column in a database (e.g., “First_Name”)

Question 6

What is a data type?

Answer 6

Text, Number, Date

Question 7

What is size?

Answer 7

Rules that check if the data is correct

Question 8

What is validation?

Answer 8

Rules that check if the data is correct

Question 9

What is presence check?

Answer 9

Checks that a field is not left empty.

Question 10

What is restricted choice?

Answer 10

Limits input to a set of predefined options.

Question 11

What is range check?

Answer 11

Ensures a number is within a certain range.

Question 12

What is a length check?

Answer 12

Ensures input is a certain number of characters long

Question 13

What is the SQL for Select?

Answer 13

SELECT name ,teamname (field)

FROM players , team (tables)

WHERE position = “goalkeeper”
AND players.teamid=team.teamid

ORDER BY DESC