Lecture 4 Quiz
Primary key has to be
exactly one column
any unordered subset of columns
max three columns
any ordered subset of columns
What can cause database inconsistency?
Primary key with two cloumns of different data types (one int and one string)
Using hash tables instead of b-tree for indexing
Dangling foreign key (ie it points to a primary key that doesn't exist)
None of the above
Which one is correct?
With b-trees insertion operations are O(1)
B-trees are better than hash tables for range queries
Row lookup is O(nlogn) with b-tree indexes
All are wrong
Never submit passwords through Google Forms.
This form was created inside of Carnegie Mellon University.
Terms of Service