Unit 2.2 Programming Techniques L3

In Record structures, VARCHAR keyword means

• A field can be any number of characters or bytes in length

• A field can be up to a certain number of characters or bytes in length

• A field is an integer

• The name of the field is about to be changed

The following is true about Records

• They must have an index

• Fields are made up of records

• Records can combine multiple data types in their fields

• Record arrays are 2D arrays

SQL is used to work with files in this format

• Plain text

• CSV

• Proprietary binary

• Spreadsheets

The following is true about SQL

• It has loops just like any other language

• SQL is case sensitive

• SQL is hard to read due to a lot of abbreviated keywords

• SQL usually runs on top of another language

The purpose of SELECT * FROM Pupils WHERE Result>90 is

• To set every Pupil’s result to 90

• To retrieve a collection of records of Pupils but only those whose result is 90

• To retrieve a collection of records of Pupils but only those whose result is over 90

• To retrieve a collection of records of Pupils but only those whose name is over 90

The LIKE operator is used to

• Approve SQL statements before execution

• Replace the WHERE statement

• When we deal with Boolean fields

• To use partial matching when searching

Nested SELECT queries are used

• When Boolean operators get too complex

• When retrieving data from multiple tables When using partial matching

• When using partial matching

• For validation and quality control

When we read or write text files, we are working with this data type

• Integers

• Booleans

• Reals

• Strings

EOF is used in

• To indicate the end of a line with a formatting delimiter

• Conditional loops when writing to a file

• Conditional loops when reading from a file

• Destructive overwriting of the file’s data

The following is not a valid file open mode

• Insert

• Append

• Read

• Write