OMIS 452 Quiz 6 (Ch. 8) Questions with Correct Answers (Grade
A+)
Question 1: Database redesign is rarely needed because databases are usually built correctly the first
time. (T/F)
Answer: False
Question 2: The NOT EXISTS keyword will be true if any row in the subquery fails to meet the
condition (T/F)
Answer: False
Question 3: Changing table names is complicated by the fact that constraints and triggers are often
associated with the table and will also need to be changed. (T/F)
Answer: True
Question 4: Because EXISTS and NOT EXISTS are forms of correlated subqueries, the processing of
the associated SELECT statements must be nested. (T/F)
Answer: True
Question 5: In a real sense, information systems and organizations do not just influence each other,
but rather they create each other. (T/F)
Answer: True
Question 6: A continuous circular process of changes in user behaviors and change in the
information systems they use is a natural outcome of information system use. (T/F)
Answer: True
Question 7: The EXISTS keyword will be true if any row in the subquery meets the condition. (T/F)
Answer: True
Question 8: SQL contains an SQL command RENAME TABLENAME that can be used to change
table names. (T/F)
Answer: False
Page 1
A+)
Question 1: Database redesign is rarely needed because databases are usually built correctly the first
time. (T/F)
Answer: False
Question 2: The NOT EXISTS keyword will be true if any row in the subquery fails to meet the
condition (T/F)
Answer: False
Question 3: Changing table names is complicated by the fact that constraints and triggers are often
associated with the table and will also need to be changed. (T/F)
Answer: True
Question 4: Because EXISTS and NOT EXISTS are forms of correlated subqueries, the processing of
the associated SELECT statements must be nested. (T/F)
Answer: True
Question 5: In a real sense, information systems and organizations do not just influence each other,
but rather they create each other. (T/F)
Answer: True
Question 6: A continuous circular process of changes in user behaviors and change in the
information systems they use is a natural outcome of information system use. (T/F)
Answer: True
Question 7: The EXISTS keyword will be true if any row in the subquery meets the condition. (T/F)
Answer: True
Question 8: SQL contains an SQL command RENAME TABLENAME that can be used to change
table names. (T/F)
Answer: False
Page 1