1. What is SAP HANA?
An in-memory, column-oriented, relational database that processes transactions and analytics in real time.
2. What is in-memory computing?
Data is stored in RAM instead of disk, allowing extremely fast processing.
3. Difference between row store and column store?
- Row Store: Good for transactional writes.
- Column Store: Good for analytics, aggregation, compression — default in HANA.
4. What is delta merge?
Process of merging delta storage (frequent writes) into main storage to optimize read performance.
5. What is OLTP vs OLAP in HANA?
HANA supports both in a single platform using in-memory architecture.
6. What is SAP HANA Studio?
Eclipse-based development environment for admin, modeling, and monitoring.
7. What are SAP HANA Cockpit and DBACockpit?
Web-based tools for monitoring, user admin, performance analysis of HANA DB.
8. What is SAP HANA Index Server?
Core database engine responsible for processing SQL, queries, transactions.
9. What is Name Server?
Manages topology, landscape, and distributed information in scale-out systems.
10. What is a Schema?
Logical container for database objects such as tables, views, procedures.