CSE 180 UCSC UPDATED ACTUAL Exam Questions and CORRECT Answers

CSE 180 UCSC UPDATED ACTUAL Exam
Questions and CORRECT Answers
acid properties - CORRECT ANSWER - Atomicity, Consistency, Isolation, Durability



Atomicity - CORRECT ANSWER - all computes or none



Cartestian Product - CORRECT ANSWER - product of two sets A and B, that have their
elements paired up to each other


Isolation - CORRECT ANSWER - things do not trip over each other



Durability - CORRECT ANSWER - transactions complete, then permanent in database



Attribute - CORRECT ANSWER - name or column of a region



Relation Schema R - CORRECT ANSWER - is a set {A1, ..., Ak} of attributes, often
written as R(A1, ..., Ak), where Ai is the name of the ith column of the relation


Consistency - CORRECT ANSWER - Property we want to maintain



Tuple - CORRECT ANSWER - a row in a table that contains data about a specific item in
a database table
Example: In a 3x3 table, 3 tuples (rows)


relation - CORRECT ANSWER - a set of elements that are usually represented by a table
Ex. A 2x2 table of elements that relate to things is a relation