What is a transaction in DBMS, what are ACID properties? Explain the difference between SQL and NoSQL databases. How would you optimize a slow running query?

Question

Accepted Answer

A transaction in DBMS is a unit of work that must be executed as a whole. ACID properties ensure data integrity. SQL is relational, NoSQL is non-relational.

A transaction in DBMS is a set of operations that must be executed as a single unit.
ACID properties (Atomicity, Consistency, Isolation, Durability) ensure data integrity in transactions.
SQL databases are relational and use structured query language, while NoSQL databases are non-relational and offer more flexibility.
To optimize a slow running query, you can use indexing, analyze query execution plan, optimize database schema, and use caching.

What is a transaction in DBMS, what are ACID properties? Explain the difference between SQL and NoSQL databases. How would you optimize a slow running query?

Top 10405090xyzabc Software Engineer interview questions & answers

Popular interview questions of Software Engineer