CIS 111 Week 11 Final Exam (4 Set) CIS 111 Week 11 Final Exam (4 Set)

• Question 12 A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values. • Question 13 When using a(n) ____ join, only rows that meet the given criteria are returned. • Question 14 Analyzing the company situation is part of the ____ phase of the DBLC. • Question 15 Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC. • Question 16 Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC. • Question 17 The primary objective of database design is ____. • Question 18 Installation and fine tuning are part of the ____ phase of the SDLC. • 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 ____.

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