NEW
Font size
S
M
L
XL
WorksheetsICT 2.3.17
Total questions: 16
Worksheet time: 8mins
Name
Class
Date
1.
What does Normalisation allow a database designer to do?
a)
Design their database efficiently, removing the chance of redundancy and inaccuracies.
b)
Remove additional records from the tables.
c)
Add as much data as they like.
d)
Draw an ERD.
2.
To be in 2NF:
a)
Each non-key field relates to the primary key
b)
There are multiple entries in the same field
c)
There are no foreign keys
d)
All numbers are in decimal form
3.
Which of these is not an advantage of peer to peer compared to client server?
a)
You need a network manager
b)
It is relatively easy to set up
c)
Lower operating costs - less set-up and maintenance costs.
d)
No reliance on a server
4.
Which of these is not an advantage of a client server network compared to peer to peer?
a)
Back ups can be done centrally
b)
Load tolerant - suitable for large networks
c)
Centrally stored files are easier to find
d)
If server breaks down the network is unusable
5.
Which of these advantages of a relational database over flat file does NOT relate to security?
a)
Hierarchy of passwords
b)
Access rights to parts of the program
c)
Reduced data redundancy
d)
Storage of data separate to programs
6.
منى طالبة بالصف الثاني عشر وحصلت على معدل 87% هذه الجملة تعتبر
a)
بيانات
b)
معلومات
c)
قاعدة بيانات
d)
غير مفهومة
7.
Which of these advantages of a relational database over flat file does NOT relate to security?
a)
Hierarchy of passwords
b)
Access rights to parts of the program
c)
Reduced data redundancy
d)
Storage of data separate to programs
8.
What is this a definition for? A ??????? has data stored on a number of computers at different locations but appears as one logical database.
a)
Distributed computing
b)
Data Warehouse
c)
Distributed database
d)
Data Mining
9.
Which of these is NOT an advantage of a distributed database?
a)
Heavy reliance on networks
b)
If one server fails then other servers can be used
c)
Reduces network traffic as local queries can be performed using the data on the local server
d)
Faster response to user queries on the database
10.
Which of these is NOT an advantage of video conferencing to an organisation?
a)
Experts don't waste time travelling
b)
Cost of dedicated video conferencing equipment is expensive to buy
c)
Allows staff to attend a meeting while out of the country
d)
Allows meetings to be called at short notice
11.
Which of these is NOT a disadvantage of teleworking to employees?
a)
Smaller offices are needed
b)
Home costs such as lighting, heating increase
c)
Boundary between home and work is lost
d)
May feel isolated
12.
Which of these is NOT an advantage of teleworking to the employer?
a)
Smaller offices are needed
b)
Can employ workers from a wider pool of talent
c)
Staff less likely to spend time off sick
d)
Hard to determine how hard staff are working
13.
Which of these is NOT an example of a problem that may breach the 'Security of data' section of a code of conduct?
a)
Installing software on more pcs than the company has a license for
b)
Sharing a password with a colleague
c)
Leaving your computer logged on when away from desk
14.
Which of these is NOT an example of a problem that may breach the 'Complying with licensing agreements' section of a code of conduct?
a)
Installing software on more pcs than the company has a license for
b)
Taking software home to install on your home pc
c)
Accessing information you are not allowed to about a customer
15.
There are legal and moral issues with respect to a code of conduct. Which of these is legal?
a)
Not fully informing potential customers about all the facts
b)
Estate agent putting false information on adverts
c)
Monitoring company emails
16.
Which legal act deals with unauthorised access
a)
Data Protection Act
b)
Computer Misuse Act
c)
Copyright Designs and Patents Act
Reset
