OCR Computer Science A Level Database concepts

What is the unique identifier for each object added to the database?

• Attribute1

• DoctorID

• DirectorName

• MovieTitle

Which type of database consists of a single file?

• Indexing

• Relational Database

• Flat File

• Entity Relationship Modelling

What is the process of coming up with the best possible design for a relational database called?

• Normalisation

• Indexing

• Referential Integrity

• Record Locking

Which method is used to store the position of each record when ordered by a certain attribute?

• Primary Key

• Secondary Key

• Foreign Key

• Indexing

What is the process of preventing simultaneous access of records in a database called?

• Redundancy

• Transaction Processing

• Referential Integrity

• Record Locking

Which SQL statement is used to collect fields from a given table?

• ADD

• SELECT

• UPDATE

• DELETE

What is the process of ensuring consistency in a database called?

• Atomicity

• Consistency

• Durability

• Isolation

Which level of normalisation ensures that no attribute can contain more than a single value?

• First Normal Form

• Second Normal Form

• Third Normal Form

• Fourth Normal Form

What is the process of having one or more copies of the data in physically different locations called?

• Flat File

• Entity Relationship Modelling

• Redundancy

• Indexing

Which method is used to combine rows from multiple tables based on a common field between them?

• SELECT

• JOIN

• CREATE

• UPDATE