intro Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
open source relational database management system (RDBMS) , used to retrieve or store complex data in an organized matter. MySQL, SQL and Oracle.
2
Q
What are some advantages of learning a relational database?
A
relational databases ensure data integrity so that data corruption is unlikely. Able tor eject bad data
3
Q
What is one way to see if PostgreSQL is running?
A
checking top to see if it’s running or
sudo service postgresql status
4
Q
What is a database schema?
A
A collection of tables; defines how the data in a relational database should be organized.
5
Q
What is a table?
A
made of rows and tables
6
Q
What is a row?
A
a list of rows having the same set of attributes (column)
