PostgreSQL and DBeaver Quiz

What is the correct command to check the installed version of PostgreSQL from the terminal?

• postgres --version

• psql --version

• postgresql -v

• db --version

In DBeaver, if the PostgreSQL driver is missing, what should you do?

• Install manually or let DBeaver download it

• Restart your computer

• Install MySQL driver

• Recreate your database

What is the default port number for PostgreSQL?

• 3306

• 1521

• 5432

• 27017

Why do we add PostgreSQL to the system PATH on Windows?

• To connect DBeaver

• To run psql commands from any terminal

• To install PostgreSQL faster

• To enable database backups

What is the correct way to switch databases in PostgreSQL terminal?

• \connect database_name

• switch database_name

• use database_name

• login database_name

In PostgreSQL, what command lists all available databases?

• SHOW DATABASES;

• \l

• LIST DATABASES;

• DATABASES;

If your student in DBeaver cannot insert data due to sequence permission errors, what should you do?

• Grant privileges on sequences

• Reinstall DBeaver

• Install Java

• Grant privileges on views

What PostgreSQL keyword is used to automatically generate unique IDs for primary key columns?

• AUTOINCREMENT

• SERIAL

• INCREMENTAL

• AUTO_ID

In DBeaver, what happens if you change user privileges while the session is open?

• Changes apply immediately

• You must restart your computer

• You need to disconnect and reconnect the session

• You must reinstall DBeaver

What does the DBeaver "Import Data" feature allow you to do?

• Install PostgreSQL drivers

• Create new tables automatically

• Upload data from CSV into existing tables

• Connect to the internet