What is PostgreSQL?
What are the advanced features of PostgreSQL?
What languages does PostgreSQL support?
Explain functions in PostgreSQL
Explain indices in PostgreSQL.
What are Triggers?
List the data types supported by PostgreSQL.
What database administration tools are available in PostgreSQL?
How do you create a data base with postgreSQL?
What is pgadmin?
What is Write Ahead logging?
Explain Multi version concurrency control.
What do you mean by command enable debug?
Explain: a.) Tokens b.) String constants
What are the disadvantages of PostgreSql Database.
What common bugs do you encounter while migrating from MySQL db to Postgre?
What is Update Statement? Why does it work slowly?
What are the various enhancements to the straight relational data model by
PostgreSQL?
You need to identify specific physical rows with block and offset values. How
will you do that in PostgreSQL?
You need to allocate memory in postgreSQL. What command will you use?
Explain about concurreny with the help of MVCC
You need to send messages to the front-end, and optionally terminate the
current query being processed. How will you do that?
What is used by PostgreSQL in its internal system tables to link rows in
separate tables?
How do you create a PostgreSQL user?
How to take backup of database?
How do you restore the database?
How to start/stop the database server?
How would you check whether PostgreSQL server is up and running?
How would you create a database?
You need to find out how is the query optimizer evaluating the given query.
What option do you have?
You need to increase the number of shared memory buffers shared among the
backend processes. What option do you have?
What ODBC drivers are available for PostgreSQL?
What can be the Maximum size for a database in PostgreSQL?
Does PostgrSQL support Column constraints? If yes, how?
You need to retrieve the next SERIAL value from the sequence object. What
command will you use?
What character types are available in postgresql?
What operator is used for case-insensitive regular expression searches in
PostgreSQL?
How are statistics in PostgreSQL updated?
What can be the Maximum size for a table in PostgreSQL?
What does the option psql -l of PostgreSQL display?
What powerful database utility can be used for building, executing and
processing queries upon PostgreSQL databases?
How would you list the number of database?
|
