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