ISDD Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Describe the structure of a database?

A

Databases contain tables, these tables contain records which is all the data stored about one object, the records contain fields which is a single piece of information on the object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the advantages of a relational database?

A

avoid unnecessary duplication of data

tables are linked so data only needs to be changed once

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the purpose of primary, surrogate, foreign and compound keys?

A

Primary key is a unique identifier for a record
A surrogate key is a field in a table which has been created to ensure a unique field exists
A foreign key is used to link fields together in different databases
A compound key combines more than one field in order to make a unique value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the purpose of tables, forms and reports?

A

tables display large amounts of data on the one screen
A form is graphical and displays one record at a time
A report is used to arrange data into an easy to read or print format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is meant by a relationship in a database?

A

a relationship is when one or more entity is associated with each other

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a calculated field?

A

A calculated field is one which is created using a query which calculates a result from one or more existing fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How can websites be structured?

A

Websites can be structured in a linear format or in a hierarchical format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What will all websites contain?

A

Head, title and body

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What do style sheets allow us to do?

A

Style sheets allow us to separate the look and feel of a web page from its content and structure.
Make sure pages on a web page are consistent in appearance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How can web pages be structured into different sections?

A

Using , and

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What does CSS stand for and what is it used for?

A

Cascading style sheets

is a standard way of implementing style sheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does CSS consist of?

A

Consists of rules they are made up of a selector and a group of attributes called the declaration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Where is metadata found?

A

Metadata is found in the head section of a webpage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is Metadata used for?

A

Metadata is used to give information about a webpage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are static web pages and what is a dynamic web page?

A

A static web page does not change every time they are viewed

A dynamic web page contains information which will change each time the page is loaded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is an interactive web page?

A

An interactive web page is one that requires the user to click on buttons or other elements in order to interact

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is a database driven website?

A

A database driven website is a dynamic web page which allows users to search through stored information.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a standard file format?

A

A standard file format is one which will open and display correctly on all platforms?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Why is compression necessary and what its advantages?

A

Media files can be very large.
allows more files to be stored on to backing storage
files will be faster to transmit and download over the internet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is compressions job?

A

Compression is used to reduce the size of files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Explain the difference between lossless and lossy compression?

A

lossless reduces file size but does not lose any information. lossy reduces file size but loses information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

How can the size of sound files be reduced?

A

Croppping
Lowering sampling depth
lowering sampling frequency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

How can the size of graphics files be reduced?

A

Cropping
lowering resolution
changing colour depth

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

How can the size of video files be reduced?

A

Shorten length
altering resolution
reducing the frame rate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What is the two types of video compression and explain them?

A

Inter-frame and intra-frame compression.
Inter-frame stores the information which changes between each frame after storing a reference frame.
Intra frame treats each frame as a bitmapped graphic and uses graphic compression techniques

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What can a scripting language be used for?

A

A scripting language can be used to automate a complicated process, automate a repetitive action, create macros or to add functionality to an application
can also be used to add interactive features to a web page

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What is a script and what does it provide?

A

A script is code for a website that allows changes every rime the web page is visited.
A script also provides interactivity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is client side scripting?

A

Client side scripting is where the code for the scripts are executed on the users computer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What is server side scripting?

A

Server side scripting is where the code for the scripts is executed on the server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

How does server side scripting allow for more security?

A

User is unable to view or access scripts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What is search engine optimisation?

A

Trying to achieve a high ranking for a website within a search engine.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

How to websites reduce loading time?

A

Websites will have their code and media files optimised to reduce load times.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Why is testing a website essential?

A

Ensure all hyperlinks work correctly, pictures display clearly and that there are no spelling or grammar errors.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What is beta testing?

A

Beta testing is when users outside of the design process use real world test data in order to test the software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

How would a website have good usability?

A

If it contains clear information and can be easily accessed by a range of users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

what does usability depend on?

A

Target audience, type of user, navigation, screen layout and accessibility

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

How may different devices not be able to display a website?

A

not enough RAM, hard drive space or correct browser

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Modern websites make use of responsive design which is what?

A

Where the style sheets rules will differ for different platforms.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Describe data?

A

Data is unprocessed and has no meaning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Describe information?

A

Information has been processed and has a meaning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

What is an information system?

A

An information system is where data can be collected, processed and stored on a computer

42
Q

How can information on the web be hidden?

A

giving instructions to search engine web crawlers

43
Q

What are the purpose of input and output devices?

A

input devices are used to put data into a computer. Output devices are used to display processed data.

44
Q

How can digital cameras be compared?

A

resolution
zoom capabilities
battery life
extra features

45
Q

How are touchscreens used?

A

a monitor you can touch, touch controls a mouse

46
Q

What are the different types of scanning?

A

OCR - optical character recognition, saves parts as ASCII file

OMR - Optical Mark Reading, inputs large amounts of data

47
Q

How can barcode scanning be linked to database inputs?

A

Each barcode acts as a record in the database

48
Q

What are the different types of monitor available?

A

LCD - Liquid crystal display
Touchscreen
OLED- Organic Light Emitting Displays
LCD Projectors

49
Q

How can printers be compared?

A

Resolution of printout

Print speed

50
Q

How can processors be compared?

A

Type of Processor
Number of Processors
Speed of Processor
Amount of Cache memory

51
Q

What is the difference between main memory and backing storage?

A

Main memory stores programs and data when they are being used
Backing storage stores programs and dat when the computer is off

52
Q

What are the differences between ROM and RAM?

A

ROM - Read only memory

RAM-Random Access memory

53
Q

What is cache memory and how can it improve a computers performance?

A

Faster memory

located on or near the processor which reduces time for fetch execute cycle

54
Q

What is the operating system responsible for?

A

The responsible for interpreting user commands, file management, memory management, input/output management, error reporting and resource allocation

55
Q

All software should come with what?

A

A licence

56
Q

What are the different types of licence available?

A

Single use or site use

57
Q

Explain freeware?

A

Freeware is software which is free but cannot be edited

58
Q

Explain shareware?

A

Shareware may be free for a trial but then the user is expected to pay to use the program or access full functions

59
Q

Explain proprietary software?

A

Known as closed source, source code is not available and cannot be modified

60
Q

Explain open source software?

A

Software can be modified to suit user

61
Q

What is commercial software?

A

Commercial software is software that is sold for a profit

62
Q

What is portability?

A

Portability is if the software can run on more than one platform or device

63
Q

Different hardware devices require different types of what?

A

Operating system

64
Q

Explain distributed storage?

A

Several computers are used to store all the information in a network

65
Q

Why is offline storage very secure?

A

it cannot be accessed electronically

66
Q

What is a backup?

A

A backup is a second copy of information

67
Q

how may backups be stored?

A

using separate backing storage devices or cloud computing

68
Q

What is a backup strategy?

A

A backup strategy is a plan of how an organisation is going to manage its backups, what information will be backed up how often backups are made and where they will be stored

69
Q

What is meant by data transfer speed?

A

Data transfer speed is the rate at which information can be transferred between devices

70
Q

How does Magnetic storage work?

A

Magnetic storage uses magnetic charges stored on metal oxide to represent data

71
Q

How does optical storage work?

A

Optical storage uses the reflection of light from a surface or lands and pits to represent data

72
Q

What is a network?

A

A network is two or more computers connected together

73
Q

What is meant by connectivity?

A

Connectivity is how the computers are connected together

74
Q

Explain a cloud system?

A

A cloud system allows information to be stored on servers provided by a company and the information can then be accessed from anywhere

75
Q

Cloud systems reduce what?

A

Cloud systems reduce the hardware and software demands placed on a company’s network

76
Q

Why is cloud based computing so secure?

A

Regular backups are taken constantly

77
Q

explain private public and hybrid clouds?

A

A private cloud is limited to one company or person, a public cloud is open to any user, a hybrid cloud is a combination of both

78
Q

What is web hosting?

A

Web hosting is where a company provides space on a web server to save pages so they can be accessed over the internet

79
Q

What are switches used for?

A

Switches are used to speed up communication between devices within Local area networks

80
Q

What are routers used for?

A

Routers are used to send packets between networks over the internet

81
Q

What is phising?

A

Phishing is an attempt to get users to pass on sensitive information to criminals using fake communications

82
Q

What are viruses?

A

Viruses are malicious programs that can replicate by copying their code into other programs

83
Q

What are worms?

A

Worms are malicious programs that replicate across network connections

84
Q

What is a Trojan horse?

A

A program which appears to be legitimate but hides a malicious action

85
Q

What is spyware?

A

Spyware is used to spy on you whilst you are using the computer?

86
Q

What is keylogging?

A

Keylogging keeps track of each key which is pressed on a keyboard.

87
Q

Describe a DOS attack?

A

A DOS attack aims to bring down a server or a network so that it is not available to use

88
Q

What is Ransomware?

A

Ransomware is software which encrypts the files on a network so that they can only be accessed when the decryption key is purchased

89
Q

Explain a DDOS attack?

A

A DDOS attack aims to bring down a network by swarming it with requests from many computers.

90
Q

What are two methods of protecting a computer system from security risks?

A

Anti virus and firewalls

91
Q

Explain encryption and decryption?

A

Encryption is using a key to turn data into seemingly meaningless content.
Decryption is reversing the original process using the key

92
Q

What is meant by symmetric key encryption?

A

The same key is used for both encryption and decryption

93
Q

Explain public and private key?

A

Public key encryption means the encryption key is available to anyone to use to encrypt data. only the private key can be used to decrypt data and is kept to one person

94
Q

what is a digital certificate?

A

A digital certificate is an electronic document that contains an electronic signature which is used to identify an organisation or individual

95
Q

What is a digital signature?

A

A digital signature is an electronic signature that can be used to authenticate the identity of someone sending you information

96
Q

What is validation?

A

Validation is used to check information which is being entered into a website or program/information system

97
Q

The regulation of Investigatory Powers Act gives the government the power to do what?

A

Intercept and acquire data on communications from service providers

Set up surveillance on individuals or organisations

Access encrypted data

98
Q

In modern/recent years computers have become what?

A

More affordable, portable and run faster

99
Q

What is an intelligent system?

A

An intelligent system is a machine that has the ability to perform a task that would require intelligence if they were performed by a human.

100
Q

The use or creation of a computer system creates a what?

A

A carbon footprint.