Worksheets9618 AS Comp Sci Full Revision Set 1
Total questions: 45
Worksheet time: 23mins
Name
Class
Date
1.
Which prefix represents 1024 bytes?
a)
Kibi
b)
Kilo
c)
Mebi
d)
Mega
2.
What is the binary representation of the decimal number 13?
a)
1011
b)
1101
c)
1001
d)
1110
3.
What is the main difference between a bitmap image and a vector graphic?
a)
File size
b)
Image resolution
c)
Image encoding method
d)
Screen resolution
4.
In a network, what is the primary function of a router?
a)
Connecting devices within a LAN
b)
Forwarding data packets between networks
c)
Preventing network collisions
d)
Providing wireless connectivity
5.
What does RAM stand for?
a)
Random Access Memory
b)
Read Only Memory
c)
Rapid Access Memory
d)
Reliable Access Memory
6.
Which logic gate outputs 1 only if both inputs are 0?
a)
NOR
b)
XOR
c)
NAND
d)
AND
7.
What is the primary difference between SRAM and DRAM?
a)
Speed and stability
b)
Voltage requirements
c)
Storage capacity
d)
Physical size
8.
In sound encoding, what does increasing the sampling rate do?
a)
Increases file size
b)
Decreases file size
c)
Increases sound quality
d)
Both A and C
9.
What is a primary advantage of using lossless compression?
a)
Smaller file size
b)
No loss of data
c)
Better for images
d)
Better for sound files
10.
Which network topology is the most fault-tolerant?
a)
Bus
b)
Star
c)
Mesh
d)
Hybrid
11.
What is the purpose of subnetting in a network?
a)
To divide an IP address space into smaller segments
b)
To increase network speed
c)
To provide network security
d)
To assign static IP addresses
12.
Which network model relies on a central server to manage resources and services?
a)
Client-server
b)
Peer-to-peer
c)
Hybrid
d)
None of the above
13.
Which of the following is a type of non-volatile memory?
a)
RAM
b)
ROM
c)
SRAM
d)
DRAM
14.
What type of compression would be best for a high-quality photograph?
a)
Lossy
b)
Lossless
c)
Run-length encoding
d)
Huffman coding
15.
In the context of networking, what does LAN stand for?
a)
Local Access Network
b)
Logical Area Network
c)
Large Area Network
d)
Local Area Network
16.
Which of the following is a special purpose register?
a)
Program Counter (PC)
b)
General Purpose Register (GPR)
c)
Both A and B
d)
None of the above
17.
What is the role of the Arithmetic and Logic Unit (ALU) in a CPU?
a)
Performing arithmetic and logical operations
b)
Controlling the execution of instructions
c)
Managing memory access
d)
Coordinating input and output devices
18.
Which of the following is not a mode of addressing in assembly language?
a)
Immediate
b)
Direct
c)
Absolute
d)
Indexed
19.
What is the purpose of an interrupt in the Fetch-Execute cycle?
a)
To speed up the execution of instructions
b)
To change the order of instructions executed
c)
To temporarily halt the execution of instructions for a higher-priority task
d)
To reduce the complexity of the Fetch-Execute cycle
20.
What is the main disadvantage of using an interpreter instead of a compiler for high-level language programs?
a)
Lack of error checking
b)
Increased memory usage
c)
Slower execution speed
d)
Incompatibility with certain programming languages
21.
Which of the following is a method of data validation?
a)
Visual check
b)
Checksum
c)
Range check
d)
Parity check
22.
What is the primary purpose of a firewall?
a)
To protect a computer system from malware
b)
To encrypt data sent over the internet
c)
To manage user accounts and authentication
d)
To ensure data integrity during data transfer
23.
What is the main function of the Control Unit (CU) in a CPU?
a)
Performing arithmetic and logical operations
b)
Controlling the execution of instructions
c)
Managing memory access
d)
Coordinating input and output devices
24.
Which of the following is a method of data verification during data entry?
a)
Format check
b)
Length check
c)
Double entry
d)
Limit check
25.
In the context of ethics in computing, what is the primary purpose of joining a professional ethical body like the BCS or IEEE?
a)
To receive certifications and recognition
b)
To gain access to exclusive resources and networks
c)
To demonstrate commitment to ethical conduct and professionalism
d)
To learn new programming languages
26.
Which of the following best describes an embedded system?
a)
A general-purpose computer designed for a wide range of tasks
b)
A special-purpose computer designed to perform a specific function within a larger system
c)
A server that manages resources and services for multiple clients
d)
A computer that is specifically designed for gaming and multimedia applications
27.
What is the role of the system clock in a CPU?
a)
To synchronize the operations of the CPU components
b)
To generate unique addresses for memory locations
c)
To perform arithmetic and logical operations
d)
To control the execution of instructions
28.
What is the primary function of the Memory Address Register (MAR) in a CPU?
a)
To store the address of the next instruction to be executed
b)
To store the data being read from or written to memory
c)
To store the address of the current instruction being executed
d)
To store the address of a memory location to be accessed
29.
What is the main purpose of using buffers in a computer system?
a)
To reduce the complexity of data storage and retrieval
b)
To increase the speed of data access
c)
To temporarily hold data while it is being transferred between devices or processes
d)
To reduce the likelihood of data corruption
30.
Which of the following is an application of Artificial Intelligence (AI)?
a)
Data compression
b)
Password encryption
c)
Spam filtering
d)
Facial recognition
31.
What is the main limitation of using a file-based approach for data storage and retrieval?
a)
Limited data security
b)
Slow data retrieval
c)
No support for relationships between data
d)
All of the above
32.
Which of the following is NOT a feature of a relational database?
a)
Normalization
b)
Data integrity
c)
Data security
d)
Linear search
33.
Which term refers to a unique identifier for each record in a database table?
a)
Primary key
b)
Foreign key
c)
Secondary key
d)
Candidate key
34.
Which of the following is NOT a type of relationship in a relational database model?
a)
One-to-many
b)
Many-to-many
c)
One-to-none
d)
One-to-one
35.
What does the Second Normal Form (2NF) in the normalization process require?
a)
No repeating groups
b)
No partial dependencies
c)
No transitive dependencies
d)
All primary keys defined
36.
In the context of Database Management Systems, what is the purpose of a data dictionary?
a)
To store metadata about the database
b)
To translate data between languages
c)
To provide a backup for the database
d)
To manage user access
37.
Which of the following is a Data Definition Language (DDL) command in SQL?
a)
SELECT
b)
INSERT INTO
c)
UPDATE
d)
CREATE TABLE
38.
What does the SQL command "ALTER TABLE" do?
a)
Creates a new table
b)
Deletes an existing table
c)
Modifies an existing table
d)
Inserts a new record into a table
39.
What is the main purpose of an Entity-Relationship (E-R) diagram?
a)
To document a database design
b)
To store data in a database
c)
To display data from a database
d)
To define relationships between data
40.
Which of the following is NOT an example of Data Manipulation Language (DML)?
a)
SELECT
b)
CREATE DATABASE
c)
INSERT INTO
d)
UPDATE
41.
What is the purpose of abstraction in computational thinking?
a)
To include all details of a system
b)
To focus on essential details of a system
c)
To break down problems into sub-problems
d)
To improve the efficiency of an algorithm
42.
What is the main characteristic of a linear search algorithm?
a)
It compares each element sequentially
b)
It always requires a sorted list
c)
It has a logarithmic time complexity
d)
It's a comparison sort
43.
What type of data structure is most suitable for representing a collection of student names?
a)
1D array
b)
2D array
c)
Stack
d)
Queue
44.
What is the main difference between a procedure and a function in programming?
a)
A function returns a value, while a procedure does not
b)
A procedure returns a value, while a function does not
c)
A function can be used in expressions, while a procedure cannot
d)
A procedure can be used in expressions, while a function cannot
45.
In the context of software development, what is the purpose of a structure chart?
a)
To decompose a problem into sub-tasks
b)
To document a database design
c)
To define relationships between data
d)
To test an algorithm
100 %
