Database & Tenant Administration

What is the difference between logical and physical database corruption in SAP HANA?

How many tenant databases does the default SAP HANA port range allow, and how do you extend it?

Which SAP HANA volume type supports partitioning (striping) across multiple disks — data volumes, log volumes, or both?

What is the purpose of the parameter blacklist (blacklisted parameters) for SAP HANA tenant databases?

Which SQL statements create, revert to, and drop an SAP HANA fallback snapshot?

How do you prevent a specific SAP HANA tenant database from starting automatically when the system starts?

Since which SAP HANA version is multitenant database containers (MDC) the default, and what happens to an existing single-tenant system on upgrade?

Which consistency checks does SAP HANA execute automatically at system startup?

When copying a tenant via SAP HANA database replication, name two things that are replicated automatically and two that are not.

What five network zones does SAP recommend for an SAP HANA deployment?

Which system view shows SAP HANA database-replication status, and what are the possible statuses?

Which system privilege is required to create, start, rename, or delete tenant databases in SAP HANA?

What is a savepoint in SAP HANA, and what is its default frequency?

What are the preconditions for renaming an SAP HANA tenant database?

What is the syntax of CHECK_TABLE_CONSISTENCY in SAP HANA for one table, a whole schema, and the entire database?

What is a fallback snapshot in SAP HANA, and what are its key limitations?

Why is copying a tenant via backup-and-restore impossible when file-based and third-party tool backups are mixed?

Which SQL statements start and stop an individual SAP HANA tenant database from the system database?

From which database do you create a new tenant database in SAP HANA, and what is created during creation?

SAP HANA database replication is built on which underlying technology, and what are its two prerequisites?

What happens to the SAP HANA license after a system rename, and within what window must it be fixed?

Why can an SAP HANA data-volume reclaim (shrink) operation fail in a system-replication setup?

In a multitenant SAP HANA system, which service activities can be performed from a tenant database, and which require the system database?

Why do SAP HANA data volume files grow but never shrink on their own, and how do you reclaim the space?

How can SQL access to the SAP HANA system database be isolated on its own port?

Why is Phase 2 the critical phase of an SAP HANA savepoint operation?

What three methodologies can be used to copy or move SAP HANA systems and/or databases?

When restoring an encrypted SAP HANA database to a different system, what must be imported first, and with which tool?

In SAP HANA, what two ways can a client connect to a tenant database via a connection string?

Which parameter must be enabled to allow data-volume partitioning (striping) in SAP HANA, and what is the default striping size cap?

How do virtual hostnames and dedicated ports reduce the client impact of moving an SAP HANA tenant between systems?

How is the SAP HANA port-numbering scheme structured for an instance, and which port does the system database name server use?

Which SAP HANA command-line tool analyzes physical corruption in the persistence layer, and what is its constraint?

What are the default on-disk locations for SAP HANA data and log volumes, and which parameters change them?

When deleting an SAP HANA tenant database (SPS 01+), what choice do you get regarding its backups, and what is the resulting caveat?

Which SQL statement starts an SAP HANA database-replication copy, and how do you finalize it?

In SAP HANA, what does CHECK_CATALOG verify versus CHECK_TABLE_CONSISTENCY?

How can you disable features entirely on an SAP HANA tenant database, and which system view lists the disable-able features?