postgres-intro Flashcards

1
Q

What is PostgreSQL and what are some alternative relational databases?

A

PostgreSQL is a powerful, free, open source Relational Database Management System (RDBMS).
Other popular relational databases include MySQL (also free), SQL Server by Microsoft, and Oracle by Oracle Corporation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are some advantages of learning a relational database?

A

Keeping data integrity.
SQL language is a very portable skill given that there are so many relational databases driven by almost the same language.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is one way to see if PostgreSQL is running?

A
top command (to list the currently running processes)
Execute sudo service postgresql status command while Postgres is running.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly