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

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

its all uses a similar language and They can store and modify data in a way that makes data corruption as unlikely as possible

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

with the 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 is called a schema.

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

What is a table?

A

A table is a list of rows each having the same set of attributes

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

What is a row?

A

represents a single, implicitly structured data item in a table.

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