Postgres Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
a powerful, free, open source Relational Database Management System. Others are MySQL, SQL Server by Microsoft, and Oracle by Oracle Corp
2
Q
What are some advantages of learning a relational database?
A
SQL-based, support good guarantees about data integrity, data corruption is unlikely
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
Collection of tables, also dictates the rules for how the database is structured (like a blueprint/instructions)
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
Contains columns of attributes
