AS Level Revision

Question 1

Why is acting ethically in software development important?

Accepted Answer

It builds trust and avoids harm

Question 2

Which logic gate gives a true output only when both inputs are true?

Accepted Answer

AND

Question 3

What is the main purpose of using encryption in data transmission?

Accepted Answer

To protect data confidentiality

Question 4

What is the purpose of a primary key in a database table?

Accepted Answer

To ensure data integrity and uniquely identify records

Question 5

What is the key difference between DRAM and SRAM?

Accepted Answer

DRAM needs to be refreshed, SRAM does not

Question 6

Which SQL statement would you use to select all fields from a table named "Students"?

Accepted Answer

SELECT * FROM Students

Question 7

What is the main function of an ER diagram?

Accepted Answer

To visually represent entity relationships in a database

Question 8

In Boolean algebra, what does A' mean?

Accepted Answer

NOT A

Question 9

What is the function of a "query" in a database?

Accepted Answer

To retrieve specific data from one or more tables

Question 10

Which component in a system typically stores data permanently?

Accepted Answer

Hard Disk Drive (HDD)

Question 11

What is an advantage of a control system over manual control?

Accepted Answer

Consistent and automatic operation

Question 12

What is the function of an actuator in a control system?

Accepted Answer

To carry out a physical action

Question 13

What SQL statement is used to modify a table's structure?

Accepted Answer

ALTER

Question 14

Which of the following best describes an expert system?

Accepted Answer

A system that mimics human decision-making using a knowledge base

Question 15

Which life cycle model involves going through stages one after another in order?

Accepted Answer

Waterfall model

Question 16

What is the main drawback of using embedded systems?

Accepted Answer

They cannot be easily upgraded

Question 17

What does data integrity refer to?

Accepted Answer

Ensuring accuracy and consistency of data

Question 18

What is the function of a temperature sensor in a control system?

Accepted Answer

To detect heat levels

Question 19

What is the primary purpose of a database management system (DBMS)?

Accepted Answer

To store, retrieve, and manage data efficiently

Question 20

What is the main purpose of normalisation in databases?

Accepted Answer

To reduce redundancy and improve integrity

Question 21

Which of the following is NOT a valid data type in most databases?

Accepted Answer

Image

Question 22

What is the primary difference between RAM and ROM?

Accepted Answer

RAM is volatile; ROM is non-volatile

Question 23

Which of the following is a type of malware?

Accepted Answer

Virus

Question 24

Which of the following defines an embedded system?

Accepted Answer

A system designed to perform a specific task

Question 25

Which of the following is a method of protecting a network computer?

Accepted Answer

Installing antivirus software

Question 26

What does DDL stand for in SQL?

Accepted Answer

Data Definition Language

Question 27

What type of sensor would be used in a burglar alarm to detect motion?

Accepted Answer

Infra-red sensor

Question 28

Which of the following is a feature of embedded systems?

Accepted Answer

They are built into larger systems to perform specific tasks

AS Level Revision

Questions 28

AS Level Revision

Questions 28