Postgre Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Postgre Interview Questions

Questions Answers Views Company eMail

what is the advantage of RAID

Wipro,

4 10131

when will data in the data base is updated

IEG,

3 6565

how to find nth lowest salary

4 17175

what is software?

1 4887

get second maximum date from tables.

1 4073

i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha

CMC,

1 3892

This message is received in response to the query SELECT * FROM JA_Party. I would like to know what am I doing wrong. ERROR: relation "ja_party" does not exist LINE 1: SELECT * FROM JA_Party ^ ********** Error ********** ERROR: relation "ja_party" does not exist SQL state: 42P01 Character: 15

1 2685

What are the common bugs found while migrating to MySQL db to Postgre?

1 3013

What is inverted file ?

1397

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

1 2827

How is the statistics in PostgreSQL updated?

1 3613

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

1283

What is the Maximum size for a table in PostgreSQL?

1522

PostgreSql Disadvantages

AFDD,

1914

What are the character types that are available in postgresql?

1394

Post New Postgre Questions

Un-Answered Questions { Postgre }

What is multiversion two phase locking?

802

How do I open the query tool in pgadmin?

806

Can a unique key be a foreign key?

826

How to drop all tables in postgresql?

888

How do I connect to pgadmin server?

923

How do I start postgresql on linux?

822

How to check dependency of table in postgresql?

850

Does creating an index lock the table?

784

Which key can be used to execute a query in the query editor?

830

What is maximum size of text datatype in postgres?

841

How do I enable postgis on pgadmin?

960

How do I connect to postgresql server?

906

How do I start postgresql in linux?

888

Why mysql is more popular than postgresql?

844

Is postgresql relational?

782

For More Un-Answered { Postgre } Questions Click Here