Database Objects: Catalog, Views, Procedures & Functions

What is the distinctive behavior of the SAP HANA ALPHANUM data type?

How does case sensitivity differ between delimited and nondelimited SAP HANA object names?

What is the default MAXVALUE for an SAP HANA sequence, and what does the CYCLE/NO CYCLE option control?

How does SAP HANA sequence caching cause numbering gaps in a multinode installation?

In SAP HANA, how is the FLOAT(n) data type resolved to REAL or DOUBLE?

Why can SAP HANA system views be referenced without specifying the SYS schema?

How do you distinguish a SAP HANA SQL view from a column view in the VIEWS catalog view?

What are the four behaviors a SAP HANA foreign-key constraint can define when the referenced table's key columns are updated?

What is the difference between the SAP HANA sequence functions NEXTVAL and CURRVAL?

What are the SAP HANA rules for object name length and which characters force a name to be delimited?

What does creating a public synonym for an SAP HANA object provide, and what does it NOT grant?

Which SAP HANA catalog view shows the complete code of a trigger, and what statements enable or disable one?

What are the three types of triggers in SAP HANA based on when they fire relative to the DML operation?

How are SAP HANA column views created, and in which schema do they reside?

In SAP HANA, what happens to a dependent object (e.g., a view) when an object it references is dropped?

In an SAP HANA BOOLEAN column, what values are allowed, and what does the client receive if it doesn't support booleans?

In SAP HANA, what is the object ID (OID) and where can you find it?

How does the performance of an SAP HANA SQL view compare to querying its underlying tables directly, and what is the most common cause of slow views?

What does the RESET BY clause of an SAP HANA sequence do?

In which kinds of SQL statements can an SAP HANA user-defined function (UDF) be used?

Roughly how many standard (built-in) functions does SAP HANA ship with, in addition to user-defined functions?

Which SAP HANA catalog views show a table's characteristics and its columns, and why isn't there a DESCRIBE command?

What value range does the SAP HANA TINYINT data type support, and is it signed?

How does SAP HANA implement referential integrity (foreign key) constraints?

What are the two roles of indexes in a relational database, and which one remains fully valid in SAP HANA?

How is data physically laid out in the SAP HANA row store versus the column store?

How do the SAP HANA large object types BLOB, CLOB, and NCLOB differ?

Why are write operations (especially INSERTs) slower on an SAP HANA column-store table than a row-store table?

In an in-memory database like SAP HANA, when do indexes still meaningfully help performance?

What is the SQLScript SQL SECURITY clause on an SAP HANA stored procedure, and what are its two values?

How does an SAP HANA function differ from a stored procedure in invocation and return value?

What is the difference between ABAP CDS views and SAP HANA CDS views?

In SAP HANA, what does the value NULL mean, and how must it be tested in SQL?

Which catalog-view column identifies invalid SAP HANA views?

Which three families of metadata views does SAP HANA provide besides regular tables?

What is the SAP HANA database catalog, and how do applications query it?

What is the format and precision of the SAP HANA TIMESTAMP data type?

Why is the SAP HANA column store advantageous for queries with selection criteria, and for which workload is the benefit greatest?

What is an SAP HANA sequence, and which monitoring view holds its current value?

What does the READS SQL DATA declaration commit an SAP HANA stored procedure to, and what is its benefit?

What is an SAP HANA synonym, and what extra capability does a public synonym add?

How does the SAP HANA SECONDDATE data type differ from TIMESTAMP?

What is the difference between the SAP HANA VARCHAR and NVARCHAR data types?

Why can't SAP HANA sequences guarantee gap-free, strictly chronological numbering?

Which SAP HANA catalog view shows object dependencies, and how are direct vs indirect dependencies coded?

In SAP HANA, what is the relationship between a newly created database user and a schema?

Besides SQLScript, which two languages can an SAP HANA stored procedure be written in?

When an SAP HANA object name is given without a schema, in what order does the database search for it?

Which three column-store engines do SAP HANA column views interface with?

What is distinctive about the SAP HANA ARRAY data type's mutability and allowed element types?