SLR23 | Databases

What is an Entity Relationship Diagram (ERD) used for in database design?

• To represent the flow of data in a network

• To visually represent the relationships between entities in a database

• To calculate the storage capacity of a database

• To encrypt data within a database

Which of the following is an example of an attribute in a database?

• A table

• A column in a table

• A database

• A relationship

What is the purpose of normalising a database to third normal form?

• To increase redundancy

• To eliminate data anomalies and ensure data integrity

• To decrease the number of tables

• To increase the complexity of the database

Which of the following best describes a primary key?

• A key that can be used to encrypt data

• A unique identifier for each record in a table

• A key that links two tables together

• A key that is composed of multiple attributes

What is a composite primary key?

• A primary key that is composed of multiple attributes

• A primary key that is used in multiple tables

• A primary key that is automatically generated

• A primary key that is used to encrypt data

What is a foreign key used for in a relational database?

• To uniquely identify each record in a table

• To link records in one table to records in another table

• To encrypt data within a table

• To define the structure of a table

In a one-to-many relationship, how many records in the second table can be associated with a single record in the first table?

• One

• Many

• None

• Exactly two

Which SQL command is used to retrieve data from a database?

• INSERT

• DELETE

• SELECT

• UPDATE

What is the main advantage of a client-server database system?

• It allows for simultaneous access by multiple clients

• It is easier to set up than a standalone database

• It requires less security

• It is faster than a distributed database

How can concurrent access be controlled in a database system?

• By using encryption

• By using locks and transactions

• By using a single-user mode

• By using a backup system