Chapter 4

Question 1

Data is….

Answer 1

Information

Question 2

Character

Answer 2

A single character

Question 3

String

Answer 3

A list of characters

Question 4

A strongly typed language is….

Answer 4

You must STATE THE VARIABLE TYPE when creating a variable

Question 5

What is a weakly typed programming language.

Answer 5

The language guesses what data type should be used

Question 6

Counts how many characters eg. ***(orange) -> 6

Answer 6

Len(string)

Question 7

‘orange’.**() -> Orange

Answer 7

String.capitilize()

Question 8

‘BanAna’.*****() - banana

Answer 8

String.lower()

Question 9

‘Banana’.*****() - BANANA

Answer 9

String.upper()

Question 10

Moves to the right eg. ‘Dog’.*****(50) - Dog

Answer 10

String.rjust(number)

Question 11

‘Dog’.****(‘o’,’i’) - dig

Answer 11

String.replace(oldvalue, newvalue))

Question 12

Splits into list eg. ‘Myname’.*****(‘y’) - [‘my,’name’]

Answer 12

String.split(separator)

Question 13

Remove characters from the beginning and the end of the string.

Answer 13

String.strip(chatacters)

Question 14

Converts a list into string where each item in the list is joined by that string. Eg.

‘+’.**([‘Bill’,’Barney’,Ben’)] ——> Bill+Barney+Ben

Answer 14

String.join(list)

Question 15

Locates the index position of the first character of the substring. Eg.

‘The missing word’.**(‘miss’) —> 4

Answer 15

String.find(substrings)

Question 16

Changes items in a string eg.

“My name is {name} and I am {age} years old.”.****(name = Bob, age = ‘27’) —> My name is bob and I am 27 years old

Answer 16

String.format(items)

Question 17

Newline

Answer 17

\n

Question 18

Tab

Answer 18

\t

Question 19

\”

Answer 19

Print quote mark

Question 20

\\

Answer 20

Print backslash

Question 21

Concatenation is a fancy word for…

Answer 21

Combining strings and lists.

Question 22

Element

Answer 22

An item of data

Question 23

An array

Answer 23

A variable that contains many items of data

Question 24

A static array

Answer 24

Defined, unchangeable size

Question 25

Dynamic array

Answer 25

Size can change

Question 26

Record

Answer 26

A collection of data about a particular subject

Question 27

A database

Answer 27

A structured and managed set of data held on a computer

Question 28

Table

Answer 28

A sheet of data in a database

Question 29

Field

Answer 29

An item of information expressed as a column in a table

Question 30

Entry

Answer 30

A record of data elements expressed as rows of a table

Question 31

Cell

Answer 31

An Item of data in a table

Question 32

SQL - *

Answer 32

Wildcard selects all fields

Question 33

SQL layout

Answer 33

Select : the data you are interested in
From : the table you are interested in
Where : the condition you are interested in