NEW 1.3.2 Databases

When considering a single database transaction what property can be described as, 'a transaction must be performed in complete isolation so that other processes can’t have access to the data'?

• Consistency
• Durability
• Isolation
• Atomicity

Which normal form can be described as, 'a table with no normalisation. All data and all fields are in one table. A flat file'?

• First Normal Form (1NF)
• Un-normalised (0NF / UNF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)

Which is the correct definition of the database term, 'record'?

• All the fields relevant to an entity
• A collection of records representing one entire set of data within a database
• One type of data from a database table e.g. Forename or Age
• An index used to speed up searching and sorting of data

A company has employed a number of people to carry out a survey into the shopping habits of local residents in a town centre, this will involve talking to customers face to face. What method of data capture would you recommend?

• Paper based form
• Electronic Data Interchange (EDI)
• Radio frequency identification (RFID)
• Comma Separated Values (CSV)

When considering a single database transaction what property can be described as, 'once a change has taken place to a database the change must not be lost'?

• Consistency
• Atomicity
• Isolation
• Durability

Which is the correct definition of the following database term, 'foreign key'?

• When more than one field is combined to create a unique primary key for a table
• A key field which can be used to access records speeding up searching and sorting
• The linking field in a table that is a primary key in a related table
• A field that uniquely identifies a record in a table

Which normal form can be described as, 'every non-primary key attribute is fully dependant on the primary key. That is, all the incomplete dependencies have been removed'?

• First Normal Form (1NF)
• Third Normal Form (3NF)
• Un-normalised (0NF / UNF)
• Second Normal Form (2NF)

Which is the correct definition of the following database term, 'secondary key'?

• The linking field in a table for defining a relationship
• A field that uniquely identifies a record in a table
• A key field which can be used to access records speeding up searching and sorting
• When more than one field is combined to create a unique primary key for a table

When considering a single database transaction what property can be described as, 'a change in a database must be either completely performed or not performed at all'?

• Durability
• Consistency
• Isolation
• Atomicity

Which of the following is an advantage of a flat file database over a relational database?

• They minimise on the amount of repeating data
• They are more efficient and quicker to query
• They are easy to design
• They are more secure