CIS 111 Week 11 Final Exam (4 Set) CIS 111 Week 11 Final Exam (4 Set) | Page 9

Question 22 ____ means that data used during the execution of a transaction cannot be used
by a second transaction until the first one is completed.
Question 23 A ____ lock locks the entire table preventing access to any row by a transaction
while another transaction is using the table.
Question 24 The information stored in the ____ is used by the DBMS for a recovery
requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a
system failure such as a network discrepancy or a disk crash.
Question 25 A transaction is a ____ unit of work that must be either entirely completed or
aborted.
Question 26 A(n) ____ specifically reserves access to the transaction that locked the object.
Question 27 Data mining is part of the “____” section of the business intelligence framework.
Question 28 Question 29 A ____ schema is a type of star schema in which the dimension tables
can have their own dimension tables.
Question 30 A characteristic of decision support data is ____.
Question 31 Data ____ implies that all business entities, data elements, data characteristics,
and business metrics are described in the same way throughout the enterprise.
Question 32 In a star schema, attributes are often used to search, filter, or classify ____.
Question 33 Fact and dimension tables are related by ____ keys.
Question 34 Computed or derived facts are sometimes called ____ to differentiate them from
stored facts.
Question 35 In a typical star schema, each dimension record is related to thousands of ____
records.
Question 36 What is the first step in the exchange between a Web browser and a database?
Question 37 A programming language typically used for CGI scripts is ____.
Question 38 In the ____ category, the cloud service provider offers the capability to build and
deploy consumer-created applications using the provider’s cloud infrastructure.
Question 39 ODBC works on the ____ operating system.
Question 40 Microsoft’s alternative to Java is ____.