Greenplum Interview Questions and Answers

Greenplum Interview Questions and Answers

Greenplum was a big data analytics company headquartered in san Mateo, California. Greenplum was nonheritable by EMC Corporation in July 2010. beginning in 2012 its management system software became referred to as the important Greenplum database sold-out through pivotal software and is presently actively developed by the Greenplum database open source community and pivotal.

In September 2017, Greenplum Database Version 5 was released. Version 5 includes the first iteration of the Greenplum project strategy of merging PostgreSQL later versions back into Greenplum and is based on PostgreSQL version 8.3 up from the previous version 8.2.  Version 5 also introducing the General Availability of the GPORCA Optimizer for cost-based optimization of SQL designed for big data.Founded in June 2003; product GA in February 2006.

What is Greenplum(company)?
Explain how data is stored in Greenplum?
What are the environmental variables connect to Greenplum?

Can you explain Greenplum Database?
What’s new in Pivotal Greenplum 5.2.0?
Explain how do you connect to Greenplum system without password prompt?
Can you explain add new user to the database?
What is Greenplum DCA?
What is EMC DCA?
What are the Greenplum DCA Modules?
What kind of locks should we focus on MPP system when system is slow /hung?
Can you explain pg_dump and gp_dump?
Can you define gp_toolkit?

Can you define gpdetective and how do I run it in Greenplum?
Can you explain primary to mirror mapping?
Can you define segment in Greenplum?
Explain the advantage in Greenplum, compared to oracle and Greenplum?
Explain the vacuum and vacuum full?
Which one is better DELETE or TRUNCATE?
Can you explain difference between oracle and Greenplum?
What is Greenplum performance monitor and how to install?
Can you explain find errors / fatal from log files?
Can you define resource queues?
Can you explain the tools available in Greenplum to take backup and restores?
Can you explain the process of data migration from oracle to greenplum?
Which command would you use to back up a database?
Can you explain delete/drop an existing database in greenplum?
Can u explain run gpcheckcat?
Can you explain start/stop db in admin mode?
Can you see the value of GUC?
How do I clone my production databaes to PreProd or QA environment?
What is difference between pg_dump and gp_dump?
Why ETL is important for Greenplum?
Can you explain Greenplum interconnect?