Booklet

Question 1

Character set

Answer 1

Numeric code which each keyboard character is given and is then converted into binary

Question 2

ASCII

Answer 2

Character set

Represents 128 characters in 7 bits

Question 3

Unicode

Answer 3

Character set

Represents characters in 16 bits ( good for all languages and emojis)

Question 4

Resolution

Answer 4

Concentration of pixels per inch

dpi

Question 5

Pixels

Answer 5

Dots that make up a pic

Question 6

Colour depth

Answer 6

Number of bits per pixel

Question 7

Same rate

Answer 7

The number of times the height of a sound wave is sampled per second

Question 8

Sample interval

Answer 8

Time between each sample

Question 9

Bit rate

Answer 9

Amount of space available to store each sample

Question 10

Field

Answer 10

A characteristic of something stored in a database e.g. Surname , DOB

Question 11

Entity

Answer 11

The real world thing that we store data about e.g. Cars , students , emplyoees

Question 12

Record

Answer 12

All the data about one thing in a database e.g your school record

Question 13

Primary key

Answer 13

A Unique field to ensure that there is at least one field that is never duplicated

Question 14

Foreign key

Answer 14

The primary key from a linked table

Question 15

Data redundancy

Answer 15

Same data is present in more than one table

Question 16

Data inconsistency

Answer 16

More than one copy of the same data and some of the data is different

Question 17

Topology

Answer 17

Arrangement of nodes and connections in a network

Question 18

Router

Answer 18

Connects computer and other network capable devices together to form a network . Forwards packets to make sure they reach destination.

Question 19

Modem

Answer 19

Connects a computer to the Internet via a telephone line

Question 20

Hub

Answer 20

Connects devices in LAN

Sends packets to everything in network except sender
Less efficient and less private

Question 21

Switch

Answer 21

More powerful than hub , better for larger networks

Has lots of ports to connect devices in LAN

Forwards packets to intended destination ONLY using MAC address

Question 22

WAP

Answer 22

To connect wirelessly to a network . Built into routers

Question 23

NIC

Answer 23

Built into a computer to connect to a network

Question 24

Protocols

Answer 24

Set of rules that control communication between device e.g. TCP/IP , DNS

Question 25

IP address

Answer 25

A number that identifies a device on a network (will not have same IP address each time it connects

Question 26

MAC address

Answer 26

Address of the device . Hard coded into the NIC

Question 27

Packets

Answer 27

Data which is split up and reassembled when it reaches its destination

Question 28

DNS

Answer 28

Domain Name System Protocol that connects IP addresses to user friendly names such as bbc.co.uk

Question 29

Advantage of DNS

Answer 29

No need to remember IP addresses IP address can be changed or upgraded without having to change the Domain name

Question 30

HTML

Answer 30

Text file containing text to be displayed on a webpage. Uses tags. It's a standard and ensures content is displayed regardless of browser

Question 31

GIF

Answer 31

Lossless

Question 32

Assembly language

Answer 32

Low level code that uses mnemonic codes

Question 33

Machine code

Answer 33

Instructions in binary used by CPU

Question 34

Opcode

Answer 34

The part of a machine code instruction that tells the processor the job that needs to be done (e.g. Add, subtract )

Question 35

Operand

Answer 35

The part of a machine code instruction that tells the processor what to apply the job to (e.g. Specific piece of data or place in memory )

Question 36

Antivirus

Answer 36

Program that detects and eliminates malicious software

Question 37

Firewalls

Answer 37

Restricts unwanted network addresses

Question 38

Spyware

Answer 38

Software that fathers and sends info about a host

Question 39

Firewall

Answer 39

Restricts unwanted network addresses

Question 40

Form

Answer 40

An input screen allowing chosen data to be displayed and edited. Uses text boxes or drop down lists. When edited, changes are updated in database

Question 41

Difference between router and switch

Answer 41

Router revives and sends packets between networks Switch over ONE network