OCR A Level CS 1.4 Database Structure and Handling Quiz

What is the process of using scenario information to produce an initial data model for a database?

• Logical data modelling

• Data structuring

• Database maintenance

• Entity abstraction

What is an entity in the context of a database?

• A property of an entity

• A database admin tool

• A relationship between entities

• An item about which data is stored

What is the key aspect of looking at how entities form relationships in a database?

• Relationship irregularities

• Data structure complexity

• Entity resolution

• Data dependency

What is the primary purpose of a database structure?

• To be easily maintainable

• To be easily changeable

• To be easily searchable

• To be easily updatable

What is the purpose of a conceptual data model in database design?

• To identify primary keys

• To identify secondary keys

• To work out data dependencies

• To resolve relationship irregularities

What is the purpose of a composite primary key in a database table?

• To identify secondary keys

• To identify foreign keys

• To create redundant relationships

• To create complete uniqueness

What is the purpose of a foreign key in a database table?

• To create redundant relationships

• To reference existing items

• To identify primary keys

• To identify secondary keys

What is the most common method of query design in database systems?

• Select query

• Query by example

• Append query

• Update query

What type of query is used to find data based on criteria and can also be used to sort the results?

• Delete query

• Update query

• Select query

• Append query

What are forms used for in a database system?

• To obtain and display data on-screen

• To modify data

• To remove records

• To add additional records