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

25 interview questionsfor developers (2026)

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

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

Which command in PostgreSQL is used to delete a database?

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

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

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

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

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

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

Data Scientist
abdelghaniat Apr 19, 2024
Easy
3 votes560 runs0 comment

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

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

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

Data Scientist
abdelghaniat Apr 19, 2024
Medium
1 vote504 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
Easy
1 vote502 runs0 comment

Grant all privileges on a database to a user in PostgreSQL

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

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

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

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

Data Scientist
abdelghaniat Apr 19, 2024
Medium
1 vote487 runs
1 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
Easy
1 vote484 runs0 comment

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

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

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

Data Scientist
timestamp
Dragon parfaitat Aug 23, 2024
Hard
0 vote512 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 vote509 runs0 comment

What is the default port number for PostgreSQL database server?

Data Scientist
abdelghaniat Apr 19, 2024
Hard
0 vote491 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 vote488 runs0 comment

How to create a recursive query in PostgreSQL?

Data Scientist
abdelghaniat Apr 19, 2024
Easy
0 vote470 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 vote444 runs
1 comment

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

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

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

Data Scientist
abdelghaniat Apr 19, 2024