postgres-intro Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
a RDBMS (relational database management system) MySQL, Oracle, SQLite, Microsoft SQL server
2
Q
What are some advantages of learning a relational database?
A
data accuracy, easy to access, data integrity
3
Q
What is one way to see if PostgreSQL is running?
A
sudo service postgresql status
4
Q
What is a database schema?
A
a collection of tables that defines how the data in a relational database should be organized.
5
Q
What is a table?
A
A table is a list of rows each having the same set of attributes.
6
Q
What is a row?
A
the data in the table
