From logical to physical Flashcards
1
Q
3 level of access
A
Local Machine Level
Server Level
Database Lev
2
Q
Table Creation Order
A
the order matters
3
Q
Data Insertion Order
A
order matters as well.
4
Q
NULL Values
A
database does not mean zero or
empty
5
Q
NOT NUL
A
ensures that essential fields are always populated
6
Q
DEFAULT
A
provide a fall-back value when no data is supplied during an insert operation
7
Q
UNIQUE
A
applied to fields to avoid duplication.
8
Q
CHECK
A
limit the range of numeric or date fields
9
Q
ENUM DATA TYPE
A
predefined list,
10
Q
Column-Level Constraints
A
used when the constraint pertains only to that specific column
