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

•
Question 6 The special operator used to check whether an attribute value is within a
range of values is ____.
•
Question 7 The ____ command is used to restore the table’s contents to their previous
values.
•
Question 8 Which of the following is used to select partial table contents?
•
Question 9 In Oracle, ____ make(s) it possible to merge SQL and traditional
programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops
(FOR and WHILE loops,) and error trapping.
•
Question 10 A ____ join returns rows with matching values and includes all rows from
both tables (T1 and T2) with unmatched values.
•
Question 11 The syntax for the UNION query is ____.
•
Question 12 A(n) ____ join will select only the rows with common values in the common
attribute(s).
• Question 13 The ANSI standard defines ____ type(s) of outer join(s)
• Question 14 The primary objective of database design is ____.
•
Question 15 Installing the DBMS, creating the database, and loading or converting the
data are part of the ____ phase of the DBLC.
•
Question 16 The process of creating an information system is known as ____
development.
•
Question 17 Evaluation, maintenance, and enhancement are part of the ____ phase of
the SDLC.
• Question 18 Analyzing the company situation is part of the ____ phase of the DBLC.
• Question 19 There are ____ stages in the DBLC.
•
Question 20 ____ are required to prevent another transaction from reading inconsistent
data.
•
Question 21 A consistent database is ____.
•
Question 22 A ____ lock allows concurrent transactions to access different rows of the
same table.