Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL Server Interview Questions - Coggle Diagram
SQL Server Interview Questions
database
structured data storage :card_file_box:
data :newspaper:
retreived :outbox_tray:
managed
tables collection
rows/tuples/records
columns/attributes
relational database :handshake:
data
related with each other
rows
related
other rows
FK
RDBMS
software
allows data
managed
queryied
stored
retrieved
Management System
Relationship Types :family:
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
induvidual
Durability :arrows_counterclockwise:
recoverable when required
Stored Procedure
statements :scroll:
stored :inbox_tray:
DB server
:arrow_double_up: query execution
used :outbox_tray:
when required :telephone_receiver:
:arrow_double_up: productivity
characteristics
code
usually compiled
optional return :back:
can call :phone:
functions
Function
code
compiled & executed
:telephone_receiver: when called
mandatory return :warning:
cannot call :red_cross::phone:
stored procedures