IT Unit 2 (Databases) Part A

Which of the following are primary keys?

• CostumeHireGroupID

• CostumeID

• RentalID

• CustomerID

• FirstName

What is a composite key?

• A primary key made up of more than 1 field

• A foreign key that is also a primary key

• A primary key that does not uniquely identify a record

• A foreign key that is used in more than one table

Does the database design shown have a composite key?

• Yes

• No

Which of the following data are atomic?

• Mr Bob Bobson

• TA1 9PO

• Ford Capri

• Bogtown High School

Which of these are requirements for 1st Normal Form?

• Data must be atomic

• No repeating groups of data

• No repeated fields

• Each record is unique (has a primary key)

• It must look nice

How is a parameter created in a query to allow user input?

• Use square brackets [ ] around a question in the criteria row

• Tick the 'parameter' box in the field properties

• Use curly brackets { } around a question in the totals row

• Add a question in the criteria row using bold font

Which sort of check is used to ensure that data must be entered into a field?

• Presence check

• Length check

• Format check

• Range check

• Table lookup

Which sort of check is used to ensure that a text field can't be too long?

• Presence check

• Length check

• Format check

• Range check

• Table lookup

Which sort of check is used to ensure that a foreign key field can only be assigned to a valid record in another table?

• Presence check

• Length check

• Format check

• Range check

• Table lookup

Which type of test is used for data that is expected to save correctly?

• N (Normal)

• R (Erroneous)

• X (Extreme)

• I (Incorrect)