SQL & Relational Data Bases

Question 1

SQL definition

Answer 1

structured query language is used to communicate with a database. SQL is used to manipulate databases and retrieve records

Question 2

SELECT query

Answer 2

used to retrieve records from a data table

Question 3

UPDATE query

Answer 3

used to manipulate records that already exist in a data table and change the values

Question 4

INSERT query

Answer 4

used to add additional records into a data table

Question 5

DELETE query

Answer 5

Used to remove records from a data table

Question 6

Show how to: retrieve all records from TBLPRODDUTS data table

Answer 6

SEECT *
FROM tblProducts;

Question 7

Show how to: retrieve the item,price and description fields from tblproducts when using the searchterm of ‘‘toy’’

Answer 7

SELECT item , price , descrition
FROM tblproducts
WHERE searchterm = ‘‘toy’’;

Question 8

Show how to: change the password for employeeID 8 in the TBLEMPLOYEES data table

Answer 8

UPDATE tblemployees
SET password = ‘‘H%3nuAF$2’’
WHERE employeeID = 8;

Question 9

Show how to: add a new record into the tblFriends table for firstname Rachel and surname Green

Answer 9

INSERT INTO(firstname,surname)
VALUES(‘‘Rachel’’ , ‘‘Green’’)

Question 10

Show how to: remove all the student records in tblstudents but only when students are older than 31/08/2005

Answer 10

DEETE FROM tblstudents
WHEER DOB <31/08/2005