Database Knowledge Check 3 (SQL)

What does SQL stand for?

• Standard Query Listing

• Select Query Language

• Structured Query Language

• Structured Query Listing

What is SQL?

• a programming language used to manipulate databases

• the method of designing tables in a database

• the method of linking tables in a database

• the Primary Key which gives a unique ID to each record

Why might large companies use a SQL server rather than MS Access?

• database size is much larger and more users can be on at the same time

• no training is required to use it

• database size is much smaller and only one person can use it at a time

• there is no need to use MS Access at all

SQL is used to create

• forms

• tables

• queries

• reports

What is the the order that SQL processes instructions?

• Order- Where - From - Select

• Select - Order - From - Where

• Select - From - Where - Order

• From - Order - Where - Select

What does the 'Insert Into' statement in a query enable?

• makes changes to values held in fields

• add a new record to the table

• removes a record permanently from the table

• create a new query

What does the 'Update' statement in a query enable?

• makes changes to values held in fields

• add a new record to the table

• removes a record permanently from the table

• create a new query

What does the 'Delete From' statement in a query enable?

• makes changes to values held in fields

• add a new record to the table

• removes a record permanently from the table

• create a new query

Which is the correct SQL statement to show all fields and all records from a table called 'Holiday'?

• SHOW * FROM Holiday;

• SELECT ALL FROM Holiday;

• SELECT FIELDS and RECORDS FROM Holiday;

• SELECT * FROM Holiday;

What effect would the following SQL statement have:

DELETE * FROM Holiday;

• removes the last record from the Holiday table

• removes all records from the Holiday table

• inserts a new record in the Holiday table

• enables the user to edit a record in the Holiday table