CompSci Databases & SQL

Which of these is required of a Primary Key?

• Easy to recognise
• Unique
• Short
• A number

When a table contains the primary key from another table, this is…

• A foreign key
• A secondary key
• A tertiary key
• A primary key

Tables are linked together by

• Lines
• Links
• Relationships
• Hyperlinks

Relationships can be

• One-to-one
• One-To-Many
• Either

SQL stands for

• Stratified Query Language
• Structured Query Language
• Strategic Query Links
• Standard Query List

Which SQL query finds information in a DB?

• UPDATE
• DELETE
• INSERT
• SELECT

Which SQL query changes information in a DB?

• UPDATE
• DELETE
• INSERT
• SELECT

Which SQL query removes information from a DB?

• UPDATE
• DELETE
• INSERT
• SELECT

Which SQL query adds new information to a DB?

• UPDATE
• DELETE
• INSERT
• SELECT

Which SQL keyword would you see if there was a relationship?

• INNER JOIN
• REL
• RSHIP
• LINK