Pregunta de entrevista de SessionM
SQL (novice level): Primary versus Foreign keys. Types of JOINs and differences. What is Normalization? Why would one de-normalize?
Respuesta de la entrevista
Anónimo
27 jul 2018
PK is indexed. FK links to PK. INNER and OUTER (LEFT, RIGHT, FULL) determine which data is returned from which tables. Design best practice to reduce data redundancy. Reporting databases are often de-normalized.