Data types and programming techniques Flashcards
Data types
Integer - whole number
Float - decimal
Character - single letter
String - more than one character
Real - decimal
Boolean - TRUE/FALSE
What is concatination
connecting of strings or characters next to each other
What is casting
Changing the data type of a variable
What can you use to find the length of a string
len()
What is a files two modes of operation
Read from
Write to
How can you open a file called scores.txt
file = openRead(“scores.txt”)
How would you write to a file called scores.txt
file = openWrite(“scores.txt”)
How do you close a file
file.close()
How can data be received
SELECT
FROM
WHERE
What does SELECT do
Selects data from the database
What does FROM do
Specifies which table to select data from
What does WHERE do
Filters a result set to include only records that fulfil a specified condition
What is an array
A data structure which holds similar, related data.
the data in an array must all be of the same data type
What is all data stored under in an array
An identifier
What is a row
It goes horizontally across
