Wuanberri Start free
← Back to Databases

Databases final exam

Fifteen questions on all of Databases. Answer all 15 to see your score. Questions are drawn from a bank of 45, so every attempt is different.

0 of 15 answered

Question 1 of 15

Changing an index without changing applications illustrates:

Question 2 of 15

The relational model represents data as:

Question 3 of 15

A primary key must be:

Question 4 of 15

Referential integrity requires foreign key values to:

Question 5 of 15

In relational algebra, a join can be expressed as:

Question 6 of 15

WHERE email = NULL returns no rows because:

Question 7 of 15

Which clause filters aggregated groups?

Question 8 of 15

Customers who never ordered are found with:

Question 9 of 15

A window function such as SUM(amount) OVER (PARTITION BY customer ORDER BY date) computes:

Question 10 of 15

A recursive CTE is especially useful for:

Question 11 of 15

Parameterised queries protect against:

Question 12 of 15

The N+1 query problem is typically fixed by:

Question 13 of 15

In ER modelling, a relationship attribute such as grade belongs to:

Question 14 of 15

A many-to-many relationship is implemented as:

Question 15 of 15

A transitive dependency violates:

Back to all units