CIS 331: Database Management Using SQL
Review for Second Test
- What is a multiple table query? Why does the text sometimes refer
to it as a JOIN operation?
- When performing a multiple table query, what part of the command relates
- Why do you qualify some field names in a query? How do you do so?
- What clauses in a query are most likely to use qualified field names?
- What is a subquery? What are some operators that can be used between
inner and outer queries?
- When a subquery makes reference to the table that is only listed in
the FROM clause of the outer query, what do you call the subquery?
- What do you call a subquery inside another subquery?
- When queries are nested, in what order are they evaluated? What math
convention is used that makes this more understandable?
- What is an alias for a table? Why might you use an alias?
- What is a self join? The text shows an example of one. What was the
reason given for performing this kind of join?
- What are set operations? How many tables do you need to perform a
- What is the difference set operation? What would it result in?
- What is an intersection operation?
- What is a union operation? What must be true of tables to make them
- When do you use the ANY operator?
- When do you use the ALL operator?
- What is the difference between an inner join and an outer join?
- What are the three kinds of outer join? What do their names refer
- How can you accidentally create a PRODUCT query? Why may you want
to avoid this?
- What is normalization? What are the names of the standard normal forms?
What update anomalies can occur if tables are not normalized?
- How do you tell if a table is in first normal form?
- How do you tell if a table is in second normal form?
- How do you tell if a table is in third normal form?
- Give an example that explains the phrase "functionally dependent".
- Give an example that explains the phrase "functionally determines".
- What is a determinant?
- What is a key? What are the kinds of keys discussed in your texts?
How do keys relate to normalization?
- How can we have update problems as a result of lack of normalization?
- How can we have inconsistent data as a result of not having normalized
- What is a partial dependency?
- What is multivalued dependence? How might it occur in a database?
- What are the functions of a DBMS discussed in the text?
- How might a DBMS support concurrent update from multiple users?
- Why is disaster recovery a necessary feature of a DBMS?
- What is the purpose of data replication? What other feature in the
chapter would this support?
- What is meant by catalog services in a DBMS? Who should have access
to the catalog of a DBMS?
- What are two versions of locking that might be used by a DBMS? What
problem is locking meant to avoid?
- When a user sends an update to the DBMS, what is the general term
for that action?
- What is a deadly embrace? What term is used in your text for this
kind of problem?
- How is a deadlock typically resolved? Who is the victim in the resolution?
What should happen to the victim's data?
- What is timestamping transactions? Why would we do that?
- How are encryption and decryption used in database systems?
- How is authentication used in a DBMS? What two pieces of information
must a user typically have?
- How does biometric authentication work?
- How is authorization different from authentication?
- What is an integrity constraint? What kind of errors will it avoid?