N5 Computing Science - DDD Exam Questions

Choose two implications of the General Data Protection Regulation for a business

that stores the personal details of its staff

• data must be held securely

• data can only be used for

  declared purposes

• data must be compressed

• data can not be stored for more than 10 years

A pottery shop’s database allows users to choose a type of plate, as shown.

A pottery shop’s database allows users to choose a type of plate, as shown.

What is the main advantage in using this type of validation?

• Eliminates input errors

• Faster input time

• Capitalises each option for you

• Options are presented to user

Angela works in a cycle shop. She decides to create a database to storeinformation on staff and bikes. This would make it easier to record which staff member prepared each bike for sale.

Following implementation of the database, the ‘Bike’ table shown contains 11 records.

Angela notices data entry errors. The two Raleigh Cameo bikes have 8 gears and not 7 as entered in the database.

She writes the following SQL statement to correct these errors.

UPDATE Bike

SET gears = 7

WHERE make = “Raleigh”

Explain why Angela’s SQL statement would not correct these errors.

• Gears have not been changed to 8

• It would also update the other Raleigh models

• It does not mention Cameo model

• There is no FROM statement

Angela works in a cycle shop. She decides to create a database to storeinformation on staff and bikes. This would make it easier to record which staff member prepared each bike for sale.

Following implementation of the database, the ‘Bike’ table shown contains 11 records.

Angela notices data entry errors. The two Raleigh Cameo bikes have 8 gears and not 7 as entered in the database.

She writes the following SQL statement to correct these errors.

UPDATE Bike

SET gears = 7

WHERE make = “Raleigh”

Explain why Angela’s SQL statement would create additional errors in the database.

• All Raleigh bikes now have seven

  gears

• Would create duplicate records of all Raleigh bikes

• Would delete all records for Raleigh bikes

• All bikes now have seven gears

Angela works in a cycle shop. She decides to create a database to storeinformation on staff and bikes. This would make it easier to record which staff member prepared each bike for sale.

Following implementation of the database, the ‘Bike’ table shown contains 11 records.

Angela notices data entry errors. The two Raleigh Cameo bikes have 8 gears and not 7 as entered in the database.

She writes the following SQL statement to correct these errors.

UPDATE Bike

SET gears = 7

WHERE make = “Raleigh”

Explain why Angela’s SQL statement would create additional errors in the database.

• All Raleigh bikes would now have seven gears

• Would create duplicate records of all Raleigh bikes

• Would delete all records for Raleigh bikes

• All bikes would now have seven gears

Angela works in a cycle shop. She decides to create a database to storeinformation on staff and bikes. This would make it easier to record which staff member prepared each bike for sale.

Following implementation of the database, the ‘Bike’ table shown contains 11 records.

Angela wishes to remove the following bike from the database.

Serial Number: 30X76543 Make: Boardman Model: CX Team 14 Type: Road

Gears: 20

Evaluate the effect of running the SQL statement below:

DELETE FROM Bike

WHERE make = “Boardman” AND model = “CX Team 14”;

• two records deleted instead of one

• four records deleted instead of one

• no records deleted

• all records are deleted

Angela works in a cycle shop. She decides to create a database to storeinformation on staff and bikes. This would make it easier to record which staff member prepared each bike for sale.

Following implementation of the database, the ‘Bike’ table shown contains 11 records.

Angela wishes to remove the following bike from the database.

Serial Number: 30X76543 Make: Boardman Model: CX Team 14 Type: Road

Gears: 20

Angela uses the SQL statement below:

DELETE FROM Bike

WHERE make = “Boardman” AND model = “CX Team 14”;

Which is a better solution Angela could use to remove the bike from the database?

• include the serial number in the WHERE line

• Include the type in the WHERE clause

• Include the gears in the WHERE line

• Inc;ude the employeeNUmber in the WHERE line

Scot Cars (a second-hand car company) has branches located in five different Scottish towns and cities. They maintain a database of all cars they have in stock. Some of the records from the relational database are shown below.

Scot Car’s relational database contains primary and foreign keys.

What is the purpose of a foreign key in a relational database?

• To link two tables

• To link two fields

• To link two records

• To link two primary keys

Scot Cars (a second-hand car company) has branches located in five different Scottish towns and cities. They maintain a database of all cars they have in stock. Some of the records from the relational database are shown below.

Complete the table to identify the keys that were created when this relational database was implemented.

Primary key: Table=​ (a)   Field=branchNumber

Primary key: Table=​ (b)   Field=​ (c)  

Foreign key: Table=Car Field=​ (d)  

• Branch
• Car
• branchNumber
• registration
• street
• mileage
• postcode
• dateFounded
• make
• model