
1 - Yes.
2 - Yes.
3 - No.
4 - No.
It has no relationship with size of the table by the way. Please refer to Alter Table Limitations section at http://gemfirexd.docs.pivotal.io/latest/userguide/index.html?q=/latest/userguide/reference/language_ref/ref-sql-limitations.html
Regards