DEV Community

Cover image for 10 General Backend Interview Questions With Answers
Joseph Mania
Joseph Mania

Posted on • Originally published at

10 General Backend Interview Questions With Answers

What is a Backend?

A Backend is a server that stores, processes and delivers data to a frontend or client-side application. A backend can be written in any programming language, but most commonly it is written in PHP, Ruby on Rails, Node.js, or Java, Python⛷.

What is a Backend Developer?

A Backend Developer is responsible for the server-side of an application. They are responsible for ensuring that the data stored on the Backend is organized and accessible, as well as being able to process requests from the Frontend and deliver the correct data.

What are some common Backend tasks?

Some common Backend tasks include:

Storing and retrieving data from a database
Processing data and performing calculations
Generating HTML pages or other content that is then delivered to the Frontend

What is a Database?

A database is a way of storing data in an organized way. Backends often use databases to store data such as user information, blog posts, images, etc. The most common type of database used by Backends is a relational database, such as MySQL.

What is a Relational Database?

A relational database is a type of database where data is stored in tables. Tables are like folders that contain data, and each table has its own columns and rows. Backends often use relational databases to store data because they are easy to use and understand.

What is a Database Connection?

A Database Connection is a way of connecting to a database from your Backend code. You need to create a Database Connection in order to be able to query the database and access its data.

How do I Create a Database Connection?

To create a Database Connection, you will need the following information:

The name of the database you want to connect to
The username and password for the database user account
The hostname or IP address of the server where the database is located
How do I Query a Database?
To query a database, you need to use a language called SQL. SQL stands for Structured Query Language, and it is the standard language for interacting with databases.

What is an ORM?

ORM stands for Object Relational Mapper. An ORM is a tool that allows you to interact with a database using objects instead of SQL queries. This can make your code easier to read and write, and it can also make it easier to reuse code.

What are some common Backend frameworks?

Some common Backend frameworks include:

Ruby on Rails

Top comments (3)

curiousdev profile image
CuriousDev • Edited

Thanks for this. Maybe these are quite general questions, but still useful and good to know.
For the last point, these are not only frameworks. NodeJS is used to execute JavaScript and Express can be considered as a framework for creating a web server.

techmaniacc profile image
Joseph Mania
techmaniacc profile image
Joseph Mania

Thank me later