#12 Databases

#12 Databases

20 Qs

quiz-placeholder

Similar activities

Localizações Geográficas

Localizações Geográficas

7th Grade - University

18 Qs

Ellen Richardson's Blog

Ellen Richardson's Blog

KG - University

18 Qs

Linea recta

Linea recta

KG - University

15 Qs

INFORMATIKA 7

INFORMATIKA 7

7th Grade

18 Qs

Mr. Kasih Test of Aplication letter Kelas XII

Mr. Kasih Test of Aplication letter Kelas XII

KG - University

21 Qs

PANILAIAN TENGAH SEMESTER 2 PAI & BP KELAS 5

PANILAIAN TENGAH SEMESTER 2 PAI & BP KELAS 5

KG - University

22 Qs

MARIO KART ll (PARTE II)

MARIO KART ll (PARTE II)

KG - University

23 Qs

#12 Databases

#12 Databases

Assessment

Quiz

others

Practice Problem

Hard

Created by

Claire Buckler

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?