• Question 19 The traditional SDLC is divided into ____ phases.
• Question 20 Lock ____ indicates the level of lock use.
• Question 21 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 22 A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed.
• Question 23 The implicit beginning of a transaction is ____.
• Question 24 A( n) ____ condition occurs when two or more transactions wait for each other to unlock data.
• Question 25 A consistent database is ____.
• Question 26 A transaction is a ____ unit of work that must be either entirely completed or aborted.
• Question 27 A data mart is part of the“____” section of the business intelligence framework.
• Question 28 A characteristic of operational data is ____.
• Question 29 From the data analyst’ s point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.
• Question 30 In a star schema, attributes are often used to search, filter, or classify ____.
• 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 A characteristic of decision support data is ____.
• Question 33 The ____ contains business data extracted from the operational database and from external data sources.
• 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.