computer scince IVSgwefgsd

Manfred (Data Transmission)

100

What is full-duplex data transmission

Two devices to send and receive data simultaneously

200

What is an internet protocol IP address

It is the unique address given to a device when it is connected to a network.

300

What packet switching is

Data packets that are broken down then sent from one device to another.

400

What is the length a USB cable is normally limited to.

5m

500

Give 3 ways to detect errors and how they work.

checksum, echocheck ,ARQ, check digit.

Edwin (Software)

100

What type of software is used to perform specific tasks like word processing?

Application Software

200

What kind of software controls hardware and provides a platform for applications to run?

Operating system

300

What type of translator executes code line-by-line rather than translating the whole program at once?

Interpreter

400

What is one advantage of open source software rather than proprietary software?

-Free to use
-Can be Modified
-Community developed

500

State 2 differences between a compiler and an interpreter

Compiler translates the entire program while the interpreter does it line-by-line

Compiler produces an executable file while an interpreter doesn't

Compiler usually faster after translation while an interpreter is slower during execution

Shosh (Databases)

100

What is the difference between AlphaNumeric and Character?

Alphanumeric can be letters, numbers or symbols but not together. 

Characater needs to be a single character

200

What is the difference between the SUM command and the COUNT command in SQL?

SUM: Performs an addition of a group of values

COUNT: Counts the number of records that meet the criteria

300

What are the abbreviations in SQL for 'ascending' and 'descending'?

What are 'ASC' and 'DESC'?

400

What will this SQL return given that there is an appropriate table?

SELECT BookName; Genre

FROM Books

What is nothing, It needs to be a ",'' not a '';''?

500

Which one of these does not count as a 'character' type?

1: "?"

2: "3"

3: "Hello"

4: &

4. 

What is they need to be in commas?

Sarp (Internet and it's uses)

100

What is a data packet?

A unit of data that is used to transmit data across a network

200

Give 3 examples of malware

Virus, Worm, Trojan Horse, Spyware, Adware, Ransomware

300

What is a firewall?

A cybersecurity method that is used to examine incoming and outgoing traffic from a computer or network.

400

How is blockchaining used to track certain digital currencies? [3 Marks]

• It lists all the records made with the digital currency (called a digital ledger)
• Each time a payment is made with the digital currency, a record is added, which includes a digital signature with the time and date a payment is made
• Once these records are added to the blockchain/ledger, they cannot be changed.

500

Explain how a DDoS attack is carried out [3 Marks]

• A botnet is created by sending malware to computers
• Bots in the botnet send multiple requests to access a web server
• All of them sending requests to the same server at the same time causes the server to overload and crash

Graydon (Data Representation)

100

Write the 8-bit binary thingy for -128

trick question, you cant

200

explain how lossless compression works

2 or more instances of the same bit are stored as "x" number of copies where x is the amount of times it appears together in the sequence and no data is lost

300

convert 00000001 to denary from 8 bit binary

1

400

whats the largest number you can represent on a 7 bit binary register

127

500

how many kibibytes rounded to the nearest prime integer are in 11.3233 petabytes

11,057,910,156,203