Databases and SQL for Grade 10 IT

A Primary key is ... (tick all that apply)

• a record which is unique

• a field that uniquely identifies a row in a table

• a key that unlocks a database

We need Primary Key's because ... (pick most correct answer - not vague, and must be relevant to today's topic!)

• There may be 2 items with the same name in a table

• It avoids us making mistakes

• Keys help us unlock doors

The right datatype for a name is ...

• Short text

• Long text

• Date / Time

• Number

The right datatype for quantity of items in stock is ...

• number

• short text

• OLE Object

• Currency

The right datatype for a date of purchase is ...

• Date/time

• Long text

• short text

• OLE Object

The right datatype for a description of an item (>255 characters) is ...

• Long text

• Short text

• OLE Object

• Yes/No

SQL Queries ...

• allow us to obtain exactly the data we want from a Database

• allow us to chase and harang a Database

• are not very useful

• are a big hype and SQL is overrated

The first two lines of a SQL query are:

• SELECT <field(s)>

  FROM <table>

• GRAB <field(s)>

  FROM <table>

• GET <field(s)>

  FROM <table>

• EXTRACT <field(s)>

  FROM <table>

SELECT * FROM <table>

will give us ...

(pick all that apply)

• All the fields

• The first field

• No fields

• All the records

SQL is case sensitive

• True

• False