Job offersCompaniesTestsBlogI'm an employerSign upLog in
fr
fr
Home>IT Tests>Questions

25 interview questionsfor developers (2025)

Test your developer skills before an interview with 25 corrected questions on 80+ topics. Beginner, Intermediate or Expert level.

or
Technology
Postgresql
Profession
Test
Sort by
Newest
Most popular
Last review
Filter by
Published
25
To review
0
25 questions
Easy
7 votes363 runs0 comment

Which command in PostgreSQL is used to delete a database?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
5 votes358 runs0 comment

What is the command to back up a database in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Hard
4 votes340 runs0 comment

What is the mechanism in PostgreSQL that ensures the integrity of transactions and supports concurrent processing?

Data Scientist
abdelghaniat Apr 19, 2024
Easy
2 votes350 runs0 comment

Which PostgreSQL command changes the definition of a database object, like a table?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
2 votes333 runs0 comment

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

Data Scientist
abdelghaniat Apr 19, 2024
Hard
2 votes328 runs0 comment

What type of index is primarily used for full-text search in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Easy
1 vote314 runs0 comment

Grant all privileges on a database to a user in PostgreSQL

Data Scientist
abdelghaniat Apr 19, 2024
Medium
1 vote314 runs0 comment

Which clause is used in PostgreSQL to filter grouped records that do not meet a certain condition?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
1 vote305 runs0 comment

What PostgreSQL feature allows you to run functions on the database server-side?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
1 vote301 runs0 comment

Which command is used to remove all rows from a table without deleting the table itself in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
1 vote301 runs0 comment

Add a unique constraint on the email column while creating the users table in PostgreSQL.

Data Scientist
abdelghaniat Apr 19, 2024
Hard
0 vote318 runs1 comment

What feature in PgAdmin allows you to visually design your database schema including tables, views, and relationships?

Data Scientist
abdelghaniat Apr 19, 2024
Easy
0 vote316 runs0 comment

What is the default port number for PostgreSQL database server?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
0 vote303 runs0 comment

Which data type in PostgreSQL is best suited for storing large blocks of text?

Data Scientist
abdelghaniat Apr 19, 2024
Hard
0 vote303 runs0 comment

What data type is used to store geographical objects for Geographic Information Systems (GIS) in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Medium
0 vote302 runs0 comment

How to create a recursive query in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Easy
0 vote293 runs0 comment

What is the term for the operation in PostgreSQL that combines rows from two or more tables based on a related column between them?

Data Scientist
abdelghaniat Apr 19, 2024
Easy
0 vote275 runs0 comment

What data type is used specifically for storing boolean values in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Hard
0 vote220 runs0 comment

Which PostgreSQL feature is used to handle exceptions and control the transaction flow?

Data Scientist
abdelghaniat Apr 19, 2024
Hard
0 vote193 runs0 comment

What function is used to return the current date and time in PostgreSQL?

Data Scientist
timestamp
Dragon parfaitat Aug 23, 2024