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

•
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 implicit beginning of a transaction is ____.
•
Question 25 A ____ lock prevents the use of any tables in the database from one
transaction while another transaction is being processed.
• Question 26 Lock ____ indicates the level of lock use.
• Question 27A characteristic of decision support data is ____.
• Question 28 Analyzing decision support data to generate information is part of ____.
•
Question 29 The ____ contains business data extracted from the operational database
and from external data sources.
•
Question 30 ____ are in charge of presenting the data to the end user in a variety of
ways.
•
Question 31 A characteristic of operational data is ____.
•
Question 32 The basic star schema has four components: facts, ____, attributes, and
attribute hierarchies.
•
Question 33 Fact and dimension tables are related by ____ keys.
•
Question 34 A ____ schema is a type of star schema in which the dimension tables can
have their own dimension tables.
•
Question 35 Computed or derived facts are sometimes called ____ to differentiate them
from stored facts.
•
Question 36 ____ is embedded inside an HTML page and is activated by triggering
events such as clicking on a link.
•
Question 37 ____ is a collection of technologies used to access any type of data source
and manage the data through a common interface.
•
Question 38 The Web browser’s job is to ____ the HTML code that it receives from the
Web server.
• Question 39 A programming language typically used for CGI scripts is ____.
• Question 40 Which of the following is a well-defined Web-server interface?