SQL & Normalisation

In order to amend data in a database we would use which SQL statement?

• Update

• Amend

• Alter

• Modify

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

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

What is the correct order of clauses in a SQL statement?

• SELECT, FROM, ORDER BY, WHERE

• SELECT, FROM, WHERE, ORDER BY

• SELECT, WHERE, FROM, ORDER BY

• WHERE, FROM, SELECT, ORDER BY

What is a field?

• A collection of information

• A single item of information

• A list of information

• A group of records

What does Normalisation allow a database designer to do?

• Design their database efficiently, removing the chance of redundancy and inaccuracies. 
• Remove additional records from the tables. 
• Add as much data as they like. 
• Draw an ERD. 

Which of the following is NOT a requirement of 1NF?

• It should only have single (atomic) valued attributes/columns.

• a Primary Key

• One item of data per column in one row (i.e. no repeating data)

• Data should be sorted in order

Which of the following is NOT a requirement of 2NF?

• No One-Many relationships

• The data should be in 1NF

• No partial dependencies

• No One-Many relationships

What is a key characteristic of Second Normal Form (2NF)?

• It requires that all non-key attributes are fully functionally dependent on the primary key

• It eliminates all duplicate columns from the table

• It requires that all tables have a single primary key

• It ensures that all data is stored in a single table