GCSE Databases & SQL

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

What does “SQL” stand for?

• Standard Query Language.
• Structured Query Language.
• Structured Quick-access Language.
• Standard Questioning Language.

What does a Relationship do within a database?

• It reduces data redundancy by linking fields in different tables.
• It shows which users in a database are related.
• It increases data redundancy by linking fields in different tables.
• The fields are the vertical columns in a table.

What is data redundancy?

• Data that is repeated multiple times.
• Data that is safe from SQL attacks.
• Data that is weak to SQL attacks.
• Data that has no use anymore.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName<>'Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

What word is missing from the line below?

SELECT * _______ CUSTOMER WHERE Name = "Bob";

• FROM

• WHERE

• SELECT

• ORDER BY

To remove a record from a table which SQL statement would you use?

• Remove

• Cancel

• Delete

• Eradicate

Which statement allows us to add a record to a table?

• Add To

• Update To

• Add Into

• Insert Into

Less than or equal to?

• >=

• =>

• =<

• <=

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456')

• INSERT VALUES ('SMI01', 'M Smith', '[e-mail]', 01224123456') INTO Designer

• INSERT ('SMI01', 'M Smith', '[e-mail]', '01224123456') INTO Designer

• INSERT Designer INTO VALUES (''SMI01', 'M Smith', '[e-mail]', '01224123456')