Exercises
Put your backend development database knowledge to the test. This quiz covers essential concepts used when building modern applications, including SQL data retrieval, NoSQL databases, ACID transaction principles, Redis features, and object-relational mapping (ORM). Whether you are learning backend programming or reviewing core database concepts for an interview, these questions will help you assess your understanding of how applications store, manage, and access data.
Answer the questions below and check the explanation for each answer.
0/5 answered
Auto audio on: the next questions will be read aloud when you click Continue.
The question asks which of the options is a NoSQL database. MongoDB is the correct choice, as it is a document-oriented database in the NoSQL category, which means it stores data in flexible, JSON-like documents. Both MySQL and PostgreSQL are traditional SQL databases that use a relational database model.
ACID is a set of properties that guarantee reliable database transactions. Atomicity ensures that all operations within a transaction are completed successfully or not at all. Consistency ensures that transactions only bring the database from one valid state to another. Isolation ensures that concurrent transactions do not interfere with each other. Durability ensures that once a transaction has been committed, it will remain so, even in the event of a system failu
In SQL, the SELECT command is used to retrieve data from a database. It allows you to specify the columns and table from which you want to obtain information, and you can also add conditions using the WHERE clause to filter the results.
Redis is an in-memory data store that supports persistent storage, enabling it to save data to disk and recover it on restart. It is often used as a cache, database, or message broker. It does not natively provide graph store capabilities or the use of foreign keys, which are features found in other types of databases.
In the context of backend programming, ORM stands for Object-Relational Mapping. It is a technique that allows you to query and manipulate data from a database using an object-oriented paradigm. This approach helps in bridging the gap between object-oriented languages and relational databases by converting data between incompatible type systems in object-oriented programming languages.
Free CourseBackend REST API
5
(9)
5h24m
25 exercises
Free CourseNodeJS complete
5
(1)
1h30m
12 exercises
Free CourseAPIs
5
(5)
4h32m
20 exercises
Free CourseFlask
5
(1)
8h50m
14 exercises
Free CourseDjango for Everybody
5
(1)
18h32m
Free CoursePython Django Full Stack Developer
5
(2)
14h23m
27 exercises
Free CourseMaster Vue JS API
5
(-4)
6h14m
6 exercises
Free CoursePython Fast API
4.8
(5)
1h34m
14 exercises
Thousands of online courses in video, ebooks and audiobooks.
To test your knowledge during online courses
Generated directly from your cell phone's photo gallery and sent to your email
Download our app via QR Code or the links below:.
Carry knowledge in your pocket.
Download the Cursa app.
There are hundreds of free courses available, with a free certificate of completion that is saved in your mobile image gallery.
Download the app to access the Course Completion Certificate for Free.
+ 10 million
students
Free and Valid
Certificate
60 thousand free
exercises
4.8/5 rating in
app stores
Free courses in
video and ebooks