AICE Comp Sci Uni 8

What is a relational database?

• A collection of unrelated data

• A database stored in primary storage

• An organized collection of data connected to a specific topic

• A database that does not use tables

Which of the following is a reason to use a database?

• It decreases data redundancy

• It enables processing/querying of data

• It limits data access

• It complicates data retrieval

What is a primary key in a database?

• A field that can be duplicated

• A field that is distinctive for each record

• A field that is not used to identify records

• A field that is always numeric

What type of relationship is described by one instance of an entity corresponding to multiple instances of another entity?

• One-to-one

• One-to-many

• Many-to-one

• Many-to-many

Which of the following is an example of a Database Management System (DBMS)?

• Microsoft Word

• Adobe Photoshop

• SQLite

• Google Chrome

What is a feature of relational databases that ensures every row has an identifier?

• Referential Integrity

• Indexes

• Data Modelling

• Redundancy

What is the primary function of indexes in databases?

• To reduce data redundancy

• To enhance the speed of data retrieval operations

• To create a visual representation of data

• To ensure data integrity

Which of the following is an advantage of relational databases over file-based approaches?

• Increases data redundancy

• Increases program-data dependency

• Reduces data inconsistency

• Makes it harder to run complex queries

What is the process of creating a visual representation of a whole or part of an information system called?

• Referential Integrity

• Indexing

• Data Modelling

• Data Redundancy

Which issue can data modelling help avoid?

• Increased storage space

• Lack of consistency

• Faster data retrieval

• More complex queries