Database Design and Development (Implementation)

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

In SQL, what is used to mean “all”?

Answer 2

• (asterisk)

Question 3

What command is used to search a database for information generally?

Answer 3

SELECT field(s) FROM table(s);

eg SELECT firstName FROM pupils

Question 4

What command is used to search a database for more refined information?

Answer 4

SELECT field(s) FROM table(s)
WHERE field = description;

eg. SELECT firstName FROM pupils
WHERE firstName = “Darren”;

Question 5

What syntax is used to search a database of more than one condition?

Answer 5

AND / OR / NOT

eg. SELECT firstName FROM pupils
WHERE firstName = “Darren” OR firstName = “Ian”;

Question 6

What syntax is used to search a database of numbers between two extremes?

Answer 6

< / > / = / <= / >=

eg. SELECT firstName FROM pupils
WHERE age > 9

Question 7

What are the two ways of ordering fields in a database and what is their syntax in SQL?

Answer 7

Ascending / ASC (Orders a field from lowest to highest)

Descending / DESC (Orders a field from highest to lowest)

Question 8

What command is used to order a database?

Answer 8

SELECT feild(s) FROM table
ORDER BY field (ASC / DESC)

eg. SELECT firstName FROM pupils
ORDER BY firstName ASC

Question 9

What is the maximum number of fields a database can be ordered by?

Answer 9

2

Question 10

What command is used to add information to a database?

Answer 10

INSERT INTO table
VALUES (new values in order with commas separating them)

eg. INSERT INTO pupil
VALUES (077868, Darren, O’Hare, Maths, 15)

Question 11

What command is used to add information to a database if we only want to add information to specific fields?

Answer 11

INSERT INTO table
VALUES (new value, new value, new value)

eg. INSERT INTO pupil
VALUES (077868, Darren, Maths)

Question 12

What command is used to rectify incorrect information of a database?

Answer 12

UPDATE table
SET field = “new value”
WHERE field = “old value”

eg. UPDATE pupil
SET firstName = “Adam”
WHERE firstName = “Darren”