WorksheetsAICE CS Review Paper 1
Total questions: 93
Worksheet time: 47mins
What is the base number of digits that a binary system uses to represent numbers?
10
2
16
8
What is the maximum positive number that can be represented in an 8-bit binary system?
128
255
256
512
Which character encoding standard provides the greatest range of characters, using 2 or 4 bytes per character?
ASCII
Extended ASCII
Unicode
Binary Coded Decimal
What does the hexadecimal number '1E' equal in denary (decimal)?
30
28
16
20
What is the purpose of using Two's Complement in binary numbers?
To add binary numbers
To subtract binary numbers
To represent negative numbers
To convert binary to hexadecimal
What does pixel density measure in computer graphics?
The number of pixels per square inch
The number of pixels per centimeter
The brightness of the image
The color depth of the image
What is the result of increasing the sampling rate in sound digitization?
Decreases the accuracy of the digitized sound wave
Increases the file size
Reduces the file size
Makes the sound wave continuous
Which type of compression allows the original data to be perfectly reconstructed from the compressed file?
Lossy compression
Lossless compression
Vector compression
Bitmap compression
What is the primary advantage of using lossless compression over uncompressed files?
Increases the quality of the file
Reduces the time needed to search for data
Enhances the color depth of images
Decreases the sampling rate of sounds
How is a bitmap image's first row represented in Run-length Encoding (RLE)?
As a sequence of pixel colors
As a sequence of alternating black and white pixels
As a sequence of pixel counts and values
As a sequence of pixel brightness levels
What type of network topology is depicted in the diagram provided?
Star
Ring
Bus
Mesh
Which network model allows for decentralized data operations where each node operates both as a client and a server?
Client-server
Peer-to-peer
Centralized
Distributed
What is the primary advantage of using a client-server model over a peer-to-peer network?
Lower data transfer rate
Higher congestion
Centralized resource management
Lesser initial setup cost
In a client-server network, what role does a proxy server play?
Manages print jobs from client computers
Sends, receives, and stores emails
Manages database management systems
Accesses software and user's data files stored on the server
Which type of client relies solely on the server for processing and has no local storage?
Thin Client
Thick Client
Hybrid Client
Independent Client
What is a primary benefit of using copper cables in network setups?
Requires expensive optical transmitters and receivers
Less expensive and easier to install
Affected by electromagnetism
Doesn't perform well with small charges
Which type of network topology is described as having a central server (Switch) that all other computers connect to, allowing simultaneous and bi-directional sending of packets?
Star
Mesh
Hybrid
Bus
What is a major drawback of fiber-optic cables?
Lightweight and easy to install
Improved security
Needs expensive optical transmitters and receivers
Less expensive
Which network topology is characterized by each device being directly interconnected to each other?
Star
Mesh
Hybrid
Bus
What is a significant disadvantage of using radio waves for communication?
Can travel over large distances
Used for TV signals and mobile phone communications
Low frequency so transmits less data at one time
Larger bandwidth
How does Ethernet prevent data collision?
By using fiber-optic cables
Through CSMA/CD (Carrier Sense Multiple Access Collision Detection) method
By allowing only one device to transmit at a time
By using a dedicated server
What is the bit rate defined as in the context of streaming media?
The quality of the video
The number of bits transmitted per second
The speed of the internet connection
The type of media being streamed
Which of the following is a benefit of cloud computing?
Increased data privacy
Higher storage capacity and infrastructure power
Limited access to resources
Dependency on a single server
What is the primary function of a router in a network?
To store data
To provide a unique MAC address to each device
To connect networks and manage data traffic between them
To increase the speed of the internet connection
What is the main difference between public cloud and private cloud?
Public cloud is cheaper than private cloud
Public cloud is owned by one organization, while private cloud is shared
Public cloud services are accessible via a browser by multiple parties, while private cloud is dedicated to one organization
Private cloud offers less security than public cloud
Which device provides each end-system in a wired LAN with a unique MAC address?
Router
Network Interface Card (NIC)
Wireless Network Interface Card (WNIC)
Bridge
What is the primary function of a repeater in network communication?
Connects two cables
Encrypts data
Assigns IP addresses
Filters spam
Which device allows a device to connect to the Internet using a telephone line?
Router
Modem
Switch
Repeater
What does PSTN stand for?
Public Switched Telephone Network
Private Secure Transfer Node
Public Sector Transmission Network
Personal Standard Telecommunication Network
What is the primary difference between IPv4 and IPv6 addresses in terms of bits?
IPv4 has 32 bits, IPv6 has 128 bits
IPv4 has 128 bits, IPv6 has 32 bits
IPv4 has 64 bits, IPv6 has 256 bits
IPv4 has 256 bits, IPv6 has 64 bits
Which of the following is a characteristic of subnet masks?
They allow public IP addresses to be routed within the subnet
They encrypt data packets
They increase the speed of the network
They provide wireless connectivity
What is the purpose of NAT (Network Address Translation)?
To allow private IP addresses to access internet directly
To prevent private IP addresses from accessing the internet directly
To assign dynamic IP addresses
To filter harmful data from entering a network
Which type of IP address is generally used when a device needs to maintain the same IP address for a long period, such as when hosting a website?
Dynamic IP address
Static IP address
Public IP address
Private IP address
What is the primary purpose of secondary storage in computers?
To store the computer's operating system exclusively
To process data quickly and efficiently
To store data that is not frequently accessed but is still necessary
To increase the RAM capacity of the computer
Which component in a computer system is responsible for executing instructions and processing data?
Hard disk
RAM
CPU
Secondary storage
What is a key difference between resistive and capacitive touchscreens?
Resistive touchscreens require a stylus, while capacitive do not
Capacitive touchscreens can detect multiple touches, while resistive cannot
Resistive touchscreens are more durable than capacitive
Capacitive touchscreens use electrical current, while resistive use mechanical pressure
How does a laser printer create an image on paper?
By pressing ink directly onto paper
By using a laser to change the color of the paper
By transferring toner to paper using a laser and electrical charge
By burning the image onto the paper with a high-intensity light
What is the function of the floating gate in a solid state flash memory?
It controls the flow of electrons for reading data
It stores electrons and represents either 1 or 0
It enhances the speed of data transfer
It acts as a temporary storage before data is written to the disk
What type of memory loses its content when the power is turned off?
Non-volatile memory
Volatile memory
Static RAM
EEPROM
Which type of ROM can be erased by UV light exposure and then reprogrammed?
PROM
EEPROM
EPROM
Dynamic RAM
What is the function of an actuator in a control system?
To transfer signals
To measure properties
To switch on/off heavy appliances
To store data
What is the output of an AND gate if both inputs are high (1)?
0
1
Depends on the system
None of the above
Which type of RAM is more complex and hence more expensive due to its design?
Static RAM
Dynamic RAM
EPROM
EEPROM
What is the function of a NOT gate in digital circuits?
It outputs 1 when all inputs are 0.
It outputs 0 when all inputs are 1.
It outputs 1 when any input is 1.
It outputs 0 when any input is 0.
Which register holds the address of the next instruction to be fetched?
Program Counter (PC)
Memory Data Register (MDR)
Memory Address Register (MAR)
Accumulator (ACC)
What is the primary role of the Control Unit (CU) in a CPU?
Executes arithmetic and logical operations
Stores data temporarily
Decodes fetched instructions and synchronizes operations
Holds values that are processed by arithmetic and logical operations
Which model is described as using a single processor that follows a linear sequence of fetch-decode-execute operations?
Harvard architecture
Von Neumann architecture
ARM architecture
Quantum computing model
What is the purpose of the Immediate Access Store (IAS) in a CPU?
It is a memory unit that can be directly accessed by the processor.
It is a register that stores the current instruction.
It is a bus that transfers data between components.
It is a register that holds the results of arithmetic and logical operations.
What is the primary function of the address bus in a computer system?
To transmit data between the CPU and peripheral devices
To carry the location of main memory locations for input/output operations
To increase the clock speed of the CPU
To store commonly used instructions in the cache memory
What happens when the clock speed of a CPU is increased?
The number of instructions executed in a given time decreases
The CPU overheats due to not being able to remove heat fast enough
The size of the cache memory automatically increases
The CPU performs fewer instructions
What is the role of cache memory in a CPU?
It decreases the CPU's execution time for instructions
It stores peripheral device management instructions
It increases the number of cores in a CPU
It stores commonly used instructions to speed up processing
How do multicore CPUs enhance computer performance?
By reducing the physical size of the CPU
By executing multiple instructions simultaneously through different cores
By increasing the cache memory size
By transmitting video and audio data through HDMI
What is the function of an Interrupt Service Routine (ISR) in handling interrupts?
It decreases the CPU's clock speed
It controls the processor differently during the occurrence of an interrupt
It connects peripheral devices through ports
It executes the main program without interruptions
What does the assembler do with mnemonics and labels during the first pass of assembling machine code?
Converts them into binary values
Creates a symbol table and assigns specific addresses
Reports any errors found
Translates source code into machine code in one sweep
What is the purpose of the LDI operation in assembly language?
Store the contents of ACC into an address
Load contents of an address into ACC indirectly
Add contents of a register to ACC
Jump to an address if a condition is true
Which operation is used to add 1 to the contents of the ACC register?
ADD
STO
INC
CMP
What type of addressing uses the contents of the Index Register to form the address to be used as an offset?
Direct addressing
Indirect addressing
Indexed addressing
Relative addressing
How does a right shift (LSR #n) affect the bits in a binary number?
Multiplies the number by shifting bits to the left
Divides the number by shifting bits to the right
Adds zeros to the left of the binary number
Subtracts by shifting bits to the left
What is the purpose of an arithmetic shift in computer operations?
To compare values in the accumulator
To carry out multiplication and division of signed integers
To clear bits in a register
To shift bits for encryption purposes
Which operation is used with a 1 in bit masking to set an individual bit position?
A) AND operation
B) OR operation
C) XOR operation
D) NOT operation
What is a key function of an operating system?
To provide internet connectivity
To control communication between user and hardware
To manage network traffic
To optimize application performance
What is the main purpose of memory management in an operating system?
To ensure data encryption
To manage user permissions
To ensure two programs do not use the same memory space
To increase processing speed
Which of the following is a security management task performed by an operating system?
Allocating time slots for programs
Ensuring data privacy
Enhancing graphical user interface
Managing external device connections
What is the primary function of utility software in a computer system?
To manage computer hardware and peripherals
To enhance the computer's performance by managing files and disk space
To provide synchronization between devices
To translate high-level language into machine code
Which of the following is a benefit of using program libraries?
Reduces the size of the main .EXE file
Increases the need for disk defragmentation
Slows down the computer's overall performance
Requires more frequent virus checks
What is the main advantage of using a compiler over an interpreter?
No .exe file is created
Execution is very slow
The program does not need to be compiled again, resulting in faster execution
Allows real-time error correction
What is the purpose of disk defragmentation software?
To remove viruses from the computer
To compress file sizes on the disk
To reorganize disk contents for better performance
To synchronize devices
Which software is used to translate assembly language statements into machine code?
Compiler
Interpreter
Assembler
Utility Software
What is the primary function of an Integrated Development Environment (IDE) in programming?
To store data in relational databases
To provide tools for coding, debugging, and testing software
To manage user access rights in a database
To optimize high-level queries in a database
Which of the following is NOT a feature of a File Based System?
Data stored in discrete files
Enforces control on organization/structure of files
Sorting must be done manually or with a program
Security is not sophisticated
What does a Query Processor do in a Database Management System (DBMS)?
Executes programs line-by-line to debug them
Handles high-level queries by parsing, validating, and optimizing them
Stores data in discrete files on a computer
Manually changes each file when data is updated
Which of the following best describes the concept of 'Data Integrity' in a DBMS?
The database allows multiple users to modify data simultaneously
The database automatically backs up data when changes are made
The database prevents users or applications from entering inconsistent data
The database requires manual sorting of data
What is the role of 'Indexing' in a relational database?
To provide a means of executing programs line-by-line
To store data in non-redundant interrelated data tables
To provide fast access when searching on a specific attribute
To display choices of keywords and available identifiers
What does the 1st Normal Form (1NF) require in a relational database design?
No repeating attribute or groups of attributes, and each tuple and attribute intersection must contain only 1 value.
All attributes depend on the primary key.
Removal of all many-to-many relationships.
Each table must contain only one primary key.
According to the 2nd Normal Form (2NF), what additional condition must be met beyond the requirements of 1NF?
No repeating attributes.
Every non-primary key attribute is fully dependent on the primary key.
All attributes must be dependent on each other.
Each table should have only one primary key.
What is a key requirement for a database structure to meet the 3rd Normal Form (3NF)?
No transitive dependencies between attributes.
All attributes must be composite.
Each table should have multiple primary keys.
All non-key elements are partially dependent on the primary key.
Which SQL command is used to create a new table in a database?
CREATE DATABASE
ALTER TABLE
CREATE TABLE
ADD PRIMARY KEY
What is the purpose of the ALTER TABLE command in SQL?
To delete a table.
To modify the structure of an existing table.
To create a new table.
To query data from a table.
What is the primary function of Data Manipulation Language (DML) in SQL?
To define the structure of a database
To query and maintain data
To control access to the database
To establish relationships between tables
Which SQL clause is used to sort the results of a query in ascending order?
GROUP BY
ORDER BY
JOIN
SELECT
What does the SQL operator "IS NULL" check for?
Values that are duplicates
Values that are not equal to a specified value
Values that are zero
Values that are not assigned a value
Which of the following best describes the concept of 'Free Software Foundation'?
Software that is sold legally without any restrictions
Software that gives users freedom to run, copy, distribute, study, change and improve the software
Software that is available for free but only for a specific evaluation period
Software that requires payment before it can be used
What is the main ethical concern addressed by Computer Ethics?
Ensuring that software is distributed for free
Regulating how computing professionals should make decisions regarding professional and social conduct
Guaranteeing that all software is open source
Preventing the use of computers in healthcare
What is the primary purpose of data security in computer systems?
To ensure that the computer system is energy efficient
To protect data against loss and unauthorized access
To increase the processing speed of the computer
To monitor user activities on the computer
Which of the following is NOT a threat to computer and data security?
Encryption
Malware
Spyware
Virus
What is the role of firewalls in computer security?
To detect and remove viruses
To filter information traveling between the computer system and the internet
To increase data storage capacity
To enhance the graphical user interface
How can phishing be mitigated according to the document?
By using strong passwords
By ignoring suspicious emails and using SPAM filters
By encrypting all data transmissions
By regularly updating the operating system
What is the difference between data security and system security as described in the document?
Data security focuses on protecting data on a computer system, while system security focuses on protecting the computer system itself
Data security is about speed optimization, whereas system security is about preventing physical damage
Data security deals with user interface improvements, system security deals with hardware upgrades
There is no difference; both terms are interchangeable
What is the purpose of data validation in computer systems?
To check if the data entered is accurate and reliable
To increase the speed of data processing
To enhance the graphical user interface
To expand the storage capacity
Which method of data verification involves entering the data twice and comparing the two entries?
Visual Verification
Double Entry
Parity Check
Checksum Check
What does a range check in data validation ensure?
Data follows a specific pattern or order
Data has the exact number of characters required
Data is within acceptable minimum and maximum values
Data exists in the database
What is a checksum used for in data transfer?
To verify that data is entered visually correct
To ensure all bytes are added together and any errors are identified
To check the length of data
To ensure data follows a specific format
What happens if a parity check during data transfer finds an odd number of 1s in a byte, but an even number is expected?
The data is accepted without errors
The data is retransmitted
The error is ignored
The system shuts down
