NEW
Font size
WorksheetsSQL & Normalisation
Total questions: 18
Worksheet time: 9mins
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
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
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies
A table is in 2NF if the table is in 1NF and what other condition is met?
There are no functional dependencies.
There are no null values in primary key fields.
There are no repeating groups.
There are no attributes that are not functionally dependent on the relation's primary key.
Which of the following best defines referential integrity in the context of databases?
A foreign key must correspond to a valid/existing primary key in another table.
All data must be stored in a single table.
Every table must have only one column.
Data must be encrypted at all times.
According to the rules of third normal form (3NF), what must all non-key attributes be dependent on?
The key, the whole key, and nothing but the key.
Any attribute in the table.
Only the foreign key.
The first attribute in the table.
What is the solution when partial key dependencies exist in a table that is being normalised to 2NF?
Remove these fields into a new table with a copy of the dependent part primary key.
Delete all non-key attributes.
Merge all tables into one.
Remove the primary key from the table.
Why is it important for a table in 3NF to have no transitive dependencies?
To ensure that all data is stored in a single table.
To prevent non-key attributes from depending on other non-key attributes, which improves data integrity.
To allow for more duplicate data.
To make the table easier to read.
Which of the following statements best describes a table in First Normal Form (1NF)?
All attributes are atomic and there are no repeating groups of attributes.
All attributes are composite and there are repeating groups of attributes.
All attributes are dependent on a non-key attribute.
All attributes are foreign keys.
