Postgres Quiz Questions

Question 1

What is PostgreSQL?

Answer 1

PostgreSQL is a powerful, free, open source Relational Database Management System (RDBMS).

Question 2

What are some advantages of learning a relational database?

Answer 2

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

The top command
sudo service postgresql start
sudo service postgresql status

Question 4

What are some alternative relational databases?

Answer 4

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

Question 5

What is a database schema?

Answer 5

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

Question 6

What is a table?

Answer 6

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

Question 7

What is a row?

Answer 7

A list of values