PostgreSQL Introduction and Installation Quiz

What is the correct pronunciation of PostgreSQL?

• Post-gres-sequel

• Post-sql

• Post-gres

• Post-gres-que-el

What was the original project that led to the development of PostgreSQL?

• MySQL

• Oracle

• Ingres

• SQLite

Where can you download PostgreSQL?

• postgresql.com

• postgresql.org

• postgresql.net

• postgresql.edu

What is the default port number for PostgreSQL?

• 5432

• 3306

• 8080

• 1521

Why is it recommended to install command line tools with PostgreSQL?

• They are easier to use

• They are faster than GUI tools

• They provide more features

• They give engineers more respect points

What does 'pg' in pgAdmin stand for?

• Public Group

• Postgres GUI

• Pretty Good

• Postgres

What is the purpose of the 'SQL' tab in pgAdmin?

• To write new SQL scripts

• To execute SQL commands

• To debug SQL queries

• To view the SQL command for changes

What should you do if you see 'template0' and 'template1' databases in pgAdmin?

• Delete them

• Rename them

• Leave them alone

• Modify them

What is the default schema in a new PostgreSQL database?

• Main

• Default

• Public

• Private

What is the first step to create a new database in pgAdmin?

• Click on 'Servers'

• Right-click on 'Databases'

• Select 'New Database'

• Open 'Schemas'