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.
- What are the ACID components of a good transaction?
- Why is serializability a necessity for systems with lots of transactions?
- When doing transactions, when should a commit command be given? How
may the answer be different in a DDBMS situation?
- What is concurrency control? In what kind of a DBMS would it not
- Why are locks necessary in most database systems? What is their purpose?
- What are the five kinds of locks discussed in the text? What is a
- What are the two phases in two-phase locking?
- What is timestamping about, and how does it assist the orderly running
of a database?
- What are the general categories of failure found in recovery management?
- How are the functions of the lock manager and the scheduler different?
- What does the listener part of a DBMS do? What does it do most of
- 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.)
- What are some of the bottlenecks to processing a query noted by the
- What is an index for a table?
- 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?
- 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
- 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
- What is the main idea of the data-information-decision cycle?
- How do common management levels match the kinds of decisions often
made at those levels?
- How is the enterprise database that is used for business decisions
different from most of the database examples in the text?
- What is the difference between the line position and the staff position
that the text describes as possible jobs for a DBA?
- What are three things that can be done to enhance DBMS performance?
- What is a name space? What is a table space? What is an extent?
- What is the default database storage engine for MySQL?
- Where should your data for a query be placed for fastest access?
- What are some reasons to use a distributed DBMS?
- What are some requirements for having a DDBMS?
- When does a DDBMS require distributed processing? Does it require
distributed data storage?
- 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?
- What is latency? How would it affect a DDBMS more than a local DBMS?
- What is the difference between vertical and horizontal fragmentation?
- 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?
- What is the source of native SQL connectivity?
- What is the difference between server-side and client-side extensions?
What are some examples of each?
- Name two scripting languages often used in web pages.
- What is a KPI? Name some general ones.
- What does the T stand for in a SMART objective? How about the rest
- How is a data warehouse different from a data mart? Where are you
likely to find them?
- What is a star schema? What are its components? What should you find
in each kind of component?
- What makes the central table of a star schema so large?
- What is Big Data? Why are the three Vs used to describe it not given
- 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?
- What is meant by the phrase "NoSQL databases"? What are
some of the things that are odd about them, compared to relational databases?
- Who are the companies that use the column family databases BigTable