postgres Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
its an open source relational database management system , MySQL, oracle are examples of other relational databases
2
Q
What are some advantages of learning a relational database?
A
its all uses a similar language and They can store and modify data in a way that makes data corruption as unlikely as possible
3
Q
What is one way to see if PostgreSQL is running?
A
with the top command
4
Q
What is a database schema?
A
A collection of tables is called a schema.
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
represents a single, implicitly structured data item in a table.