Databases, indexes & transactions

Question 1 of 8

The 'D' in ACID guarantees that:

Question 2 of 8

Which anomaly does the READ COMMITTED isolation level still allow?

Question 3 of 8

A B-tree index on (last_name, first_name) can efficiently serve a query filtering on:

Question 4 of 8

Third normal form (3NF) removes:

Question 5 of 8

What is the main cost of adding an index?

Question 6 of 8

In SQL, what does a LEFT JOIN return that an INNER JOIN does not?

Question 7 of 8

Which is TRUE of a database transaction that is rolled back?

Question 8 of 8

An N+1 query problem is: