Ultimate PostgreSQL Quiz: How Many Can You Get Right?
waywardfriar
Created 6/19/2024
Think you're a PostgreSQL expert? Test your knowledge with this challenging quiz and see how many correct answers you can get out of 5!
1. What is the default port number for PostgreSQL?
2. Which SQL command is used to create a new table in PostgreSQL?
CREATE TABLE
INSERT INTO
ALTER TABLE
UPDATE TABLE
3. What is the command to list all databases in PostgreSQL?
SHOW DATABASES;
SELECT * FROM pg_database;
\l
LIST DATABASES;
4. Which utility is used for backing up a PostgreSQL database?
pg_backup
pg_restore
pg_dump
pg_save
5. What datatype is used to store a large block of text in PostgreSQL?
