Vertica Interview Questions

1. What is WOS in Vertica?
2. What is ROS in Vertica?
3. What is Tuple Mover (TM) in Vertica? 
4. What is Projection?
5. Table and Projection are physical or logical?
6. What is K-Safe in Vertica?
7. What is Hash-Segmentation and Unsegmented?
8. What is DBD in Vertica?
9. What ANALYZE_STATISTICS will do?
10. What is Copy Command in Vertica?
11. Howto monitor Copy Command?
12. What is Mergeout in Vertica?
13. What is Encoding and Compression in Vertica?
14. How to find currently running sessions?
15. How to Close/Kill currently running session?

See also:

DB User:

• User Creation
• GRANT USAGE ON SCHEMA PUBLIC
• Create Schema
• Grant usage privileges on a schema to the user
• Grant all privileges on a schema to the user
• Set default search path
• Change Vertica User Privileges from Existing User to New user
• Execute Permissions on User Defined Functions For New Users
• Grant Execute Permissions on ODBC

Vertica Table

• Creation
• Rename Table, Table Column Or View in Vertica
• Projection Creation
• Create A New Table Using Existing Table
• Create Table Partitions
• Change the Owner of Table
• Drop Partition

Sequence:

• Create Sequence Number
• Alter Sequence
• Drop Sequence
• Add Sequence Or Set Default value to a table
• Drop Default Or Sequence on a Table
• Change the Owner of Sequence

Vertica Sessions

• Close Session in Vertica
• Currently Running Sessions in Vertica