CIS 111 All Assignments CIS 111 All Assignments | Page 20

Question 12 The syntax for the UNION query is ____.
Question 13 A ____ join returns rows with matching values and includes all rows from both
tables (T1 and T2) with unmatched values.
Question 14 Question 15 Installing the DBMS, creating the database, and loading or converting
the data are part of the ____ phase of the DBLC.
Question 16 Creating the conceptual design and selecting DBMS software are part of the ____
phase of the DBLC.
Question 17 The traditional SDLC is divided into ____ phases.
Question 18 A detailed system specification is part of the ____ phase of the SDLC.
Question 19 User requirements, existing system evaluation, and logical system design are part
of the ____ phase of the SDLC.
Question 20 Lock ____ indicates the level of lock use.
Question 21 The implicit beginning of a transaction is ____.
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 ____.