5 Written Questions

1. is supperior for handling large scale internet and intranet applications
2. supports multiple data re3quests for data at multiple locations. each request is for data on a single server
3. a table that is in 2NF for which no non-PK column is transitively dependent on the PK
   In other words, the 3NF is violated when a non-PK column is a fact about another non-PK column
4. -WITH GRANT OPTION permits a user to pass privileges to another user
5. a table that is in 1NF for which every non-PK column is fully functionally dependent on the PK
   In other words, the 2NF is violated when a non-PK column is a fact about part of the primary key

5 Matching Questions

1. grant
2. revoke
3. data mining
4. management tools
5. DML

1. a Extraction: Pulling data from existing systems.
   Transformation: Data must be standardized and follow consistent coding schemes.
   Cleaning: Removing errors, inconsistencies, or redundancies.
   Loading: Copying operational data in the data warehouse (archival, current, or ongoing).
   Scheduling: Refreshing the warehouse.
   Metadata: Data dictionary containing facts about the data in the warehouse.
2. b -removes privaledges, When a user's privileges are revoked, so are all those privileges which were passed on by this user.
3. c the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
4. d data manipulation language- is used to maintain and query a database
5. e -defines users privaledges

5 Multiple Choice Questions

1. is good for building departmental applications, such as decision support and groupware, however doesn't scale well
   1. 2 tier
   2. entities
   3. index
   4. 3 tier
2. maintains the accuracy of the database. its application means that every foreign key in a table has an identical primary key in that soame table or another table
   1. Referential Integrity
   2. entities
   3. entity integrity
   4. grant option
3. approach to data analysis is driven by a hypothesis about some relationship in the data
   1. thin-client
   2. grant option
   3. verification
   4. entities
4. approach to data analysis sifts through the data in search of frequently occurring patterns and trends
   1. 3 tier
   2. revoke
   3. discovery
   4. slock
5. 3-tier moves the application logic to the server, known as a ___-___ or thick-server architecture
   1. thin-client
   2. entities
   3. discovery
   4. index

5 True/False Questions

1. concurrency control → the process of managing simultaneous operations on the database without having them interfere with one another

   True        False

2. benefits of data warehouse → lower data redundancy, centralizes data, increased data accuracy and standardization, more consistent data.

   True        False

3. OLAP-online analytical processing → - the analysis of business operations with the intentino of making timely and accurate analysis-based decisions

   True        False

4. dirstributed request → supports multiple data re3quests for data at multiple locations. each request is for data on a single server

   True        False

5. fat "thick" client → the client in the two-tier model of C\S is also called a ____ ____, because most of the processing runs on the client side

   True        False