Q. What is the difference between Row Storage and Column Storage? Row Store


Q. What are the Guidelines to be followed for SQL performance on ABAP on HANA?



Download 156.8 Kb.
View original pdf
Page5/48
Date07.04.2021
Size156.8 Kb.
1   2   3   4   5   6   7   8   9   ...   48
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 ….

Download 156.8 Kb.

Share with your friends:
1   2   3   4   5   6   7   8   9   ...   48




The database is protected by copyright ©ininet.org 2020
send message

    Main page