GCSE Preparation Flashcards
What does CPU stand for?
Central Processing Unit
True or False: RAM is a type of permanent storage.
False
What is the primary function of an operating system?
To manage hardware and software resources on a computer.
Fill in the blank: The process of converting source code into machine code is called __________.
compilation
What is the purpose of an algorithm?
To provide a step-by-step procedure for solving a problem.
Which of the following is an example of a high-level programming language? (a) Assembly (b) Python (c) Machine code
b) Python
What does HTML stand for?
HyperText Markup Language
True or False: A variable in programming is a fixed value.
False
What is the purpose of a loop in programming?
To repeat a block of code multiple times.
What is the difference between a compiler and an interpreter?
A compiler translates the entire code at once, while an interpreter translates code line-by-line.
Fill in the blank: In binary, the number 2 is represented as __________.
10
What is a database?
A structured collection of data that can be easily accessed, managed, and updated.
Which of the following is NOT a type of software? (a) System software (b) Application software (c) Hardware
c) Hardware
What does ‘IP’ stand for in networking?
Internet Protocol
True or False: A firewall is used to protect a network from unauthorized access.
True
What is the purpose of a web browser?
To access and view websites on the internet.
Fill in the blank: The main memory of a computer is known as __________.
RAM
What does ‘URL’ stand for?
Uniform Resource Locator
Which of the following is an example of an input device? (a) Monitor (b) Keyboard (c) Printer
b) Keyboard
What is an array in programming?
A collection of items stored at contiguous memory locations.
True or False: The cloud allows data storage and access over the internet.
True
What is the purpose of a compiler?
To translate high-level programming code into machine code.
Fill in the blank: __________ is the process of finding and fixing errors in code.
Debugging
What is the role of the motherboard in a computer?
To connect and allow communication between different components of the computer.
Which protocol is used for sending emails?
SMTP (Simple Mail Transfer Protocol)
True or False: All programming languages are case-sensitive.
False
What is a function in programming?
A block of code designed to perform a specific task.
Fill in the blank: __________ is used to store data permanently on a computer.
Hard drive
What does ‘GUI’ stand for?
Graphical User Interface
Which of the following is NOT a programming construct? (a) Loop (b) Variable (c) Syntax
c) Syntax
What is the main purpose of an API?
To allow different software applications to communicate with each other.
True or False: Encryption is used to secure data by converting it into a code.
True
What is the function of a router in a network?
To direct data packets between different networks.
Fill in the blank: The __________ is the smallest unit of data in a computer.
bit
What is open-source software?
Software that is freely available for use, modification, and distribution.
Which language is primarily used for web development?
JavaScript
True or False: Malware is software designed to harm or exploit any programmable device.
True
What does ‘SQL’ stand for?
Structured Query Language
Fill in the blank: In programming, __________ is used to represent a logical condition.
Boolean
What is the purpose of version control systems?
To manage changes to source code over time.
Which of the following is a type of computer network? (a) LAN (b) CPU (c) RAM
a) LAN
True or False: A prototype is a preliminary version of a product.
True
What is the function of a web server?
To store, process, and deliver web pages to clients.
What is disk defragmentation?
Disk defragmentation is the process of reorganizing data on a hard drive to ensure that files are stored in contiguous sections, improving access speed.
True or False: Disk defragmentation is necessary for solid-state drives (SSDs).
False
Fill in the blank: Disk defragmentation helps to reduce _____ time when accessing files.
seek
Which of the following is a benefit of disk defragmentation? A) Increased file access speed B) Additional storage space C) Enhanced security
A) Increased file access speed
What tool is commonly used to perform disk defragmentation on Windows operating systems?
Disk Defragmenter or Optimize Drives
What is utility software?
Utility software is system software designed to help manage, maintain, and control computer resources.
True or False: Antivirus software is a type of utility software.
True
Fill in the blank: __________ software is used to optimize the performance of a computer by cleaning up unnecessary files.
System maintenance
Which of the following is NOT a function of utility software? (A) Disk defragmentation (B) Word processing (C) File compression
B) Word processing
Name one type of utility software that can recover lost or deleted files.
Data recovery software
What does SQL stand for?
Structured Query Language
True or False: SQL is used to manage and manipulate relational databases.
True
Fill in the blank: SQL commands such as SELECT, INSERT, UPDATE, and DELETE are known as ____ statements.
DML (Data Manipulation Language)
What is a SQL injection?
A code injection technique that attackers use to exploit vulnerabilities in an application by inserting malicious SQL statements.
Which of the following is a common consequence of a successful SQL injection attack? (a) Data loss (b) Improved performance (c) Increased security
a) Data loss
True or False: Prepared statements can help prevent SQL injection attacks.
True
What is the purpose of the WHERE clause in a SQL statement?
To filter records that meet a specified condition.
Multiple choice: Which of the following is NOT a type of SQL statement? (a) SELECT (b) DELETE (c) EXECUTE (d) UPDATE
c) EXECUTE
What type of data does the SQL command ‘INSERT’ add to a database?
New records or rows
True or False: SQL injections can only occur in web applications that use SQL databases.
False
What is the primary purpose of protocol layers in networking?
To organize and standardize communication processes between different network devices.
True or False: Protocol layers help to simplify network design by breaking down complex processes into manageable parts.
True
Fill in the blank: The ______ layer is responsible for ensuring reliable data transmission between devices.
Transport
Which protocol layer is responsible for routing data packets across the network?
Network layer
Multiple Choice: Which of the following is NOT a benefit of using protocol layers? A) Modularity B) Interoperability C) Increased complexity D) Error handling
C) Increased complexity
