Programing Fundementals Flashcards

1
Q

What is an integer?

A

A whole number

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

What is a float/real?

A

A number with a decimal

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

What is a character?

A

A single number, letter or other ASCII character

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

What is a string?

A

0 or more characters eg. A word

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

What type of data does Boolean use?

A

True or false

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

How much storage would an integer usually use?

A

2 bytes

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

How much storage would a float or real usually use?

A

4 bytes

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

How much storage would a character usually use?

A

1 byte

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

How much storage would a string usually use?

A

1 byte per character

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

How much storage would a Boolean value usually use?

A

One bit

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

What is casting?

A

Converting between data types

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

What are the 3 basic programming constructs?

A
  • Selection
  • Sequence
  • Iteration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is selection?

A

A section of code that will only run if a certain statement is true

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

What is sequence?

A

A set of instructions, followed one after the other

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

What is iteration?

A

A repeating process (usually set by a FOR loop)

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

What does MOD do?

A

Give the remainder from a division

17
Q

What does DIV do?

A

Give the result of a division without the remainder

18
Q

In what two ways can you manipulate strings?

A
  • Concatenation
  • Slicing
19
Q

What is concatenation?

A

Joining two strings together

20
Q

What is slicing?

A

Selecting only a certain section of a string

21
Q

What does SQL stand for?

A

Structured Query Language

22
Q

What are rows known as in a database?

A

Records

23
Q

What are columns known as in a database?

A

Fields

24
Q

What does SELECT do in SQL?

A

Select which fields should be returned

25
Q

What does FROM do in SQL?

A

Select the table the data should be taken from

26
Q

What is * used for in SQL?

A

To select all fields

27
Q

What does WHERE do in SQL?

A

Identify a condition returned values must follow eg. WHERE age > 18

28
Q

What file handling operators are there?

A
  • Read
  • Write
29
Q

What needs to happen before and after a file is operated on?

A
  • Needs to be opened first
  • Needs to be closed after