postgres-intro Flashcards

1
Q

What is PostgreSQL and what are some alternative relational databases?

A

An open source database management system.
Alternatives:
-Oracle
-Amazon Aurora

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
"Simple Model. A Relational Database system is the most simple model, as it does not require any complex structuring or querying processes. 
Data Accuracy. 
Easy Access to Data. 
Data Integrity. 
Flexibility. 
Normalization. 
High Security. 
Feasible for Future Modifications."
-https://www.educba.com/relational-database-advantages/
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

sudo service postgresql status

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