What does ACID stand for?

What are the three levels of ANSI-SPARC?

What is the external view of ANSI-SPARC?

What is the Conceptual level of ANSI-SPARC?

What is the Internal level of ANSI-SPARC?

What are the functions of a DBMS?

What is a Transaction?

What is Concurrency Control?

What is the purpose of a Concurrency Control Protocol?

What is Serialisability?

Shared Lock

Exclusive Lock

What is the 2-Phase Locking (2PL) protocol rationale?

What are the rules of 2PL?

What is a Deadlock?

What is a Deferred Update?

What is Shadow Paging?

What is query decomposition?

What is Query Optimisation?

When does the 4th NF occur?

What is the Lossless-Join property?

Dependency Preservation

Six (6) Denormalisation Targets

Types of Entity Constraint

View Resolution

OLAP

OLTP

Idea behind Data Warehousing?

Data Warehousing

What is a Fact?

What are Measures?

What are Dimensions?

What are Hierarchies?

Roll-Up

Drill-Down

Slicing

Dicing

Pivot

Drill-Across

Drill-Through

Holdout

k-fold Cross Validation

Cluster

Hibernate

Semi-Structured Data

FLWOR