WorksheetsFundamentals of Databases
Total questions: 20
Worksheet time: 10mins
What is a database?
A database is an organized collection of data stored electronically.
A database is a type of software used for web browsing.
A database is a collection of random files without structure.
A database is a physical location where data is stored.
Define the term 'table' in a database context.
A table is a structured collection of data in rows and columns in a database.
A table is a type of database query.
A table is a graphical representation of data in a database.
A table is a single row of data in a database.
What is a primary key?
A primary key is a duplicate identifier for records.
A primary key is an optional field in a database table.
A primary key is a unique identifier for a record in a database table.
A primary key is a type of foreign key.
Explain the concept of a foreign key.
A foreign key is a unique identifier for a record in the same table.
A foreign key is a field that contains only null values.
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two.
A foreign key is a type of index that speeds up database queries.
How do you create a new table in Microsoft Access?
Right-click on the database, select 'Add Table', and choose a template.
Open Microsoft Access, go to 'Home' tab, select 'New Table', and enter data directly.
Open Microsoft Access, click on 'File', then 'New', and select 'Blank Table' from the menu.
Open Microsoft Access, go to 'Create' tab, select 'Table Design', define fields, and save the table.
What is the purpose of relationships in a database?
To eliminate the need for data normalization
To store data in a single table only
To create visual representations of data only
The purpose of relationships in a database is to connect and organize data across different tables, ensuring data integrity and facilitating efficient data retrieval.
Name the three types of relationships in databases.
One-to-Few
Single-to-Multiple
Many-to-One
One-to-One, One-to-Many, Many-to-Many
What is a one-to-many relationship?
A one-to-many relationship is an association where one entity is related to multiple instances of another entity.
A one-to-many relationship is an association where two entities are related equally to each other.
A one-to-many relationship is a type of relationship where one entity has no connections to other entities.
A one-to-many relationship is when multiple entities are related to one instance of another entity.
What is a select query used for?
To update existing records in a database.
To retrieve data from a database.
To delete data from a database.
To create new tables in a database.
What data type would you use for a person's name in Access?
Long Text
Number
Short Text
Date/Time
What is the difference between a text field and a memo field in Access?
Both text fields and memo fields can store the same amount of text, up to 65,536 characters.
The main difference is that a text field is limited to 255 characters, while a memo field can store much larger amounts of text, up to 65,536 characters.
A text field can store up to 1,000 characters, while a memo field is limited to 255 characters.
A text field is used for numeric data, while a memo field is used for dates.
How do you join two tables in a select query?
Use the UNION operator to join two tables in a SELECT query.
Combine tables by listing them in the FROM clause without a condition.
Use the JOIN clause with a condition to combine two tables in a SELECT query.
Use the SELECT clause to merge two tables directly.
What is the function of a database management system (DBMS)?
To provide a user interface for web applications.
To manage and control access to the database, ensuring data integrity and security.
To store data in a physical format only.
To create visual reports from data without any processing.
What is the role of a foreign key in a relational database?
A foreign key is used to uniquely identify a record in the same table.
A foreign key is an optional field that can contain duplicate values.
A foreign key is a field that links to the primary key of another table, establishing a relationship.
A foreign key is a type of index that improves query performance.
What is the purpose of a query in a database?
To store data in a more compact format.
To visualize data in graphical formats.
To retrieve, update, or delete data from a database.
To create new tables and define their structure.
What does the term 'data integrity' refer to in databases?
Data integrity refers to the accuracy and consistency of data over its lifecycle.
Data integrity is the process of backing up data regularly.
Data integrity is the method of encrypting data for security.
Data integrity is the ability to store large amounts of data efficiently.
What is the role of a secondary key in a database?
A secondary key is used to uniquely identify a record in a table.
A secondary key is an optional field that can contain duplicate values.
A secondary key is a field that helps in retrieving data more efficiently but does not uniquely identify a record.
A secondary key is a type of primary key.
What is the purpose of a primary key in a database?
A primary key is optional and can be left blank.
A primary key is a unique identifier for each record in a table.
A primary key can contain duplicate values.
A primary key is used to link two tables together.
How can you enforce data integrity in a database?
By using primary keys and foreign keys to establish relationships.
By regularly backing up the database.
By limiting the size of the database.
By using only text fields for all data types.
What is the purpose of a foreign key constraint in a database?
To ensure that a foreign key value must match a primary key value in another table.
To create a backup of the database.
To allow duplicate values in a foreign key field.
To automatically delete records in the primary table when a related record is deleted.
