2.2 part 2 SQL and Arrays

What is a 1 dimensional array?

• A variable with multiple values assigned to it

• A table with two named axes

• A single value stored in a variable

• A set of unrelated values

What is a 2 dimensional array?

• A table of information with two named axes

• A single row of data

• A variable with a single value

• A set of unrelated values

What is an example of a field from the table?

• Liverpool, Arsenal

• Club, MP, W, D, L

• Zero, One, Two

• Harry, Meg, Pablo

What is an example of a Record from the table?

• Liverpool, Arsenal

• Club, MP, W, D, L

• Zero, One, Two

• Harry, Meg, Pablo

What is the output of Print(ThisList[0])?

• Zero

• One

• Two

• Harry

What is the output of Print(ThisList[2])?

• Two

• Zero

• One

• Meg

What is the output of Print(ThisList[4])?

• Two

• Harry

• Pablo

• Meg

Which of the following is a 1 dimensional array example?

• ThisList = [1, 2, 4, 8, Harry, Pablo]

• ThisList = [[1, 2], [3, 4]]

• ThisList = [1, [2, 3], 4]

• ThisList = [1, 2, [3, 4]]

What is the output of Print(ThisList[1,2]) in the given 2D array?

• Teaching

• Hair

• Royalty

• Pablo

What is the output of Print(ThisList[0,0]) in the given 2D array?

• Teaching

• Hair

• Royalty

• Pablo