CIS 111 help Making Decisions/uophelp.com CIS 111 help Making Decisions/uophelp.com | Page 23

• Question 9 The ____ operator could be used in place of INTERSECT
if the RDBMS does not support it.
• Question 10 The syntax for the UNION query is ____.
• Question 11 The ANSI standard defines ____ type(s) of outer join(s)
• 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