CIS 2210 - Database Management and Design

Review for Second Test

The following questions are provided to help you study for the second test. Do not expect to see these exact questions on the test.


  1. What are the ACID components of a good transaction?

  2. Why is serializability a necessity for systems with lots of transactions?

  3. When doing transactions, when should a commit command be given? How may the answer be different in a DDBMS situation?

  4. What is concurrency control? In what kind of a DBMS would it not be needed?

  5. Why are locks necessary in most database systems? What is their purpose?

  6. What are the five kinds of locks discussed in the text? What is a deadlock?

  7. What are the two phases in two-phase locking?

  8. What is timestamping about, and how does it assist the orderly running of a database?

  9. What are the general categories of failure found in recovery management?

  10. How are the functions of the lock manager and the scheduler different?

  11. What does the listener part of a DBMS do? What does it do most of the time?

  12. What are the three phases of processing a query? What happens in each one? (Hint: a lot of people are wrong about the second one.)

  13. What are some of the bottlenecks to processing a query noted by the text?

  14. What is an index for a table?

  15. Give an example of a built-in rule in a rule-based optimizer. How does a cost-based optimizer differ from the rule-based optimizer?

  16. What is data sparsity? How does its level affect your decision to create an index based on a column that holds data whose sparsity level is known?

  17. If your server is using hard drives, why might RAID improve DBMS performance? Which RAID level improves read and write speed, but does not improve fault tolerance? What are some RAID features that do improve fault tolerance?

  18. What is the main idea of the data-information-decision cycle?

  19. How do common management levels match the kinds of decisions often made at those levels?

  20. How is the enterprise database that is used for business decisions different from most of the database examples in the text?

  21. What is the difference between the line position and the staff position that the text describes as possible jobs for a DBA?

  22. What are three things that can be done to enhance DBMS performance?

  23. What is a name space? What is a table space? What is an extent?

  24. What is the default database storage engine for MySQL?

  25. Where should your data for a query be placed for fastest access?

  26. What are some reasons to use a distributed DBMS?

  27. What are some requirements for having a DDBMS?

  28. When does a DDBMS require distributed processing? Does it require distributed data storage?

  29. What feature does a DDBMS have if:
    • it performs as quickly as a local DBMS?
    • the user cannot tell it is accessing several kinds of databases?

  30. What is latency? How would it affect a DDBMS more than a local DBMS?

  31. What is the difference between vertical and horizontal fragmentation?

  32. What are some of the Microsoft protocols that are used to access databases? Which is the most commonly used? Which is used to access non-relational databases? Which is used specifically to access data through a web site?

  33. What is the source of native SQL connectivity?

  34. What is the difference between server-side and client-side extensions? What are some examples of each?

  35. Name two scripting languages often used in web pages.

  36. What is a KPI? Name some general ones.

  37. What does the T stand for in a SMART objective? How about the rest of it?

  38. How is a data warehouse different from a data mart? Where are you likely to find them?

  39. What is a star schema? What are its components? What should you find in each kind of component?

  40. What makes the central table of a star schema so large?

  41. What is Big Data? Why are the three Vs used to describe it not given hard definitions?

  42. What is Hadoop, besides the name of a toy elephant? What are its two major components? What are some of the odd features of its file system?

  43. What is meant by the phrase "NoSQL databases"? What are some of the things that are odd about them, compared to relational databases?

  44. Who are the companies that use the column family databases BigTable and Cassandra?