#12 Databases
Authored by Claire Buckler
others
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1. Define a relational database.
A. A set of organised information held in a table
B. An organised, persistent store of data organised into related tables
C. A set of tables and validation rules
D. A structured collection of tables where blank fields are not allowed
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
2. How does a flat file differ from a relational database?
A. All data is held in one table, causing data redundancy
B. Data is held in one table but validation rules cannot be applied
C. It is not possible to query (or filter) data in a flat file database
D. Searches for data are much faster in a flat file database
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
3. What is a primary key?
A. It is a unique identifier for each record in a database
B. It is a unique identifier for each field in a database
C. It is a unique identifier for each field in a table
D. It is a unique identifier for each record in a table
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
4. Which of the following could make a suitable primary key in a table of adult residents of a town?
A. Gender
B. Landline phone number
C. Surname
D. National Insurance number
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
5. How are foreign keys used in relational databases?
A. They act as a validation rule, ensuring the right type of data is input
B. They act as a referential constraint, cross-referencing to a record in another table to prevent data redundancy
C. They uniquely identify each record in a table
D. They allow two or more field values to jointly uniquely identify a record within a table
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
6. If a table called CUSTOMERS has a primary key called CustomerNumber and a separate table called SALES has a foreign key called CustomerToCharge, which of these is true?
A. The value of CustomerToCharge is a cross-reference to one of the values of CustomerNumber in the CUSTOMERS table, and referential integrity will check that any values entered for CustomerToCharge already exist in the CUSTOMERS table somewhere in the CustomerNumber column
B. All values of the primary key column CustomerNumber must be used at some point in the CustomerToCharge column
C. All values of the foreign key column CustomerToCharge must be unique in the SALES table
D. Referential integrity cannot be applied to this scenario because there is a one-to-many relationship between the two tables
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
7. When a non-key column/field is used as a secondary key, which of these advantages is derived?
A. It speeds up searches when the non-key column is searched because it is now indexed
B. It applies the rule that all values in the non-key column must now be unique
C. It means that the index on the secondary key column will be reconstructed each time the table changes
D. The table now benefits from having two primary keys
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
