RAID serves for two data storage requirements
1]Reliability
2]Performance
->Reliability-It maintains multiple copies of same data in
array of disks to make the storage fault tolerant in case of
disk failure.
->Performance-Different bits of a data component is stored
across an array of disks(bit striping) so that access time
is greatly reduced since single read time is enough to read
all the bits since they are in different disks, thus
boosting the performance.
For All SQL , Tested in PostgresSQL : Javedcc@gmail.com
SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)
Over 200. As with other open source projects, of course, we depend on hundreds of community members for documentation, translations, advocacy, conferences, website development, infrastructure, and peer-to-peer support.
wide distribution through the open source world and liberal licensing make that a difficult question to answer with any accuracy. A previous version, 8.0, had an estimated one million downloads within a seven months of release. However, most users get PostgreSQL with a Linux distribution, or with some of the many other products, OSS software, and hardware devices that include PostgreSQL.
Webmaster 23rd of May 2012
Tell us what you feel about Postgre Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Postgre Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Postgre Interview Questions and Answers
Thank you.