2.4 Computational thinking Flashcards

1
Q

Why do computers use binary?

A

Computers use 1s and 0s to represent the flow of electricity in their circuits.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a NOT gate?

A

A NOT gate takes an input and

outputs the opposite.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is an AND gate?

A

For an AND gate to give an output of

1, both inputs must be 1.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is an OR gate?

A

For an OR gate to give an output of 1, either inputs must be 1.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How are records stored in text files?

A

Stored on the secondary storage
Used to store data when application is closed
Useful for small volumes od data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How are records stored in arrays and lists?

A

Stored in the RAM
Used to store data when a program is running
Use indexes to refer to data items

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How are records stored in databases?

A

Often stored on remote servers
Often used to store data shared by man users
Data is stored in records and fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a record structure?

A

A collection of related fields

A field is a variable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the three steps in making use of record structures?

A

Define the record structure
Declare a variable or array to use with the record structure
Assign and retrieve data from the variable record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is SQL used for?

A

To create, delete, modify and manipulate records in a databse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the basic SQL commands?

A

SELECT - which fields to be returned. *can be used to indicate all fields

FROM - which table. Databases can have more than one table, each with their own unique name

WHERE records meet a condition. LIKE can be used as a wildcard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Why do you need to test a program?

A

To ensure there are no errors in the code
To check that the program has an acceptable performance
To ensure that unauthorised access is prevented
To check the program meets the requirements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Why do you need to test a program?

A

To ensure there are no errors in the code
To check that the program has an acceptable performance
To ensure that unauthorised access is prevented
To check the program meets the requirements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is iterative testing?

A

Each new module is tested as it written
Checking new modules does not introduce new errors
Test to ensure the program handles erroneous data
Performed whilst the software is being developed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is Final/Terminal testing?

A

Testing that all modules work together

Performed when the program is finished

How well did you know this?
1
Not at all
2
3
4
5
Perfectly