1. Maximum number of tables in a schema?
131072
2. What can be the maximum table name length?
127 characters
3. What can be the maximum column name length?
127 characters
4. What can be the maximum number of columns in a table?
1000
5. What can be the maximum number of columns in a view?
1000
6. What can be the maximum number of partitions of a column table?
1000
7. What can be the maximum number of rows in each table?
Limited by storage size RS: 1TB/sizeof(row)
CS: 2^31 * number of partitions
8. In which table you can get the current system limits?
M_SYSTEM_LIMITS
9. Maximum number of jobs you can view the information in the Current tab of Job log?
5
