Cmput 291 Final Examination Over View Question Dec University Of Alberta

WHENEVER statements {Ans: Use to handle errors EXEC SQL WHENEVER SQLERROR}ROTATIONAL DELAY (aka LATENCY) {Ans: Latency depends on the rpm of the disk pack: min = 0s, max = 60 sec / rpm, avg = (max-min)/2.}Set of platters {Ans: Forms a disk pack that rotates around an axis called spindle Single sided or (more typically) double sided}Testing for LosslessNess {Ans: A (binary) decomposition of R = (R, F) into R1 = (R1, F1) and R2 = (R2, F2) is lossless if and only if : - either the FD • (R1 ∩ R2 ) → R1 is in F+ - or the FD • (R1 ∩ R2 ) → R2 is in F+}Cursor operations {Ans: Declaration, Open, Fetch, Close}Data Storage {Ans: data resides and is transported throughout a hierarchy of storage media}Heap Files {Ans: Unordered file because rows are appended to end of file as they are inserted Heap files are what exist when there are no indexes Access Path is Scan}Cache memory {Ans: speed up the execution of program instructions; exploit spatial/temporal locality when processing data}Lossless Schema Decomposition {Ans: A decomposition (R1,...,Rn) of a schema, R, is lossless if every