VOLUME 1 · CHAPTER 4
Database
1Outline of Database20 concepts
Database duplication and integrity1 questionRelational tables and attributes4 questionsOriginal relational-operation definitions2 questionsE-R arrowhead multiplicity3 questionsOriginal one-to-many E-R example1 questionOriginal normalization procedure3 questionsExclusive control preserves data integrity1 questionOriginal rollback and rollforward definitions3 questionsDatabase recovery logs2 questionsDatabase confidentiality and per-user access rights2 questionsConceptual database design and E-R models2 questionsDatabase locking: deadlock and granularity2 questionsTransitive functional dependencies1 questionAttributes and keys in table design1 questionACID transaction characteristics1 questionIndex for improving database search access2 questionsForeign key referential constraint2 questionsFunctional dependency in relational design1 questionPrimary key uniqueness and non-NULL constraints2 questionsDatabase schema definition1 question
2SQL11 concepts
COUNT and aggregate functions: original table continuation2 questionsEquijoin conditions in WHERE1 questionOriginal independent IN subquery3 questionsOriginal correlated EXISTS definition1 questionDECLARE CURSOR in the original cursor list1 questionGrouping rows and averaging scores1 questionOrdering grouped SQL results1 questionSQL LIKE wildcards1 questionOriginal SQL data types and constraints1 questionOriginal INSERT statement syntax1 questionFiltering aggregate groups with HAVING1 question