SQL Server Interview Questions
database
structured data storage 🗃
data 📰
retreived 📤
managed
tables collection
rows/tuples/records
columns/attributes
relational database 🤝
data
related with each other
rows
related
other rows
FK
RDBMS
software
allows data
managed
queryied
stored
retrieved
Management System
Relationship Types 👪
1 to M
M to M
1 to 1
Entity
Object
rows
members
columns
attributes
Transaction
single task
if over
commits & stores changes
if error
cancels changes
ACID properties
Consistency
data
during transaction
Atomicity
1 single execution
1 transaction
Isolation
run as only
Durability 🔄
recoverable when required
Stored Procedure
statements 📜
stored 📥
DB server
⏫ query execution
used 📤
when required 📞
⏫ productivity
Function
code
compiled & executed
📞 when called
mandatory return ⚠
cannot call ❌☎
stored procedures
induvidual
characteristics
code
usually compiled
optional return 🔙
can call ☎
functions