Valaki segít infó leckében?

Questions

1. What are databases primarily used for?

To store archived data

To store and organise data

To analyse data

2. What is the difference between an entity and an attribute?

An attribute is a table in a database and an entity is a field

An attribute is a record in a database and an entity is a table

An attribute is a field in a database and an entity is a table

3. Why would you create a primary key?

To make each record in a database unique

To make each field in a database unique

To make each query in a database unique

4. What is a relational database?

A database that is built from a set of unique tables containing data about one entity

A database with one single large table

A set of many databases about numerous, related topics

5. What are the main characteristics of a relational database?

Built upon one large table containing all the attributes, used to record a limited amount of

data

Built from a set of unique tables, each with a primary key, linked together with

relationships

A collection of separate tables in which all the data for the system is stored

6. What is a foreign key?

A foreign key is a field that is a unique identifier in that entity

A foreign key is a field that does not belong in that table

A foreign key is a primary key that appears in another table to create a relationship

between the two tables

7. What would you use a query for?

To export and present information from a database

To enter data into a database

To search and filter a database

8. What is an entity?

A table in a database

A field in a database

A record in a database

9. Why would you create a report?

To store data in the database

To present data in a user-friendly way

To search the database

10. What type of relationship exists between a person and national insurance number?

One to One

One to Many

Many to Many

11. What type of relationship exists between courses and students?

One to One

One to Many

Many to Many

12. What type of relationship exists between a company and employees?

One to One

One to Many

Many to Many

13. Which of the following is a tool to store, edit and organise data in a database?

A database

A database management system (DBMS)

SQL

14. In terms of databases, what is meant by security?

Only the most important data is kept in a secure place

Different access rights cannot be assigned to different users

All data is kept in a secure place and different access rights can be assigned to different

users