AQA A Level · Computer Science 7517

Relational databases: Practice Questions

5 multiple-choice questions marked as you go, and 5 written questions with worked solutions. All on Relational databases.

10 questions17 marksFree, no account

Question 1

1 mark

Which SQL keyword is used to add a new record to a table named Products?

Question 2

1 mark

Which SQL command would be used to change the Price of all items in the Stock table where the CategoryID is 5?

Question 3

1 mark

A database designer discovers that a table has a transitive dependency, where a non-key attribute is dependent on another non-key attribute.

What must be done to bring this table into Third Normal Form (3NF)?

Question 4

1 mark

Which of the following defines a foreign key in a relational database?

Question 5

1 mark

When two different users attempt to update the same record in a client-server database simultaneously, a problem known as a 'lost update' can occur.

Which mechanism is most commonly used to prevent this by ensuring only one user can edit a record at a time?

Question 6

2 marks

Define the term composite primary key.

Write your answer out first, then check it against the worked solution.

Question 7

3 marks

A database designer uses a foreign key. What is the specific purpose of this attribute in terms of relational integrity?

Write your answer out first, then check it against the worked solution.

Question 8

2 marks

In a relational database, what is the term for a single row within a table?

Write your answer out first, then check it against the worked solution.

Question 9

3 marks

Define the term Composite Primary Key and provide a specific example of a table structure where a composite primary key would be necessary.

Write your answer out first, then check it against the worked solution.

Question 10

2 marks

Explain the concept of a Foreign Key in a relational database and describe its primary purpose in maintaining data integrity.

Write your answer out first, then check it against the worked solution.

* The content provided by thinka is generated by AI and may not always be accurate or up-to-date. Please use it as a supplementary resource and verify with official materials.

You've seen the model answer. Now get yours marked.

This page can show you how a good answer looks. It cannot tell you what your answer was missing. thinka marks your written work against the real mark scheme in about 15 seconds.

Get My Answers Marked Back to the notes

Want more questions like these? Get a fresh set on this topic, marked as you go.