Function Of The Code string.lower Flashcards
Function of the code string.lower
Returns the data in the string in lower case
Description of a condition-controlled loop
The loop runs either while a condition is true or until a condition is true
Description and features of an array
- Data
- Stores multiple data items
- Of the same data type
- Under one identifier
- Can view as a table with many items
Searching a 1D array
Loop through each index in turn e.g.
For x=0 to last element index check array(x)
Next x
Description if a 2D array
View as a multi-row table
Purpose and use of SQL
- Structured query language
* Used to access, create, amend, delete, search, etc databases
Function of the SQL
SELECT fieldName
FROM table
WHERE conditions
- Select the fieldname(s) listed
- From the table named
- Where the conditions are true
Description of the array index
- The numeric position of an item in an array
* The first element is element 0
Searching a 2D array
Loop through each index in turns e.g.
FOR x=0 to 1st dimension last element index
FOR y=0 to 2nd dimension last element index
check array(x,y)
NEXT y
NEXT x
Description of a 1D array
Only one row in the table
Purpose of casting
Turning data of one type into another type e.g. the string “22” into the integer 22
Examples of Boolean operators
Used for comparisons; for example, in IF statements e.g. AND, OR, NOT
Examples of arithmetic operators
Used to represent mathematical functions e.g. +,*, -, /, ^
Description and example of a string
A series of characters e.g. Bob
Features of a subprogram
- Self-contained code
- Procedure or function
- Can be called from the main program(or subprograms)
- Returns control to the main program when finished
- Can receive parametres from main program
