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

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
  • Data corruption is less likely
  • Most widely used type of database
  • Problem domains can be modeled well
  • Good for storing related data
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

- top command

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

What is a database schema?

A

a collection of tables within an sql database that determines how data should be organized

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