GCSE Preparation

Question 1

What does CPU stand for?

Answer 1

Central Processing Unit

Question 2

True or False: RAM is a type of permanent storage.

Answer 2

False

Question 3

What is the primary function of an operating system?

Answer 3

To manage hardware and software resources on a computer.

Question 4

Fill in the blank: The process of converting source code into machine code is called __________.

Answer 4

compilation

Question 5

What is the purpose of an algorithm?

Answer 5

To provide a step-by-step procedure for solving a problem.

Question 6

Which of the following is an example of a high-level programming language? (a) Assembly (b) Python (c) Machine code

Answer 6

b) Python

Question 7

What does HTML stand for?

Answer 7

HyperText Markup Language

Question 8

True or False: A variable in programming is a fixed value.

Answer 8

False

Question 9

What is the purpose of a loop in programming?

Answer 9

To repeat a block of code multiple times.

Question 10

What is the difference between a compiler and an interpreter?

Answer 10

A compiler translates the entire code at once, while an interpreter translates code line-by-line.

Question 11

Fill in the blank: In binary, the number 2 is represented as __________.

Answer 11

10

Question 12

What is a database?

Answer 12

A structured collection of data that can be easily accessed, managed, and updated.

Question 13

Which of the following is NOT a type of software? (a) System software (b) Application software (c) Hardware

Answer 13

c) Hardware

Question 14

What does ‘IP’ stand for in networking?

Answer 14

Internet Protocol

Question 15

True or False: A firewall is used to protect a network from unauthorized access.

Answer 15

True

Question 16

What is the purpose of a web browser?

Answer 16

To access and view websites on the internet.

Question 17

Fill in the blank: The main memory of a computer is known as __________.

Answer 17

RAM

Question 18

What does ‘URL’ stand for?

Answer 18

Uniform Resource Locator

Question 19

Which of the following is an example of an input device? (a) Monitor (b) Keyboard (c) Printer

Answer 19

b) Keyboard

Question 20

What is an array in programming?

Answer 20

A collection of items stored at contiguous memory locations.

Question 21

True or False: The cloud allows data storage and access over the internet.

Answer 21

True

Question 22

What is the purpose of a compiler?

Answer 22

To translate high-level programming code into machine code.

Question 23

Fill in the blank: __________ is the process of finding and fixing errors in code.

Answer 23

Debugging

Question 24

What is the role of the motherboard in a computer?

Answer 24

To connect and allow communication between different components of the computer.

Question 25

Which protocol is used for sending emails?

Answer 25

SMTP (Simple Mail Transfer Protocol)

Question 26

True or False: All programming languages are case-sensitive.

Answer 26

False

Question 27

What is a function in programming?

Answer 27

A block of code designed to perform a specific task.

Question 28

Fill in the blank: __________ is used to store data permanently on a computer.

Answer 28

Hard drive

Question 29

What does 'GUI' stand for?

Answer 29

Graphical User Interface

Question 30

Which of the following is NOT a programming construct? (a) Loop (b) Variable (c) Syntax

Answer 30

c) Syntax

Question 31

What is the main purpose of an API?

Answer 31

To allow different software applications to communicate with each other.

Question 32

True or False: Encryption is used to secure data by converting it into a code.

Answer 32

True

Question 33

What is the function of a router in a network?

Answer 33

To direct data packets between different networks.

Question 34

Fill in the blank: The __________ is the smallest unit of data in a computer.

Answer 34

bit

Question 35

What is open-source software?

Answer 35

Software that is freely available for use, modification, and distribution.

Question 36

Which language is primarily used for web development?

Answer 36

JavaScript

Question 37

True or False: Malware is software designed to harm or exploit any programmable device.

Answer 37

True

Question 38

What does 'SQL' stand for?

Answer 38

Structured Query Language

Question 39

Fill in the blank: In programming, __________ is used to represent a logical condition.

Answer 39

Boolean

Question 40

What is the purpose of version control systems?

Answer 40

To manage changes to source code over time.

Question 41

Which of the following is a type of computer network? (a) LAN (b) CPU (c) RAM

Answer 41

a) LAN

Question 42

True or False: A prototype is a preliminary version of a product.

Answer 42

True

Question 43

What is the function of a web server?

Answer 43

To store, process, and deliver web pages to clients.

Question 44

What is disk defragmentation?

Answer 44

Disk defragmentation is the process of reorganizing data on a hard drive to ensure that files are stored in contiguous sections, improving access speed.

Question 45

True or False: Disk defragmentation is necessary for solid-state drives (SSDs).

Answer 45

False

Question 46

Fill in the blank: Disk defragmentation helps to reduce _____ time when accessing files.

Answer 46

seek

Question 47

Which of the following is a benefit of disk defragmentation? A) Increased file access speed B) Additional storage space C) Enhanced security

Answer 47

A) Increased file access speed

Question 48

What tool is commonly used to perform disk defragmentation on Windows operating systems?

Answer 48

Disk Defragmenter or Optimize Drives

Question 49

What is utility software?

Answer 49

Utility software is system software designed to help manage, maintain, and control computer resources.

Question 50

True or False: Antivirus software is a type of utility software.

Answer 50

True

Question 51

Fill in the blank: __________ software is used to optimize the performance of a computer by cleaning up unnecessary files.

Answer 51

System maintenance

Question 52

Which of the following is NOT a function of utility software? (A) Disk defragmentation (B) Word processing (C) File compression

Answer 52

B) Word processing

Question 53

Name one type of utility software that can recover lost or deleted files.

Answer 53

Data recovery software

Question 54

What does SQL stand for?

Answer 54

Structured Query Language

Question 55

True or False: SQL is used to manage and manipulate relational databases.

Answer 55

True

Question 56

Fill in the blank: SQL commands such as SELECT, INSERT, UPDATE, and DELETE are known as ____ statements.

Answer 56

DML (Data Manipulation Language)

Question 57

What is a SQL injection?

Answer 57

A code injection technique that attackers use to exploit vulnerabilities in an application by inserting malicious SQL statements.

Question 58

Which of the following is a common consequence of a successful SQL injection attack? (a) Data loss (b) Improved performance (c) Increased security

Answer 58

a) Data loss

Question 59

True or False: Prepared statements can help prevent SQL injection attacks.

Answer 59

True

Question 60

What is the purpose of the WHERE clause in a SQL statement?

Answer 60

To filter records that meet a specified condition.

Question 61

Multiple choice: Which of the following is NOT a type of SQL statement? (a) SELECT (b) DELETE (c) EXECUTE (d) UPDATE

Answer 61

c) EXECUTE

Question 62

What type of data does the SQL command 'INSERT' add to a database?

Answer 62

New records or rows

Question 63

True or False: SQL injections can only occur in web applications that use SQL databases.

Answer 63

False

Question 64

What is the primary purpose of protocol layers in networking?

Answer 64

To organize and standardize communication processes between different network devices.

Question 65

True or False: Protocol layers help to simplify network design by breaking down complex processes into manageable parts.

Answer 65

True

Question 66

Fill in the blank: The ______ layer is responsible for ensuring reliable data transmission between devices.

Answer 66

Transport

Question 67

Which protocol layer is responsible for routing data packets across the network?

Answer 67

Network layer

Question 68

Multiple Choice: Which of the following is NOT a benefit of using protocol layers? A) Modularity B) Interoperability C) Increased complexity D) Error handling

Answer 68

C) Increased complexity