Font size
WorksheetsGraded Unit 1 Revision
Total questions: 50
Worksheet time: 30mins
What is cascade update?
Feature selected at same time as referential integrity allowing information to be deleted across tables in a relationship.
Allows changes made to the foreign key in the child table to ripple through to the primary key in the parent table
Feature selected at same time as referential integrity allowing a degree of amendment to tables within a relationship.
Allows changes made to the primary key in the parent table to ripple through to the foreign key in the child table
Which of the following statements is not true of a Macro.
cuts down time taken to key in data
It can eliminate errors
useful tool when inputting repetitive data
can be assigned a CTRL key
When applying Referential Integrity ONLY to a relationship within a database, which of the following statements is possible?
A record in the parent table can be deleted along with its associated records in the child table
A record in the primary key field in the parent table can be changed and any change will be replicated in the associated record of the foreign key field in the child table
The foreign key field of a record in the child table can be altered as long as there is not an associated record in the primary key field of the parent table
The foreign key field of a record in the child table can be altered to another foreign key entry as long as there is an associated primary key entry for this foreign key in the parent table
In spreadsheets calculations are performed in a particular order, which of the following statements describes that order?
Everything in brackets, addition, subtraction, division and multiplication,.
division, multiplication, everything in brackets, addition, subtraction
addition, subtraction, everything in brackets, division, multiplication
Everything in brackets, division, multiplication, addition and subtraction.
Which of the following are used for data input in a database?
Form
Query
Report
Table
A form in a database can be used to:
Extract Information
Analyse information
Enter, edit and delete information
Sort information
The standard deviation functions =STDDEV.P()
how widely values are spread from the mean based on entire population
how widely values are spread from the mean based on a sample
the average figure from a range of figures
the most common occurence of a figure from a sample
The platform Redditt is most useful for:
online chat
providing video chat and voice calls between computers
an online social media and social networking service
allowing users to vote on content other users have submitted
Which of the following relationships can exist within a database?
One to many
One to one
Many to many
many to one
Which of the following is not an App that can be used for setting up meetings?
Outlook mobile App
Cloud App for Business
My Office App
My Dream Diary App
This pie chart displays the following:
Four data series with dogs being the smallest proportion.
One data series with Fish being the largest proportion.
Four data series with Fish being the largest proportion.
One data series with cats being the largest proportion.
Which statement is accurate. A foreign key field:
Contains unique information.
Contains same information as the primary key field but data is duplicated.
Allows a link to be created between 2 tables.
Field that contains numbers only.
What is the name of an application that appears to look like a helpful application but instead does harm to your computer?
virus
worm
malware
Trojan horse
Someone was recently caught sifting through your company's trash looking for confidential information. What is this an example of?
trash snooping
Dumpster diving
phishing
social engineering
What is it called when a co-worker sitting next to you always seems to look your way when you try to enter your user ID and password to log onto the network?
phishing
social engineering
Shoulder surfing
coincidence
You receive an email from your bank,telling you that your account has been compromised and you need to validate your account details or else your account will be closed. You are supposed to click a link to validate your information. what is this an example of?
a security breach at your bank that needs to be resolved
spam
ransomware
Phishing
Which of the following is not an advantage of networking?
Security from viruses and unauthorised access.
Ability to share files and printers
Ability to move the same user account between different computers
Obtaining site license software at reduced cost compared to buying multiple copies.
Under the HASAWA 1974, employers do not have a duty to?
Provide lunch vouchers to all employees
Provide safe systems of work
Provide adequate equipment
Provide a safe place of work
A person, place, thing, or event about which data will be collected and stored.
Database
Table
Record
Entity
An attribute in one table whose values must match the primary key in another table.
Foreign Key
Primary Key
Entity integrity
Referential integrity
States that table relationships must be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key.
Foreign Key
Primary Key
Entity integrity
Referential integrity
Which statement is not true of Backups :
Should be kept off-site for security reasons
Should be carried out by the user themselves
Should be carried out by the Network manager
Should only be done when it is important data
A database report is useful as it is?
used to store data
used to extract data based on specific criteria
able to provide summarised statistical data
used to add extra information to ensure that the end user is able to interpret
Adding transition to a slide show:
allows text to be animated
allows timings to be added between slides
allows objects to be animated
animates the appearance of a slide during slideshow
You are carrying out research about financial software for the accounting team. Which of the following sources of information would likely be unbiased?
Search engines
Specialist magazines
Vendor websites
Retail outlets
