Postgre Interview Questions
Questions Answers Views Company eMail

what is the advantage of RAID

Wipro,

4 6151

when will data in the data base is updated

IEG,

3 3085

how to find nth lowest salary

4 12235




what is software?

1 2022

get second maximum date from tables.

1 1883

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 1507

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 629

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

1 880




What is inverted file ?

409

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

1 935

How is the statistics in PostgreSQL updated?

1 932

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

353

What is the Maximum size for a table in PostgreSQL?

421

PostgreSql Disadvantages

AFDD,

668

What are the character types that are available in postgresql?

414


Post New Postgre Questions






Un-Answered Questions { Postgre }

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

407


What does GEQO stands for in PostgreSQL?

433


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

445


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

366


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

345






What is inverted file ?

409


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

384


What is the Maximum size for a table in PostgreSQL?

421


How many byte Unique integers does OIDs in PostgreSQL have?

395


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

346


PostgreSql Disadvantages

668


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

494


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

353


What does the option psql -l of PostgreSQL display?

371


What are the character types that are available in postgresql?

414