PostgreSQL

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

A relational database management system (RDBMS).

MySQL, SQL Server by Microsoft, Oracle by Oracle Corporation.

Question 2

What are some advantages of learning a relational database?

Answer 2

-they are the most widely used database

-they support good guarantees about data integrity.

-they can store and modify data in a way that makes data corruption as unlikely as possible

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

• top command line
• sudo service postgresql status
• psql

Question 4

What is a database schema?

Answer 4

A collection of tables. defines how the data in a relational database should be organized.

Question 5

What is a table?

Answer 5

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

Question 6

What is a row?

Answer 6

Rows are actual data values for a single group of related data within a table