N5 Computing

A string is a group of characters held together. To store more than one character, use the string data type. String is used more often than character. A firstname would be held as a string e.g. ________.

• Hannah

• ORDER BY

• A

• !

• 7

ORDER BY is a keyword that lets you order the results of a query, either in ascending order or descending order. SELECT * FROM City WHERE Country = 'Scotland' ORDER BY CityName DESC; Would return all records from the city table where the country field holds 'Scotland'. Records would show in descending order of the values held in the CityName field. Descending means from Z-A.

• True

• False

A character is a single letter, number or symbol. Examples: A ! 7 The character data type is used to store one single character only.

• Hannah

• ORDER BY

• A

• !

• 7

A real number is a number that includes a decimal value. The real data type is often called 'Single' when using a programming language. Real numbers are used to store positive or negative numbers that include a decimal value e.g. 21.54 -54.12423

• Hannah

• ORDER BY

• A

• !

• 7

An attribute is a characteristic of an entity and becomes a field in a database. For example, the attributes of the pupil entity could be first name, surname, pastoral care teacher etc.

• True

• False

At the design stage, it is only necessary to state the following: Fields, tables, criteria and sort order. Short hand can be used for the terms Ascending (ASC) and Descending (DESC).

• True

• False

A restricted choice only allows certain pre-determined values to be entered in a field and will not accept anything else. Drop down menus on a flight booking site are a good example.

• True

• False

A program is robust if it can handle unexpected input without crashing. This means that it will make use of input validation algorithms that return messages if incorrect input is entered.

• True

• False

An INSERT query will add a new record to a table. There is usually no criteria to consider.

• True

• False

The purpose of software is usually defined in a few short paragraphs, providing a written statement of what the software should do.

• True

• False