CSE 180 UCSC Latest Questions And Answers Real Tests

CSE 180 UCSC Latest Questions And Answers Real
Tests
acid properties ANS Atomicity, Consistency, Isolation, Durability



Atomicity ANS all computes or none



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



Isolation ANS things do not trip over each other



Durability ANS transactions complete, then permanent in database



Attribute ANS name or column of a region



Relation Schema R ANS 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 ANS Property we want to maintain



Tuple ANS 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 ANS a set of elements that are usually represented by a table

Ex. A 2x2 table of elements that relate to things is a relation



Superkey ANS An attribute, or set of attributes, that uniquely identifies a tuple within a relation. Not
everything within has to be unique, just overall.



key ANS An attribute, or set of attributes, that uniquely identifies a tuple within a relation. Everything
within has to be unique.