WorksheetsGCSE Computer Science: Software inc. OS, Utility, Apps & SQL
Total questions: 25
Worksheet time: 25mins
What is the purpose of an Operating System?
To manage the computer resources including memory and resources.
To protect a computer against unauthorised access and/or data.
To protect a computer from malware such as viruses.
To reduce the size of files so that more information can be stored on the HDD or SSD.
What is the purpose of a Firewall?
To manage the computer resources including memory and resources.
To protect a computer against unauthorised access and/or data.
To protect a computer from malware such as viruses.
To reduce the size of files so that more information can be stored on the HDD or SSD.
Utility Software aims to improve the performance of your computer.
True: Utility Software is the same as cachee
False: Utility Software makes a computer run much slower.
True: Utility Software carries out back-ups and compression of data.
False: Utility Software uses up all of a computers RAM on useless information.
Which of the following is NOT a feature of File Management?
File Management enables the end user to create, modify, copy, delete and move files.
File Management enables the end user to search for a particular file.
File Management enables the end user to keep track of free space on the disk.
File Management enables the end user to move separated files into one file on the HDD or SSD.
A school network manager needs to back-up the computers before half term. Which type of back-up is best to use?
Grandfather back-up
Child back-up
Incremental back-up
Full back-up
What is the purpose of an Archive?
To store data that is not needed on a regular basis.
To copy all data on a computer or network that can be restored in case of a disaster.
To copy all the changes that are made to files on a computer or network.
To permanently delete all data on a computer or network.
The Operating System provides a GUI. What does GUI stand for?
Graphical User Interface
Golden User Interface
Graphical Ultimate Interface
Graphical User International
What is the main advantage of a GUI?
It is easy to use and intuitive.
It takes up a small amount of memory.
It is takes up a large amount of memory.
It uses voice recognition.
What are the main disadvantages of Command Line Interface?
It takes a large amount of memory.
It is very quick to use once you have learnt the key terms.
It is intuitive and easy to use.
You need to learn the key terms to be able to use it efficiently.
Which of the following is an example of a Menu Interface?
A booking system for cinema tickets.
An Alexa Smart speaker.
An iPad.
Windows 10
What is the best definition for Application Software?
A computer program designed to reduce the size of files, for example WinZip.
A computer program designed to complete a specific task, for example spreadsheet software.
A computer program designed to manage the computer's resources and provide a user interface.
A computer program aimed at protecting the system from viruses, for example Anti-virus software.
What is the main purpose of a Word Processor?
Manipulate numerical data and create graphs.
Store large amounts of data, sort and search the data.
Refine, edit and create images.
Create, edit and amend typed documents such as letters, reports and memos.
What is the main purpose of a Spreadsheet?
Manipulate numerical data and create graphs.
Store large amounts of data, sort and search the data.
Refine, edit and create images.
Create, edit and amend typed documents such as letters, reports and memos.
What are the golden rules when creating a database?
Data must not be repeated, redundant and fields must be reduced in size.
Data must be stored in alphabetical order.
Data must be sorted into decending order.
Data must be repeated, redundant and reduced in size.
What is a Primary Key?
A unique identifier within a database, for example StudentID
A function to add all the cells within a spreadsheet, for example =sum(B2:B4)
All the details stored about one entity, for example The DVLA will have records of cars on the road in the UK.
A single piece of information within a database, for example, FirstName
What is a 'field' in a database?
A unique identifier within a database, for example StudentID
A function to add all the cells within a spreadsheet, for example =sum(B2:B4)
All the details stored about one entity, for example The DVLA will have records of cars on the road in the UK.
A single piece of information which forms part of a record, for example, FirstName
What is the correct formula to calculate the total of a group of cells?
=SUM( : )
=AVERAGE( : )
=MAX( : )
=MIN( : )
What is the correct formula to find the highest value in a group of cells?
=SUM( : )
=AVERAGE( : )
=MAX( : )
=MIN( : )
What is the correct formula to find the lowest value in a group of cells?
=SUM( : )
=AVERAGE( : )
=MAX( : )
=MIN( : )
What does SQL stand for?
Structured Query Language
Structured Question Language
Standard Query Language
Standard Question Language
What is the correct SQL statement to find all the details in a table called TB_Students21 of the students called Josh?
SELECT * FROM TB_Students21 WHERE FName = 'Josh';
SELECT SName FROM TB_Students21 WHERE FName LIKE 'Josh';
FIND all IN TB_Students21 called 'Josh';
SELECT * FROM TB_Students21 WHERE == Josh;
What is the correct SQL statement to find the FName and SName in a table called TB_Students21 of the students whose first name begins with J?
SELECT * FROM TB_Students21 WHERE FName = 'J';
SELECT SName, FName FROM TB_Students21 WHERE FName LIKE 'J%';
FIND all IN TB_Students21 if FName begins with 'J';
SELECT * FROM TB_Students21 WHERE FName LIKE '*J;
What is the correct SQL statement to find all the details in a table called TB_Students21 of the students whose ExamMark is higher than 80?
SELECT * FROM TB_Students21 WHERE ExamMark>80;
SELECT SName, FName FROM TB_Students21 WHERE ExamMark <80;
FIND all IN TB_Students21 if ExamMark begins with 'J';
SELECT * FROM TB_Students21 WHERE ExamMark = 80;
What does the following SQL statement do: "CREATE Table myContacts (name, age, email)"
Creates a new table called myContacts.
Inserts name, age and email into a table called myContacts.
Deletes all data from a table called myContacts
Searches for all the data in myContacts.
What does the following SQL statement do: "DROP Table if EXISTS myContacts"
Creates a new table called myContacts.
Inserts name, age and email into a table called myContacts.
Deletes all data from a table called myContacts
Searches for all the data in myContacts.
