Q. What are the Guidelines to be followed for SQL performance on ABAP on HANA? Q. What are different categories of Database Statements? Ans. Database statements categories DDL – Data Definition language – Mainly used to create/change/delete new database objects. SE11 – Data Dictionary which automatically produces the DDL statements for you. CREATE, ALTER, DROP DML – Data Manipulation Language – statements which are used to manipulate data. INSERT, UPDATE, DELETE, MODIFY DQL – Data Query Language – SELECT statement, GET TCL – Transaction Control Statements (ACID) - COMMIT, Rollback DCL – DATA Control Language – Security and access of data GRANT, REVOKE ….
