Golang

How can SQL injections be protected against?

What are prepared statements?

What is defer in Go and when is it called?

How does panic/recover interception work in Go?

There is a table with a unique key on the phone number. How to make it so that when inserting a duplicate record, instead of an error, the existing record is updated (INSERT ON CONFLICT DO UPDATE)?

What variable types are there in Go?

What is the difference between WHERE and HAVING?

What is the difference between INNER JOIN and LEFT/RIGHT JOIN?

What is the difference between DROP and TRUNCATE?

Is a primary key an index?

How does a clustered index differ from a non-clustered index?

How does string concatenation work in Go?.

What does the EXPLAIN command show, what data does it output?

What is the difference between EXPLAIN and EXPLAIN ANALYZE?

What types of indexes are in databases, what are their differences, and how do you decide when to use them?

Tell us about transaction isolation levels.