PostgreSQL Mastery Test

Auto audio on: the next questions will be read aloud when you click Continue.

1. 1

   What is the default port number for a PostgreSQL database?

   A 5432 B 3306 C 1521
2. 2

   Which SQL command is used to add a new record in PostgreSQL?

   A INSERT INTO B INSERT INTO ... VALUES C ADD ROW
3. 3

   How do you define a serial primary key in PostgreSQL?

   A PRIMARY KEY AUTO_INCREMENT B PRIMARY KEY AUTOINCREMENT C SERIAL PRIMARY KEY
4. 4

   What is the role of pgAdmin in PostgreSQL?

   A It's a comprehensive management tool for PostgreSQL. B It's a command-line interface for executing SQL commands. C It's used to monitor the network traffic.
5. 5

   Which key is used in PostgreSQL to uniquely identify a row in a table?

   A Primary Key B Foreign Key C Unique Key
6. 6

   What is the function of the EXPLAIN command in PostgreSQL?

   A It executes a query. B It creates a new table. C It provides the execution plan of a query.
7. 7

   What is the difference between CHAR and VARCHAR in PostgreSQL?

   A CHAR is fixed-length; VARCHAR is variable-length. B CHAR defines a boolean; VARCHAR defines a text. C Both are identical.
8. 8

   Which command is used to update existing records in PostgreSQL?

   A REVISE B CHANGE C UPDATE
9. 9

   In PostgreSQL, what is the purpose of the HAVING clause?

   A To filter rows before aggregation. B To order the results. C To filter rows after aggregation.
10. 10

    What does ACID stand for in the context of PostgreSQL transactions?

    A Aggregate, Consistent, Integrated, Dependent B Atomicity, Consistency, Isolation, Durability C Automated, Consistent, Independent, Durable