• 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 .