SQL Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
- An open source Relational Database Management System
- My sql, oracle, sql server by microsoft
2
Q
What are some advantages of learning a relational database?
A
- Data corruption is less likely
- Most widely used type of database
- Problem domains can be modeled well
- Good for storing related data
3
Q
What is one way to see if PostgreSQL is running?
A
- sudo service postgresql status
- top command
4
Q
What is a database schema?
A
a collection of tables within an sql database that determines how data should be organized
