SQL Server Interview Questions

database database_FILL0_wght400_GRAD0_opsz48

structured data storage 🗃

data 📰

retreived 📤

managed calculate_FILL0_wght400_GRAD0_opsz48

table_FILL0_wght400_GRAD0_opsz48 tables collection

rows/tuples/records table_rows_FILL0_wght400_GRAD0_opsz48

columns/attributes view_week_FILL0_wght400_GRAD0_opsz48

relational database 🤝

data

related with each other

rows

related

other rows

FK

RDBMS database database

software

allows data

managed

queryied

stored

retrieved

Management System

Relationship Types 👪

1 to M table_rows_FILL0_wght400_GRAD0_opsz48

M to M

1 to 1

Entity

Object data_object

rows

members

columns

attributes

Transaction

single task single

if over

commits & stores changes save

if error

cancels changes cancel

ACID properties

Consistency update

data

during transaction

Atomicity execution

1 single execution execution2

1 transaction

Isolation isolation

run as only

Durability 🔄

recoverable when required robbed

Stored Procedure

statements 📜

stored 📥

DB server database

⏫ query execution

used 📤

when required 📞

⏫ productivity

Function

code code

compiled & executed translate check_circle

📞 when called

mandatory return ⚠

cannot call ❌☎

stored procedures

induvidual individual

characteristics

code code

usually compiled translate

optional return 🔙

can call ☎

functions