Free practice quiz

SQL Optimization & Transaction Isolation Quiz Questions

A sample of the 10 questions below — instant scoring and an explanation for every answer. No sign-in required to play.

Question 1

What is the purpose of a B-Tree index in a database?

ATo encrypt table data

BTo automatically back up the database

CTo allow fast lookups, insertions, and deletions by keeping data sorted in a balanced tree structure

DTo enforce foreign key constraints

Question 2

AAtomicity

BAvailability

CAggregation

DAuthentication

Question 3

AReading data from a corrupted table

BReading uncommitted data from another transaction that might later be rolled back

CA query that returns no results

DReading encrypted data without permission

↓ Scroll down to answer all 10 and see your score.

Preparing your quiz…