2.2 SQL & Records

What does SQL stand for

• Structures Question Language
• Strong Question Language
• Structured Query Language

A record is....

• A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))
• A collection of data about a single entity (e.g. a student)
• A unique piece of data about an entity (student surnames)
• An identifier for the single piece of data (e.g. ‘surnames’)

A field name is....

• A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))
• A collection of data about a single entity (e.g. a student)
• A unique piece of data about an entity (student surnames)
• An identifier for the single piece of data (e.g. ‘surnames’)

A field is....

• A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))
• A collection of data about a single entity (e.g. a student)
• A unique piece of data about an entity (student surnames)
• An identifier for the single piece of data (e.g. ‘surnames’)

A table is....

• A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))
• A collection of data about a single entity (e.g. a student)
• A unique piece of data about an entity (student surnames)
• An identifier for the single piece of data (e.g. ‘surnames’)

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

Which SQL statement is used to extract data from a database?

• OPEN
• GET
• SELECT
• EXTRACT