Easy Database Administrator questions

34 questions · 5 points each for a correct first answer.

1. 1.Purpose of a primary keydata-modelling, sqleasy
2. 2.Third normal formnormalization, data-modellingeasy
3. 3.When a B-tree index helpsindexingeasy
4. 4.Durability in ACIDtransactionseasy
5. 5.INNER JOIN vs LEFT JOINsqleasy
6. 6.Full vs incremental backupbackup-recoveryeasy
7. 7.Least privilege for an app userdatabase-securityeasy
8. 8.DELETE vs TRUNCATEsqleasy
9. 9.Filtering rows where a value is NULLsqleasy
10. 10.COUNT(*) vs COUNT(column)sqleasy
11. 11.What a foreign key enforcesdata-modelling, sqleasy
12. 12.WHERE vs HAVINGsqleasy
13. 13.Data type for moneydata-modellingeasy
14. 14.Stopping SQL injectiondatabase-securityeasy
15. 15.Logical vs physical backupbackup-recovery, postgresqleasy
16. 16.Proving backups workbackup-recoveryeasy
17. 17.RPO and RTObackup-recovery, high-availabilityeasy
18. 18.Why a write-ahead log existspostgresql, transactionseasy
19. 19.Read-only access for analystsdatabase-security, postgresqleasy
20. 20.What pg_hba.conf controlsdatabase-security, postgresqleasy
21. 21.View vs materialized viewsql, postgresqleasy
22. 22.What ROLLBACK undoestransactionseasy
23. 23.UNION vs UNION ALLsqleasy
24. 24.Row order without ORDER BYsqleasy
25. 25.Why add a read replicareplicationeasy
26. 26.Seeing what is running nowpostgresql, monitoringeasy
27. 27.Cancel or terminate a sessionpostgresqleasy
28. 28.Why InnoDB over MyISAMmysqleasy
29. 29.Gaps in auto-increment IDsdata-modelling, postgresqleasy
30. 30.Storing event timesdata-modelling, postgresqleasy
31. 31.Rejecting bad valuesdata-modelling, sqleasy
32. 32.FATAL: too many clientsconnection-pooling, postgresqleasy
33. 33.Finding slow MySQL queriesmysql, query-tuningeasy
34. 34.Encrypting client connectionsdatabase-securityeasy