Font size
WorksheetsComputer Scince Quizz - Feb 2025
Total questions: 25
Worksheet time: 22mins
Answer the question shown in the image.
(a)
State the simplified versions of the following Boolean expression
¬ ¬A
(¬A Λ ¬B)
¬(¬A Λ ¬B)
A
None of the above
What is the simplified form of (¬A Λ ¬B)?
A ∨ B
¬(A ∨ B)
¬A ∨ B
¬(A Λ B)
What is the simplified form of P ∨ Q?
Q ∨ P
P Λ Q
¬P ∨ Q
¬Q ∨ P
What is the simplified form of P ∨ (Q ∨ R)?
(P ∨ Q) ∨ R
P Λ Q
¬(P ∨ Q)
P ∨ Q ∨ R
What is the simplified form of P Λ (Q ∨ R)?
P ∨ Q ∨ R
(P Λ Q) ∨ (P Λ R)
(P ∨ Q) Λ R
¬P ∨ Q
State the simplified version of the following Boolean expression:
¬(¬A Λ ¬B)
(a)
What is the simplified form of ¬(A ∧ (B ∨ C))?
¬A ∨ (¬B ∧ ¬C)
(¬A ∨ ¬B) ∧ ¬C
¬A ∨ ¬B ∨ ¬C
¬A ∧ (¬B ∨ ¬C)
A university stores student information in a single large spreadsheet. As the university grows, managing student grades, personal details, and course enrollments becomes cumbersome, with frequent data duplication and errors.
What type of database system would help the university better organize this data?
Flat-file database
Relational database
Hierarchical database
NoSQL database
A library has a table for books where each book has a unique ISBN number. They also have a table for borrowing records, and each record includes the ISBN of the borrowed book.
In this database design, what role does the ISBN play in the borrowing records table?
Primary key
Composite key
Candidate key
Foreign key
A company wants to make sure that no employee’s department assignment appears more than once in their records, keeping the data clean and efficient.
What stage of normalization ensures that no repeating groups or arrays exist in a table?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Aldi has over 45,000 employees working across multiple store locations. The company maintains an Employee table that stores details such as EmployeeID, Name, StoreLocation, and Salary. Some store managers noticed salary anomalies where certain employees were getting different salaries despite having the same job title and experience.
To ensure salary consistency among employees with the same job title, which normalization form should Aldi apply?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Aldi recently launched an online shopping platform. When a customer places an order, multiple steps occur: order placement, payment processing, and order dispatch. If any step fails (e.g., payment is declined), the entire transaction should be rolled back.
Which database property ensures that either all steps of a transaction succeed or none at all?
Durability
Isolation
Atomicity
Consistency
A call center uses full-duplex communication for customer support. Agents can speak to customers while receiving responses, with no delay or need to switch between talking and listening.
Which type of transmission is used in a full-duplex communication system?
Simplex
Half-duplex
Sequential
Full-duplex
A streaming service, such as Netflix, needs to deliver high-definition (HD) video without buffering. To maintain smooth playback, the bit rate is optimized to ensure fast enough data transmission.
Which metric is used to determine how much data can be transmitted per second for services like Netflix streaming?
Bit rate
Parity bit
Latency
Throughput
Aldi’s online payment system relies on TCP (Transmission Control Protocol) for reliable data transmission. However, occasionally, packets are lost during transmission.
How does TCP handle packet loss in Aldi’s payment system?
It ignores the lost packets and continues transmission.
It speeds up the process by using fewer packets.
It re-transmits lost packets to ensure the complete data is delivered.
It uses UDP to bypass the issue.
A car manufacturing company uses robotic arms to assemble vehicles on the production line. The robotic arms are programmed to perform specific tasks like welding, attaching bolts, and painting. Instead of coding each robotic arm individually for every car model, the engineers have created a set of generalized instructions that are abstracted into modular "tasks" like “weld component” or “paint part.” These abstract instructions are reused across different car models, reducing the need for repetitive programming.
What advantage does the company gain by abstracting robotic tasks into modular instructions?
It makes the robotic arms work independently without supervision.
It increases the complexity of programming because tasks must be unique for each car.
It eliminates the need for any programming of robotic arms.
It allows for reusability and reduces programming effort across car models.
A health-tracking app based in the UK has users input sensitive personal health data, including weight, exercise routines, and diet. The app collects this information to offer personalized recommendations. However, users did not realize that the app also shares anonymized data with external research organizations for marketing and product development purposes. Several users expressed concern about how their data was used without their full understanding, claiming they were not adequately informed of this practice during the sign-up process.
Which principle of the Data Protection Act 1998 is most likely being violated?
Personal data must be processed transparently and fairly.
Personal data must not be used for purposes beyond the scope of consent.
Personal data must not be transferred to external parties without legal safeguards.
Personal data must be kept secure.
A game development team wants an efficient way to store player data without wasting memory.
Which linked list type reduces memory overhead?
Single Linked List
Doubly Linked List
Circular Linked List
Self-Referencing List
A logistics company tracks the number of deliveries made by 5 of its drivers each day of the week. They store this information in a data structure where each driver has a fixed number of slots (7 for the days of the week).
Which data structure is most appropriate for storing this information?
Stack
Queue
Array
Linked List
What is the difference between a compiler and an interpreter?
A compiler translates the entire program at once, while an interpreter translates one line at a time.
A compiler is faster than an interpreter.
A compiler translates the program into machine code, while an interpreter executes the program directly.
All of the above
A growing e-commerce website notices that its product pages take a long time to load for returning customers. To address this, the developers implement a caching strategy where product images, descriptions, and reviews are stored locally on users' browsers. However, some users report seeing outdated product prices.
What likely caused the outdated product prices on the website?
The cache size is too small to store product prices.
The cache retrieval process is slower than usual.
The original server is down, causing a cache miss.
Cache validation was not performed to check for updates.
A banking application processes thousands of transactions per second. It needs a unit capable of performing calculations like adding balances, checking account limits, and verifying transactions.
Which part of the CPU is responsible for performing these calculations?
Program Counter (PC)
Cache
Arithmetic Logic Unit (ALU)
Control Unit (CU)
A startup develops a speech recognition AI to transcribe customer calls in real time. Their system initially uses a high-performance CPU, but processing takes too long. Engineers consider using a GPU to improve speed.
Why would a GPU be more efficient for this task than a CPU?
GPUs have higher clock speeds than CPUs
GPUs process instructions sequentially
CPUs consume less power than GPUs
GPUs can perform thousands of calculations in parallel
A gaming laptop uses high-resolution textures and ray tracing to render lifelike graphics.
Which processor is best suited for this task?
ALU
GPU
Co-Processor
Control Unit
