PostgreSQL is a powerful, open-source object-relational database management system known for its reliability, extensibility, and standards compliance. It supports advanced SQL features, strong ACID compliance, and modern capabilities such as JSON data handling, full-text search, and extensible indexing. With features like MVCC and Write-Ahead Logging, PostgreSQL ensures data consistency, concurrency, and fault tolerance. It is widely used in enterprise, cloud, and open-source environments for building scalable and data-intensive applications.

This PostgreSQL questionnaire is designed to assess foundational database knowledge, covering core concepts such as database architecture, SQL commands, data types, indexing, transactions, joins, constraints, and ACID compliance.

Take this assessment to understand PostgreSQL and identify areas for further learning.

Read the FAQs tab carefully for Instructions before beginning the assessment.

NYXPoints are used to generate the Leaderboard (coming soon). They are awarded for achieving a certain score.

• 200 nyxpoints for a passing score of 80% or more
• 300 nyxpoints for a perfect score of 100%
• Didn’t pass? You still get 30 nyxpoints for attempting the assesment

IMPORTANT instructions for taking the Assessment

• The timer starts when you click Start Assessment
• DO NOT refresh/reload the page or use the back button to navigate away from the page.
• Navigating away from the assessment page DOES NOT stop/pause the timer and the will restart the assessment when you come back to it. The answers are NOT saved.

 General

• There are NO pre-requisites to take this assessment. Take this assessment even if you are completely new to Linux.
• The assessment is completely FREE.
• Preferably take it in a closed book mode.
• DO NOT copy/paste, share or upload questions elsewhere.