Can you explain what the TCP/IP protocol is and how it works in networks?
Junior — Middle
175
Python
11010
584
Do you have experience working with the SQLAlchemy library for database operations in Python?
Junior — Middle
174
How can you identify a SQL injection vulnerability in this code?
Junior — Middle
172
What is the main role of an SSL certificate in ensuring website security?
Junior — Middle
170
Why is the CORS mechanism implemented during web application development?
Junior — Middle
170
Can you explain what the problem of competitive conditions means in multithreaded programming?
Junior — Middle
169
Explain the differences between INNER JOIN and LEFT JOIN operations in SQL and their application in queries.
Junior — Middle
168
Can you explain what the term CORS means and how it works in the context of web development?
Junior — Middle
168
Do you have experience working with the synchronous version of SQLAlchemy?
Junior — Middle
166
How is SSL certificate application implemented to ensure the security of websites and applications?
Junior — Middle
164
Can you explain what the OSI model is and how it is structured?
Junior — Middle
164
How to implement table joins when using SQLAlchemy?
Junior — Middle
164
Can you explain what Big O notation means and how it is used to evaluate algorithms?
Junior — Middle
164
Explain what GIL is in Python and what role it plays in thread execution.
Junior — Middle
163
Can you explain what SQL injection is and what is the danger of this vulnerability?
Junior — Middle
162
What is the difference between using a tuple and a list in Python?
Junior — Middle
161
How to evaluate the efficiency of the element enumeration method in a list from the point of view of algorithm complexity?
Junior — Middle
158
Could you briefly tell about your professional experience and main skills?
Intern — Junior
157
What is the role of Middleware in FastAPI and why is it used in applications?
Junior — Middle
157
Can you explain the working principle of REST API and its main features?
Junior — Middle
156