postgres Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
PostgreSQL is powerful, free, open source relational database management system. Alternative relational databases include MySQL, SQL server by Microsoft, Oracle by Oracle Corporation
2
Q
What are some advantages of learning a relational database?
A
NoSQL does not use the SQL language while relational database does and very useful when storing related data.
3
Q
What is one way to see if PostgreSQL is running?
A
top command, sudo service postgresql start
4
Q
What is a database schema?
A
how data in a relational database should be organized -collection of tables
5
Q
What is a table?
A
grouping of related data in listed rows with attributes
6
Q
What is a row?
A
actual data being entered into the table
