N5 Computing Science - DDD Exam Questions

Quiz
•
Computers
•
10th Grade
•
Medium
Calum Gordon
Used 3+ times
FREE Resource
36 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
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
2.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A pottery shop’s database allows users to choose a type of plate, as shown.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Create a free account and access millions of resources
Similar Resources on Wayground
40 questions
MID Sem 5 PWPB XIIRPL

Quiz
•
2nd Grade - University
37 questions
SELECT W SQL

Quiz
•
10th Grade - University
35 questions
Class X IT-402

Quiz
•
10th Grade
33 questions
N5 Database Design Revision Quiz

Quiz
•
10th Grade
40 questions
Web Programming Structural

Quiz
•
10th Grade
40 questions
PPE review CS Dec 2020

Quiz
•
10th - 11th Grade
40 questions
SKT4 : Bab 2 : c) Medan, Rekod, Jadual & Kekunci

Quiz
•
10th - 12th Grade
35 questions
H5 - 35 begrippen - oefening

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade