Which describes Lossy Compression?

Which describes Lossless Compression?

Which file types are Lossy compressed files?

Which file types are Lossless compressed files?

Benefits of using compression?

Which is described: Assigning values to each unique word, then replacing the words with a code. This shortens the file, but a table of words and codes must be stored with the text file. Only suitable when repetition of words.

Which is described: Used to compress an image, a code is assigned to a colour then the number of times that colour is repeated is also stored. 100 blue pixels could be stored as B100. This greatly reduces the size of the file.

Pick the definition of Encryption?

Which type of encryption is described: Simpler encryption, generates one key used to both encrypt and decrypt the message.

Which type of encryption is described: Complex encryption, generates two keys A public key is used to encrypt the message and then a private key is applied. Uses more processing power the encrypt the message.

A hashing algorithm must?

What is added to a Hashing algorithm to make the hashed value more secure from hacking?

What is described: A structured set of data, persistently stored in an organised way

What is described: A database made with a single table.

What is described: A database made with multiple tables that are linked together.

What is described: Software designed to configure and manage databases.

What is in the image?

Which type of Key is described: A Unique identifiers selected to be represent a record in the table.

Which type of Key is described: This is when a primary key is used in another table. To reference a record in another table

Which type of Key is described: A piece of data in a table that is not a primary key but is unique to the record and can be used to find a unique record. Such as an Email or Phone number.

Which type of relationship is shown: A relationship where one entity can relate to many other entities. Example – At parents evening a student can book many appointments, but each appointment is for only one student.

Which type of relationship is shown: A relationship where an one singular entity relates to another singular entity. Example – A School can only have one headteacher and a headteacher can only work in one school.

Which type of relationship is shown: A relationship where many entities relates to many entities. Example – A student is taught by many teachers and teachers have many students.

Which type of relationship does not work in a database and must be resolved by a resolution table?

In the diagram which icon shows a Primary Key

In the diagram which icon shows a Foreign Key

In the diagram which icon shows a One-to-Many Relationship

In the diagram which field could be used as a Secondary Key

The correct order for SQL command words are?

Which symbol do we use in SQL for: ALL

Which symbol do we use in SQL for: Wildcard, meaning any value before or after.

Which symbol do we use in SQL for: Boolean Logic

Which symbol do we use in SQL for: In a where statement to find non matches that contain or are similar.

Which is described: Creating tables in order so all primary keys are created before they are referenced by a Foreign key.

Which of the following is described: This is the idea that all of the transaction must be committed or none of it.

Which of the following is described: This means if a transaction breaks any of the defined rules (constraints) of the database it will be rejected to preserve the integrity of the database.

Which of the following is described: This ensures that each transaction can be committed without impacting another.

Which of the following is described: This means that once a transaction is committed the data will remain in the database. This means if the user has been told it has succeeded then it must have.

Which of the methods DBMS's use for Concurrent Users is described: This means running one command after another, not as efficient as concurrent. However this is the concept that all transactions should be able to produce the same result when ran serial as concurrent, meaning the must not impact/block another transaction.

Which of the methods DBMS's use for Concurrent Users is described: This is a common method allowing transactions to lock a record whilst it is being updated so other concurrent transaction cannot alter the data at the same time. Once committed with the data will have the lock released.

Which of the methods DBMS's use for Concurrent Users is described: This avoids deadlocks, where two or more transactions are waiting for another to release locks. This means transactions are evaluated to see their impact on other transactions and then are committed in the order which aims to execute all the transactions in the optimal order minimising interference.

Which of the methods DBMS's use for Concurrent Users is described: Each record has two timestamps, last read and last written/updated. Timestamp ordering means that transactions are checked against a third timestamps, the operation/transaction timestamp using a protocol such as the one to the right.

The process of changing a single table of data into a set of related tables, that can them be used as a database is known as?

Which step of normalisation is outlined: Single table with duplicate data, not all data may relate to the primary key.

Which step of normalisation is outlined: In this normal form you -

Eliminate duplicate columns from the same table

Create separate tables for each group of related data.

Identify columns or groups of columns to create a unique identity for the record.

Which step of normalisation is outlined: In this normal form you -

Check the data is in 1NF

Remove any data that occurs in multiple row and transfer to a new table.

Create relationships between these new tables, primary and foreign keys.

Which step of normalisation is outlined: In this normal form you -

Once all the data has been checked it is in 2NF and all columns are removed that are not dependent on the primary key the tables are in this form.

Is this table Normalised?

Which type of network is described: Covers a small geographical area such as one site or building, eg a school or a college. This type owns all their own hardware and are responsible for their upkeep. They can be wired or wireless.

Which type of network is described: Connects LANs in different geographical areas. E.g. A business with offices in different parts of a country. Companies often hire the infrastructure to connect and manage this network. This network isoften connected using, telephone lines, satellites or fibre/copper cables. The Internet is one huge this type.

Which type of network is described: Provides a dedicated network for large scale data storage in data centers. They are efficient because he servers that make them consolidate their storage devices to provide a disk array of high capacity and performance.

Which type of network is described: Provides WAN services in a city between different LANs that exist in different residential and commercial properties.

Which type of network is described: Links a personal device with a mobile network to other devices to share data and internet access. Modern phones can be used as hotspots using WI-FI or can use Bluetooth to share internet.

Which network device is described: This piece of hardware allows other device to connect wirelessly to a network. It uses Wi-Fi to send signals, often used in homes or businesses to extend the range of a network. This device operates like a wireless switch.

Which network device is described: This piece of hardware is built into other devices allowing them to connect to networks. These devices come in both wired and wireless form. You can purchase a portable dongle version of this device to allow standalone computers to connect to a network. Ethernet and even WI-FI standard versions can be built into motherboards.

Which network device is described: This piece of network hardware connects devices in a LAN. It receives data through ethernet ports and switches that data to transmit it to the device connected with the correct MAC address.

Which network device is described: This piece of network hardware transmits data between networks, example being a home LAN and the internet. It is always connected to at least two networks. Most modern versions of this device contain a switch and a WAP also. Routers use IP addresses to send information.

Which network device is described: The different methods of connecting devices within a network. Some methods are Wired (Ethernet – Twisted pair cables, Coaxial Cables and Fibre Optic) others are wireless (Wi-Fi or Bluetooth both types of radio waves).

WAPs allow you to?

Which is described: These are the amount of times the wireless radio signals are sent each second. The most popular are 2.4GHz and 5GHz.

Which is described: Each wireless frequency is divided into multiple channels. Channels allow lots of devices to send and receive data with as little interference as possible.

Which of the network performance factors is described: The weaker this is the more degradation to the speed and loss of data.

Which of the network performance factors is described: Is the measure of how much data can be transferred over a connection at any given time.

Which of the network performance factors is described: Is a measure of how much time it takes to send data over a network from one node to another.

IP or MAC address: Is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network for communication.

IP or MAC address: Is a unique identifier assigned to NICs.

48-bit meaning 281,474,976,710,656 possible values. The first 4 octets identify the manufacturer. The others are to identify the device as unique.

When using a DNS server which is the correct order of steps taken?

Which part of the page rank algorithm affects the algorithm the most?

Which network type is described: Needs to have a server set up and configured. These are high performance to support the large amounts of users, so very costly.

Which network type is described: Servers can be located in a secure room. They only need to be accessible to specific staff. The room can be monitored by different methods.

Which network type is described: If the server fails, this will affect all users needing it.

Which network type is described: Workstations could be in many different locations so cannot manage security.

Which network type is described: If one device fails, it will have less impact as the other devices still carry on working.

Which network topology is shown in the image?

Which network topology is shown in the image?

Which network topology is shown in the image?

Which method of sending data is described: is a concept that was create on the telephone network, operators working on a switchboard/patch panel would use physical cable to switch the connection between two phone lines. The problem with this is the physical connection is reserved and cannot be used by anyone at that time.

Which method of sending data is described: means to break a file up into smaller files (packets of data) then sending them along different routes on a network to it’s destination and then is reassembled.

Data is sent between routers and servers on a network. The idea is that data can be sent more efficiently by travelling down different routes. As well as this if any errors occur data can be resent.

Which method of sending data is described: Bandwidth is wasted

Which method of sending data is described: Packets travel independently

Which protocol is used for: Transferring a file.

Which protocol is used for: Sending a webpage.

Which protocol is used for: Sending a voice audio.

Which protocol is used for: Sending an email.

Which protocol is used for: Receiving an email.

Which layer is being described: This collates and disseminates the data being sent on the network. Based on human interaction this is where the process of sending is initiated and the data of a recipient presents the data.

Which layer is being described: This layer is not concerned about what data is being sent, it is concerned about the network layout(topology) and how best to get the data from the source to the destination.

Which layer is being described: This layer is concerned with he physical medium of which the data is transmitted. This typically contains cables, NICs Routers and signals. This just provides a medium for the data to be sent on.

Which of the following is a benefit of using Network Layers?

Which of the following in a not a form of social engineering?

Which of the following is not a form of Human Error?

Which method of social engineering is described: The action of demanding payment or another benefit in exchange for not revealing sensitive information.

Which method of social engineering is described: A fake phone call, email or text where the caller lies about who they are to extract information form the recipient.

Which method of social engineering is described: A fake website that looks identical to the original, which collects login details when you sign in to it.

Which method of Human Error is described: Someone inside an organisation exploits their access to steal information.

Which method of Human Error is described: Looking over someone's shoulder to read information from the device they are using.

Which piece of malware is described: is malware that is destructive to a system. Virus’ can spread across a network or computers to infect them.

Which piece of malware is described: is malware that replicates itself to spread across systems.

Which piece of malware is described: is malware that sits on a computer and waits for a command from a hacker of where to connect to. Millions of botnets will all work together to attack systems and the users won’t even know their computer is doing it.

Which piece of malware is described: are malware that give hackers administrative access to a computer. These hide themselves on a computer.

Which piece of malware is described: are malware that pretend to be a useful program until installed then attack the system to cause harm or steal data.

Which piece of malware is described: is malware that encrypts a computers files so the user cannot access them. The hacker will then notify the user of the random (money) to recover their files.

Which piece of malware is described: is malware that records information on a system such as; browsing history, password entries, key presses and Card information.

Which piece of malware is described: This puts a notice on the users computer telling them that their computer is infected and demands they pay money to remove this.

Which type of attack is described: is where an attacker monitors a network, intercepting any data they can.

They will use specialist software and hardware such as packet sniffers.

Which type of attack is described: are ones where the user exploits vulnerabilities in a system or network.

Which type of cyber-attack is described: This is a type of active attack, which uses trial and error to crack passwords. It uses automated software to produce hundreds of likely password combinations.

Which type of cyber-attack is described: This is where a hacker tries to stop users from accessing a part of a network or website. Most DoS attacks involve flooding the network with useless traffic, making the network extremely slow or completely inaccessible

Which type of cyber-attack is described: This is where a hacker positions a router between the user and the actual router they usually log on to the network with. Doing this all data will then go through the hacker’s router. This means the Hacker can Intercept data or send incorrect data or malware to the user without them knowing.

Which type of cyber-attack is described: This is a code injection technique, used to attack applications, in which SQL statements are inserted into an entry field for execution. These can be used to gain information such as access details. Another usage of this could be to drop whole tables and damage the back end of the website.

Which tag is used for the section for defining styles and linked files into the html code.

Which tag is used for outlining where html code starts and ends?

Which tag is used for the section where html elements will be defined for the page?

Which tag is used to define a section of html code under one name?

Which tag is used to define a heading, with large font and size on the page?

Which tag is used to define a title for the tab of the page?

Which tag is used to define an image and it's source?

Which tag is used to define hyperlink tag used to take a user to a different page internally or externally to the website?

Which tag is used to define a data entry form within the website?

Which tag is used to define a item in a list?

Which tag is used to define a list with numbers?

Which tag is used to define a bullet pointed list?