Question 1

What is the role of a compiler in the software development process?

Accepted Answer

To translate source code into machine code

Answer

To design user interfaces

Answer

To test software applications

Answer

To manage databases

Question 2

Which algorithm is used to find the shortest path in a graph with weighted edges?

Accepted Answer

Dijkstra's algorithm

Answer

Merge sort

Answer

Bubble sort

Answer

Quick sort

Question 3

Which algorithm is used to sort elements in a specific order by repeatedly comparing adjacent elements and swapping them if they are in the wrong order?

Accepted Answer

Bubble sort

Answer

Insertion sort

Answer

Selection sort

Answer

Binary search

Question 4

Which algorithm is used to search for a target value within a sorted array by repeatedly dividing the search interval in half?

Accepted Answer

Binary search

Answer

Selection sort

Answer

Bubble sort

Answer

Insertion sort

Question 5

What is the purpose of a structure chart in software design?

Accepted Answer

Illustrate the organization and hierarchy of modules

Answer

Debug code errors

Answer

Generate test cases

Answer

Design user interface

Question 6

What is the first stage in the compilation process in CIE A Level computer science?

Accepted Answer

Lexical analysis

Answer

Syntax analysis

Answer

Semantic analysis

Answer

Code generation

Question 7

Which stage of the compilation process in CIE A Level computer science checks for grammar rules in the source code?

Accepted Answer

Syntax analysis

Answer

Semantic analysis

Answer

Code generation

Answer

Lexical analysis

Question 8

Which stage of the compilation process in CIE A Level computer science translates the source code into an intermediate representation like assembly code?

Accepted Answer

Code generation

Answer

Lexical analysis

Answer

Semantic analysis

Answer

Syntax analysis

Question 9

What is the final stage in the compilation process in CIE A Level computer science where the machine code is generated?

Accepted Answer

Code generation

Answer

Semantic analysis

Answer

Lexical analysis

Answer

Syntax analysis

Question 10

Which stage of the compilation process in CIE A Level computer science involves checking for logical errors and ensuring that the code makes sense?

Accepted Answer

Semantic analysis

Answer

Syntax analysis

Answer

Code generation

Answer

Lexical analysis

Question 11

Which of the following is responsible for translating high-level code into machine code during the compilation process in CIE A Level computer science?

Accepted Answer

Compiler

Answer

Debugger

Answer

Assembler

Answer

Interpreter

Question 12

Which phase in the compilation process of CIE A Level computer science analyzes the meaning of the code and ensures it follows the rules of the programming language?

Accepted Answer

Semantic analysis

Answer

Lexical analysis

Answer

Code generation

Answer

Syntax analysis

Question 13

What testing method involves providing a specific set of inputs and examining the outputs to ensure they are correct?

Accepted Answer

Black-box testing

Answer

Integration testing

Answer

User acceptance testing

Answer

White-box testing

Question 14

Which testing method involves testing how well different components work together?

Accepted Answer

Integration testing

Answer

Black-box testing

Answer

Unit testing

Answer

Regression testing

Question 15

Which testing method involves using test cases derived from the internal code structure?

Accepted Answer

White-box testing

Answer

System testing

Answer

Black-box testing

Answer

Integration testing

Question 16

What is the purpose of an index in a database?

Accepted Answer

Improving the speed of data retrieval operations

Answer

Encrypting sensitive data fields

Answer

Storing large binary files

Answer

Displaying user-friendly error messages

Question 17

What is a foreign key in a relational database?

Accepted Answer

A field that links to a primary key in another table

Answer

An encrypted password field

Answer

A field that stores only numerical data

Answer

A field that is unique for each record

Question 18

What is the purpose of normalization in database design?

Accepted Answer

Minimizing redundancy and dependency by organizing fields and table of a database

Answer

Adding duplicate records for security purposes

Answer

Maximizing redundancy and dependency for faster access

Answer

Ignoring data organization for simplicity

Question 19

Which query language is commonly used to retrieve data from relational databases?

Accepted Answer

SQL

Answer

Python

Answer

Java

Answer

HTML

Question 20

What is the primary key in a relational database used for?

Accepted Answer

Uniquely identifying each record in a table

Answer

Displaying images

Answer

Storing text data

Answer

Calculating averages

Question 21

What is data integrity in the context of computer science?

Accepted Answer

The assurance that data is accurate, complete, and consistent

Answer

The process of encrypting data

Answer

The ability to store large amounts of data

Answer

The speed at which data is accessed

Question 22

What is the purpose of data validation in ensuring data integrity?

Accepted Answer

To verify that data entered into a system meets certain criteria for accuracy and validity

Answer

To increase the storage capacity of the system

Answer

To permanently lock data from any changes

Answer

To randomly rearrange data for security

Question 23

Which of the following is a characteristic of a table in 1st normal form (1NF)?

Accepted Answer

Each attribute contains only atomic values

Answer

Attributes can be repeated within the table

Answer

Each record has a unique key

Answer

Attributes are not required to have a defined data type

Question 24

What is the primary goal of achieving 1st normal form (1NF) in database design?

Accepted Answer

To eliminate repeating groups within a table

Answer

To enforce data validation rules

Answer

To organize data into multiple tables

Answer

To establish relationships between tables

Question 25

In the context of database normalization, what does it mean for a table to be in 1st normal form (1NF)?

Accepted Answer

Each column must contain single, indivisible values

Answer

The table must have no duplicate records

Answer

The table must have a primary key

Answer

The table must be fully normalized

Question 26

When applying 1st normal form (1NF) to a database table, what does it mean for attributes to be atomic?

Accepted Answer

Each attribute should contain indivisible values

Answer

Attributes should be combined into composite keys

Answer

Attributes should be repeated within the table

Answer

Attributes should have a defined data type

Question 27

What is the main purpose of normalizing a database to second normal form (2NF)?

Accepted Answer

To remove partial dependencies between non-prime attributes and candidate keys

Answer

To eliminate duplicate rows in a table

Answer

To ensure all data is stored in a single table

Answer

To organize data into multiple tables

Question 28

In the context of database normalization, what is a partial dependency?

Accepted Answer

When a non-prime attribute is dependent on only a portion of a composite candidate key

Answer

When a table contains duplicate rows

Answer

When a primary key is not specified for a table

Answer

When all attributes are fully functionally dependent on the candidate key

Question 29

Why is it important to normalize a database to Second Normal Form (2NF)?

Accepted Answer

To prevent anomalies caused by partial dependencies between non-prime attributes and candidate keys

Answer

To increase storage space efficiency

Answer

To separate data into multiple tables

Answer

To speed up database query performance

Question 30

How does Second Normal Form (2NF) improve database performance?

Accepted Answer

By reducing data redundancy and preventing partial dependencies

Answer

By adding more duplicate rows in the tables

Answer

By increasing the storage space required for data

Answer

By combining all data into a single table

Question 31

What is the primary goal of normalizing a database to Second Normal Form (2NF)?

Accepted Answer

To ensure non-prime attributes are fully functionally dependent on the candidate key

Answer

To merge multiple tables into a single table

Answer

To increase the complexity of database queries

Answer

To store data in a denormalized structure

Question 32

What is the primary difference between First Normal Form (1NF) and Second Normal Form (2NF) in database normalization?

Accepted Answer

1NF deals with atomicity of data while 2NF deals with dependencies between non-prime attributes and candidate keys

Answer

1NF separates data into multiple tables while 2NF combines all data into a single table

Answer

1NF focuses on data integrity while 2NF focuses on data redundancy

Answer

1NF requires unique keys for each table while 2NF allows duplicate keys

Question 33

In CIE A Level computer science, which of the following best describes 3NF (Third Normal Form)?

Accepted Answer

A relation is in 2NF and every non-prime attribute is fully functionally dependent on the primary key

Answer

A relation is in 1NF but not in 2NF

Answer

A relation is in 3NF but not in 2NF

Answer

A relation is in 4NF and every attribute is fully functionally dependent on the primary key

Question 34

Why is it important to normalize databases into 3NF in CIE A Level computer science?

Accepted Answer

To reduce data redundancy and improve data integrity

Answer

To complicate queries and slow down database performance

Answer

To increase data redundancy and decrease data integrity

Answer

To limit the amount of data that can be stored in the database

Question 35

What does it mean for a relation to be in 3NF in CIE A Level computer science?

Accepted Answer

A relation is in 2NF and every non-prime attribute is fully functionally dependent on the primary key

Answer

A relation is in 1NF and every non-prime attribute is partially functionally dependent on the primary key

Answer

A relation is in BCNF and every attribute is fully functionally dependent on the primary key

Answer

A relation is in 3NF and some non-prime attributes are not functionally dependent on the primary key

Question 36

Which of the following is a key advantage of normalizing a database into 3NF in CIE A Level computer science?

Accepted Answer

Minimizing the storage space required for the database

Answer

Slowing down database query performance

Answer

Increasing the complexity of queries

Answer

Maximizing data redundancy for easy retrieval

Question 37

What is virtual memory in an operating system?

Accepted Answer

A memory management technique that uses disk space as an extension of RAM

Answer

A functionality that creates virtual copies of files on the desktop

Answer

A feature that allows users to play virtual reality games

Answer

A tool for virtualizing hardware components

Question 38

What is the main function of a file system in an operating system?

Accepted Answer

To manage and organize data stored on storage devices

Answer

To design user interfaces

Answer

To analyze network traffic

Answer

To handle multimedia playback

Question 39

Which type of RAM is known for its faster access times but higher power consumption?

Accepted Answer

SRAM

Answer

Flash

Answer

DRAM

Answer

MRAM

Question 40

Which type of RAM is commonly used as the main memory in computers?

Accepted Answer

DRAM

Answer

MRAM

Answer

SRAM

Answer

ROM

Question 41

What is the primary difference between IPv4 and IPv6?

Accepted Answer

IPv4 uses 32-bit addresses while IPv6 uses 128-bit addresses

Answer

IPv4 uses letters as addresses while IPv6 uses numbers

Answer

IPv4 uses 128-bit addresses while IPv6 uses 32-bit addresses

Answer

IPv4 does not support encryption while IPv6 does

Question 42

Which of the following is a limitation of IPv4 that led to the development of IPv6?

Accepted Answer

Limited address space

Answer

Fast data transmission speed

Answer

Compatibility issues with Windows OS

Answer

High security vulnerabilities

Question 43

Which of the following is a benefit of using IPv6 over IPv4?

Accepted Answer

Increased address space

Answer

Higher likelihood of security breaches

Answer

Slower data transmission speed

Answer

Decreased compatibility with existing devices

Question 44

Which type of interrupt has the highest priority in a computer system?

Accepted Answer

hardware interrupt

Answer

maskable interrupt

Answer

software interrupt

Answer

non-maskable interrupt

Question 45

What is the main advantage of using interrupts in a computer system?

Accepted Answer

to improve system efficiency by allowing the processor to handle multiple tasks concurrently

Answer

to increase the clock speed of the processor

Answer

to reduce the amount of memory used by the system

Answer

to simplify the programming process for software developers

Question 46

Which of the following is an example of an external hardware interrupt?

Accepted Answer

keyboard input

Answer

running out of memory

Answer

infinite loop in a program

Answer

division by zero error

Question 47

What is the purpose of interrupts in a computer system?

Accepted Answer

to temporarily halt the normal program flow to handle a specific event

Answer

to increase storage capacity

Answer

to prevent software bugs

Answer

to speed up program execution

Question 48

What is the main purpose of a router in a computer network?

Accepted Answer

To route data packets between different networks

Answer

To encrypt data for security

Answer

To connect devices using cables

Answer

To store data temporarily

Question 49

What is an IP address used for in networking?

Accepted Answer

Identifying devices on a network

Answer

Storing data on a server

Answer

Playing online games

Answer

Sending emails

Question 50

What is the purpose of a subnet mask in a network?

Accepted Answer

To identify which portion of an IP address is the network part and which is the host part

Answer

To establish a secure VPN connection

Answer

To filter spam emails

Answer

To assign unique MAC addresses to devices

Question 51

What is the function of a DNS server in a computer network?

Accepted Answer

To translate domain names into IP addresses

Answer

To block malicious websites

Answer

To detect network intrusions

Answer

To encrypt data transmissions

Question 52

What is the purpose of a firewall in a computer network?

Accepted Answer

To monitor and control incoming and outgoing network traffic

Answer

To increase the speed of data transmission

Answer

To expand the storage capacity of servers

Answer

To create secure passwords for user accounts

Question 53

What is the purpose of a MAC address in a computer network?

Accepted Answer

To uniquely identify network devices at the hardware level

Answer

To block access to specific websites

Answer

To prevent malware infections

Answer

To compress data for faster transmission

Question 54

What is the role of a gateway in a computer network?

Accepted Answer

To connect different networks together

Answer

To store data on a central server

Answer

To install security updates on devices

Answer

To establish video conference calls

Question 55

What is a many-to-many relationship in entity relationships?

Accepted Answer

A type of relationship where each entity in one table can be related to multiple entities in another table

Answer

A relationship that does not require a foreign key

Answer

A one-to-one relationship between two entities

Answer

A relationship where one entity can only be related to one entity in another table

Question 56

What is an attribute in the context of entity relationships?

Accepted Answer

A characteristic or property of an entity

Answer

A type of relationship between tables

Answer

A category of entities in a database

Answer

A primary key of a table

Question 57

What is the purpose of a composite key in entity relationships?

Accepted Answer

To uniquely identify a record using multiple columns

Answer

To combine multiple entities into one table

Answer

To store binary data in a database

Answer

To group related tables together

Question 58

What is referential integrity in the context of entity relationships?

Accepted Answer

Ensuring that relationships between tables remain consistent and valid

Answer

Ignoring foreign key constraints

Answer

Mixing data types in a single column

Answer

Allowing duplicate values in a primary key column

Question 59

What is the role of the arithmetic and logic unit (ALU) in the Von Neumann model?

Accepted Answer

To perform arithmetic and logical operations on data

Answer

To handle input/output functions for the system

Answer

To interpret instructions and direct the operation of the system

Answer

To store data temporarily for processing

Question 60

What is the purpose of the first pass of a two-pass assembler?

Accepted Answer

To collect labels and symbols in the program

Answer

To execute the program line by line

Answer

To generate machine code directly

Answer

To optimize the program for faster execution

Question 61

What task is typically performed during the second pass of a two-pass assembler?

Accepted Answer

Generating the actual machine code for the program

Answer

Running the program to test for errors

Answer

Checking the syntax of the source code

Answer

Collecting labels and symbols in the program

Question 62

What is a potential disadvantage of using a two-pass assembler compared to a single-pass assembler?

Accepted Answer

Requires more memory to store symbol table information

Answer

Produces less optimized machine code

Answer

Takes longer time to assemble large programs

Answer

Has limited support for high-level language features

Question 63

What is the primary role of the symbol table in a two-pass assembler?

Accepted Answer

To store information about labels and their memory addresses

Answer

To analyze the syntax of the source code

Answer

To generate intermediate code for the program

Answer

To simulate the program execution before actual assembly

Related quizzes

Related quizzes