Latest Postgre interview Questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 04:55 PM

1. What is the Maximum size for a table in PostgreSQL?

2. To identify specific physical rows with block and offset values what can be used in PostgreSQL?

3. What is the command that can be used to allocate memory in postgreSQL?

4. What does GEQO stands for in PostgreSQL?

5. What are the ODBC drivers that are available for PostgreSQL?

6. How many byte Unique integers does OIDs in PostgreSQL have?

7. What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

8. What are the character types that are available in postgresql?

9. What is the Maximum size for a database in PostgreSQL?

10. How is the statistics in PostgreSQL updated?

11. What does the option psql -l of PostgreSQL display?

12. Triggers are supported and can be attached in PostgreSQL to tables or views?

13. What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

14. What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed?

15. What is used by PostgreSQL in its internal system tables to link rows in separate tables?

16. What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

17. What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

18. Does PostgrSQL support Column constraints? If so how is it done?

19. What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?

20What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

09-12-08, 04:55 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	Latest Postgre interview Questions 1. What is the Maximum size for a table in PostgreSQL? 2. To identify specific physical rows with block and offset values what can be used in PostgreSQL? 3. What is the command that can be used to allocate memory in postgreSQL? 4. What does GEQO stands for in PostgreSQL? 5. What are the ODBC drivers that are available for PostgreSQL? 6. How many byte Unique integers does OIDs in PostgreSQL have? 7. What is the operator that is used for case-insensitive regular expression searches in PostgreSQL? 8. What are the character types that are available in postgresql? 9. What is the Maximum size for a database in PostgreSQL? 10. How is the statistics in PostgreSQL updated? 11. What does the option psql -l of PostgreSQL display? 12. Triggers are supported and can be attached in PostgreSQL to tables or views? 13. What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction? 14. What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed? 15. What is used by PostgreSQL in its internal system tables to link rows in separate tables? 16. What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes 17. What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given? 18. Does PostgrSQL support Column constraints? If so how is it done? 19. What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases? 20What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object? __________________ Sai Prepaid Mobile Recharge Online - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.