In a database, the word attributes are
- Properties of a database
- Properties of a field
- Properties of a record
- Properties of an entity
Which one of these databases is most likely to be a flat file?
- A student's CD collection
- A newsagent's customer records.
- The database of a county council
- A college MIS
Which one of these is a feature of a relational database compared with a flat file?
- There is data redundancy
- Data are consistent
- Data are not sharable
- If one field is changed, all programs accessing the data need to be changed.
Which one of these is a problem when data are held on a relational database?
- Relationships have to be made between tables.
- Much of the data are redundant
- Data are not consistent.
- The data are not secure.
The interface between the database and the applications accessing it is called
- A relational database
- A flatfile database
- A ralational database management system.
- Database administrator.
In a relational database a relationship is best described as:
- a link between two entities
- a link beween two attributes
- a link between two fields
- a link between two records.
Which one of these relationships cannot be dealt with by a relational database?
- One to one
- Many to one
- One to many
- Many to Many.
The process by which data are stored in tables in the most efficient way is called.
- Optimisation
- Normalisation
- Defragmentation
- Compression
If there are no repeating attributes or groups of attributes, data are said to be:
- Redundant
- First Normal Form
- Second Normal Form
- Third Normal Form
When data are in third normal form, this means that:
- The supplier data are dependent only on the supplier ID
- The supplier data are dependent of a key field that is NOT the supplier ID
- the supplier data are dependent on both the supplier ID and another key field.
- The supplier data are not linked to the rest of the database.
Which one of the following statements is always true about standard notation.
- It can only be used to represent normalised data.
- It always has to be written in the Leszynski-Reddick convention.
- The table name is in upper case, and the attributes are in brackets ().
- The table name is in upper case, the attributes are in brackets (), and the key fields are underlined.
Which one of the following is NOT likely to be found in a database dictionary?
- Names of fields.
- Frequency of back ups.
- Which programs can access the data.
- Security of the data.
Which one of these functions would be carried out by the database management system?
- Design the tables
- Normalise the data
- Back up the data
- Determine the entity relationships.
Which of these queries processes the data in some way?
- Sort query
- Select Query
- Cross tab query
- Update query.
Many database management systems run queries in:
- SQL
- Visual Basic
- Pascal
- C++