Postgresql Interview Questions For Freshers & Experienced

Q1. What is PostgreSQL?

Q2. List some of the features of Postgresql?

Q3. Enlist few advantages of Postgresql?

Q4. What are the Indexes in PostgreSQL?

Q5. What are string constants in PostgreSQL?

Q6. How to start or stop database server in PostgreSQL?

Q7. How to change the datatype in postgresql?

Q8. How do you change constraints in PostgreSQL?

Q9. What is Cube Root Operator (||/) in PostgreSQL?

Q10. How do we check whether Postgresql Server is running?

Q11. What are Triggers in Postgres?

Q12. What is difference between clustered index and non clustered index?

Q13. Write command to create a Database in Postgres?

Q14. How to all Databases in Postgres?

Q15. What is use of pgadmin?

Q16. What are the indices of PostgreSQL?

Q17. What is use of Array_To_String in PostgreSQL?

Q18. Enlist data types available in PostgreSQL?

Q19. What is the dual table in PostgreSQL?

Q20. What is MVCC in PostgreSQL?

Q21. What are tokens in PostgreSQL?

Q22. What is table partitioning in PostgreSQL?

Q23. What is the maximum size of the table in PostgreSQL?

Q24. What is write-ahead logging in PostgreSQL?

Q25. List reserved words in PostgreSQL?

Q26. What is sequence in PostgreSQL?

Q27. How to enable debug mode in PostgreSQL?

Q28. How to find version of PostgreSQL?

Q29. Write syntax to create table in PostgreSQL?

Q30. What is difference between truncate and drop?

Q31. Enlist different types of joins available in PostgreSQL?

Q32. What is PostgreSQL Alias?

Q33. What is a View in PostgreSQL?

Q34. How do you declare a user-defined exception in PostgreSQL?

Q35. List some predefined exceptions in PostgreSQL?

Q36. What are maximum number of triggers you can apply in PostgreSQL?

Q37. What are Cursors in PostgreSQL?

Q38. How to execute a stored procedure in PostgreSQL?

Q39. What is use of commit and rollback statement in PostgreSQL?

Q40. List types of cursors availables in PostgreSQL?