Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Compsci Practice Qs > Exchanging data > Flashcards

Exchanging data Flashcards

1
Q

The website of a school allows visitors to download JPG, MP3, MPEG and PDF files.
The video clip is compressed using lossy compression.
Explain why lossy compression is suitable for a video clip, but not suitable for a text document.

A

When the file is compressed some detail / data / quality / resolution is lost…
… which is not noticeable in the video file / video still viewable with lower quality
… but would make the text file unreadable / lose meaning or comprehension

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

Two types of compression are lossy and lossless.
State which type of compression is most appropriate for each of the following and explain why it is appropriate.
(i) Downloading the source code of a large program

A

Lossless compression
The code has to be exactly as it was originally written
… or else it will not work.

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

Two types of compression are lossy and lossless.
State which type of compression is most appropriate for each of the following and explain why it is appropriate.
(ii) Streaming a large video file

A

Lossy compression
Achieves higher compression / smaller file size / faster streaming than lossless Video can still be viewed at lower quality (from the data compressed)

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

Kofi uses his computer to record an audio file of himself playing his guitar.
He emails his recording to a record label. He uses lossy compression to produce the music file. Explain two reasons why using lossy compression is beneficial.

A

Lossy means the decompressed file is not identical to the original…
…the difference is unlikely to be noticed by humans
Lossy will decrease the file size … … so it can be sent via e-mail

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

The video table consists of the following fields: VideoID, VideoName, Presenter, Topic.
(i) Describe what is meant by the term primary key.

A

A field that has a unique value / a unique identifier (1) for every record in that table (1) – in this case VideoID (1).

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

The video table consists of the following fields: VideoID, VideoName, Presenter, Topic.
(ii) Write an SQL query that finds the name and presenter of all videos on the Topic of “The CPU”

A

SELECT VideoName, Presenter (1) FROM Video (1) WHERE Topic (1) =“The CPU” (1).

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

The Big Brains exam board has produced a website that allows students to access revision videos. All pages in the site contain the following tag in the head section.
The exam board wants to use a database to keep track of which videos each student has viewed. The structure it plans to use is shown below:
(many to many)
(i) Identify one reason why this structure would not be suitable.

A

Many to Many relationships are not allowed / in 3NF (1).

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

The Big Brains exam board has produced a website that allows students to access revision videos. All pages in the site contain the following tag in the head section.
The exam board wants to use a database to keep track of which videos each student has viewed. The structure it plans to use is shown below:
(many to many)
(ii) Draw a new version of the structure to solve this problem.

A

Table added between student and video (1).
Student to middle table 1:M relationship (1).
Middle table to video M:1 relationship (1).

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

A database stores information about songs on a music streaming service. One of the tables called Song has the fields:
Title, Artist, Genre, Length
Explain why none of these fields would be suitable as a primary key.

A

– A primary key must have a unique value for every record
– The values for all these fields could repeat.
(1 per –)

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

A database stores information about songs on a music streaming service. One of the tables called Song has the fields:
Title, Artist, Genre, Length
Give one advantage and one disadvantage of indexing the field Artist

A

– Advantage: Searches of Artist can be performed more quickly.
– Disadvantage: The index takes up extra space in the database.

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

A band called RandomBits removes their permission for their songs to be streamed. The company removes all the songs belonging to RandomBits from their service.
(i) Identify the law with which the company are complying.

A

Copyright, Design and Patents Act

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

Write an SQL statement that will remove all songs by RandomBits from the table Song.
Song has the fields:
Title, Artist, Genre, Length

A

DELETE FROM Song
WHERE Artist + ‘RandomBits’

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

When the songs have been removed, explain what must happen to the table PlayListEntry if the database is to retain its referential integrity. (You are not expected to write the SQL to do this).

A

All entries in PlaylistEntry which contain songs by RandomBits must be removed.

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

A company sells garden furniture. It has decided to create a relational database. A first, incomplete database design includes two tables PRODUCT and ORDER.
PRODUCT (ProductId, ProductType, Size, Price,…) ORDER (OrderId, OrderDate, ProductId,…)
For example, the product which has ProductId 12345 is a large bench which has a price of £150.
State one additional piece of data which should be included in PRODUCT and give one reason why it is needed.

A

NoInStock…
…to check stock levels / allow re- ordering
Location (in warehouse)…
…to find item when needed

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

A company sells garden furniture. It has decided to create a relational database. A first, incomplete database design includes two tables PRODUCT and ORDER.
PRODUCT (ProductId, ProductType, Size, Price,…) ORDER (OrderId, OrderDate, ProductId,…)
For example, the product which has ProductId 12345 is a large bench which has a price of £150.
A CUSTOMER table is added.
Entity relationship diagram:
product (1-many) order (many-1) customer
Explain why this design would be inefficient for customers.

A

Only one product can be on an order Customer would have to make a separate order for each product required

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

(i) Describe what is meant by an IP Address.

A

A numerical address made of 4 numbers each between 0 and 255 / 32 hexadecimal digits (1)
That uniquely identifies a device on a network. (1)
It is a logical identifier (i.e. can change on a physical device) (1)

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

Some of the Structured Query Language (SQL) for this database is
SELECT Surname, Title, PhoneNo FROM CUSTOMER
WHERE Town = “Coventry” ORDER BY Surname
Describe the purpose of this code and give one situation in which it may be used.

A

Lists attributes Surname, Title, PhoneNo
from the table CUSTOMER
for all customers in Coventry
in ascending order of Surname
e.g. for local promotions / new store opening

18
Q

ii) Explain why the programmers of the bank’s software have chosen to store the user’s IP address.

A

IP address can help identify a user… (1) …so company can potentially track users attempting to gain unauthorised access (1)

19
Q

The office workers of a large company each use a stand-alone computer. The company is considering networking the machines.
(i) Describe what is meant by a LAN.

A

Local Area network
(Over) a small geographical area Use of hard-wiring / wireless communication

20
Q

The office workers of a large company each use a stand-alone computer. The company is considering networking the machines.
ii) State two advantages of having a LAN instead of a set of stand-alone machines

A

Communication between machines / workers
Any machine can be used
Easier to maintain / add / delete software / files
Sharing of peripheral devices / software / data
Monitoring of workers Simplifies backup procedures

21
Q

2(a). Describe how packet switching is used to transmit datafrom one computer to another computer on a network.

A

Data is split into equal sized blocks (called packets)
Each packet has a header of information (including destination address and the place of the packet in the complete message)
(Each packet is placed on the network and) each may travel by a different route
(At each node on the network the destination address is read and the) best route is found
Packets need to be reordered at the destination

22
Q

(b). Explain two advantages of using packet switching instead of circuit switching to send a message between two computer on a network.

A

Transmission is safer from interception…
…because it is impossible to intercept all the packets as they use different routes
Very efficient use of network…
…as each channel only used for short time / does not tie up a part of the network
If there is an error then only a small, identifiable, part of the data is affected…
…this can be retransmitted easily

22
Q

InterMovie is a service that allows users to stream movies over the Internet.
When users have played a movie it remains stored in a cache on the user’s computer. This means that someone wanting to access the same film in future can stream it from other users rather than directly from the company’s servers.
(i) State what this network model is called.

A

Peer to peer (1).

23
Q

InterMovie is a service that allows users to stream movies over the Internet.
When users have played a movie it remains stored in a cache on the user’s computer. This means that someone wanting to access the same film in future can stream it from other users rather than directly from the company’s servers.
(ii) Explain why the company might have opted for this model.

A

Peer to peer means there isn’t a reliance on the company’s server (1) and its connection to the Internet (1). This means it hasn’t got to invest in lots of hardware and bandwidth (1) and the system is likely to be more fault tolerant (1).

24
Q

4(a). Zuhair wants to create a Local Area Network (LAN) for himself and his family, in his home. Describe what is meant by a LAN.

A

A group of computers / devices (1 – AO1.2) connected over a small geographical area (1 – AO1.2). The infrastructure is usually owned by the network owner (1 – AO1.2).

24
Q

(b). TCP/IP uses packet switching.
Explain what is meant by packet switching.

A

Data is split into chunks called packets (1 – AO1.1) which have labels (1 – AO1.1) including address being sent to (1 – AO1.1) and order (1 – AO1.1). Each packet is sent on the most convenient / avoidable route (1 – AO1.2) meaning they may arrive in a different order to which they were sent (1 – AO1.2). Once packets arrive at receiver they are reordered (1 – AO1.2).

25
Q
  1. The computers in a car showroom are connected in a network with all data being held in a central server. The computers are used by the salesmen, but can also be used by customers to watch videos of the cars that are on offer.
    What is meant by a protocol?
A

A set of rules…
–…to govern data transmission (between devices)

26
Q

6(a). A coffee company has coffee shops located across the country. Each shop has its own Local Area Network (LAN). The company wants to connect the shops in a Wide Area Network (WAN).
(i) Describe two characteristics of a LAN.

A

□ A LAN covers a small geographical area (e.g. a building or campus). [1] □ A LAN uses connections owned by the organisation that owns it. [1]
□ More secure than a WAN [1]

26
Q

6(a). A coffee company has coffee shops located across the country. Each shop has its own Local Area Network (LAN). The company wants to connect the shops in a Wide Area Network (WAN).
(b). Describe one piece of hardware that each shop will need to connect their LAN to the company’s WAN.

A

□ A router [1]…
□ … A device that passes data between two networks. [1]
OR
□ A gateway [1]…
□ … A device which connects two dissimilar networks to each other.[1]

27
Q

6(a). A coffee company has coffee shops located across the country. Each shop has its own Local Area Network (LAN). The company wants to connect the shops in a Wide Area Network (WAN).
(ii) Describe two characteristics of a WAN.

A

□ A WAN covers a large geographical area.[1]
□ A WAN often uses third party connections.[1]
□ Less secure than a LAN [1]

27
Q
  1. A company produces digital photo frames (i.e. photo frames that display digital photographs).
    Several of these photo frames can be placed around a house and connected in a peer to peer network.
    Describe what is meant by the term ‘peer to peer network’.
A
  • Devices on the network have equal status/no (central) server.
  • Devices on the network share data
    (1 per -, max 2)
28
Q

8(a). The internet can be considered an example of a WAN. Describe what is meant by the term ‘WAN’.

A
  • Wide Area Network
  • Collection of connected
    computers/devices over a large
    geographical area
  • Often using 3rd party communications
    channels
    (1 Mark per -, max 2)
29
Q

(b). The internet uses a set of protocols referred to as the TCP/IP stack. The TCP/IP stack consists of four different layers, each with its own set of protocols.
(i) Explain why protocols are important on a network.

A
  • Allowing them to communicate
  • By ensuring all devices follow the
    same rules/standards
  • So they interpret data/signals in the
    same way
    (1 Mark per -, max 2)
30
Q

(ii) State the name of the four layers of the TCP/IP stack.

A
  • Application
  • Transport
  • Internet
  • Network Interface/(Data) Link/Physical
    (1 Mark per -, max 4)
31
Q

(b). The website also includes JavaScript.
(i) Describe what is meant by the term JavaScript.

A

A programming language that runs in a web browser (1) that can be embedded into HTML (1) with 

 tag (1) to add interactivity to a page (1).
32
Q

(ii) Explain why it is usually the case that JavaScript is interpreted rather than compiled.

A

JavaScript is likely to be run on a variety of machines (1) with different processors / architectures (1). Compiled code is machine dependent (1) whereas interpreters run on high level code (1) which is machine independent (1).

33
Q

(b). The exam board wants to limit access to those students with a school email account (i.e. one ending .sch.uk). When students sign up JavaScript is used to check that the email address they have entered is from a school account. The address is checked again when it reaches the server before login details are sent to the address.
Explain why it is important to check the email address with JavaScript and again when it reaches the server.

A

The JavaScript check is carried out client-side / in browser (1) meaning address can be checked and stopped prior to reaching server (1) reducing unnecessary load on the server (1). JavaScript can, however, be amended and circumvented (1) therefore address must be checked at the server to ensure this has not happened (1).

34
Q

2(a). The Big Brains exam board has produced a website that allows students to access revision videos. All pages in the site contain the following tag in the head section.
Describe one advantage of storing the CSS in an external file rather than it being embedded within HTML files.

A

Content and formatting are kept separate (1). Changes can be made to the external style sheet and affect the whole site (1) saving time (1) and ensuring consistency (1). Stylesheets can be changed for different themes, or different devices (1).

35
Q
  1. Elegant Bags is a company that makes designer handbags. It has decided it wants to sell its products online. Elegant Bags puts its website on its servers which are given a public IP address. It also purchases the domain
    name elegantbagsonline.co.uk.
    The company’s handbags come in a variety of materials. It would like visitors to its website to be able to select different materials in their browser and for the image shown to then instantly change to one of a handbag made of the selected material.
    Explain how the website developer would implement this. You are not expected to write any code.
A

Page will include JavaScript (which allows page content to be dynamic) (AO2.2)
(1 per -, Max 1)
Plus
When a material is selected (JavaScript) code can be executed…(AO3.1)
…the appropriate picture is shown…(AO3.1)
…and hides the original picture. (AO3.1)
(1 per -, Max 3)

35
Q

(c). The site uses styling set out as attributes in tags rather than a linked CSS file.
(i) Give one disadvantage of this to the site’s owner.
(ii) Give one disadvantage of this to the site’s visitors.

A

– Formatting code has to be rewritten for every page
– Changes have to be made to every page
– It is a lot of work to keep the look of the site consistent.

The site is slower to access (as the formatting information is reloaded for every page)
Unlikely to have formatting specific to their device/needs.

Compsci Practice Qs (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions