CIS 336 Final Exam Devry Remember Education--cis336.com

1
CIS 336 Final Exam Devry Remember
Education--cis336.com
2
CIS 336 Final Exam Devry Remember
Education--cis336.com
CIS 336 Final Exam (November, 2019) For more
course tutorials visit www.cis336.com CIS 336
Final Exam Question 1. 1. (TCO 1) A DBMS performs
several important functions that guarantee the
integrity and consistency of the data in the
database. Which of the following is NOT one of
those functions? Question 2. 2. (TCO 1) A
relational DBMS provides protection of the _____
through security, control, and recovery
facilities.
3
CIS 336 Final Exam Devry Remember
Education--cis336.com
CIS 336 Final Exam 1 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 1) Most
DBMS are referred to as _____________database
management systems. (Points 4) elemental linked
hierarchical relational 2. (TCO 1) Data
constitutes the building blocks of _____________.
(Points 4)
4
CIS 336 Final Exam Devry Remember
Education--cis336.com
CIS 336 Final Exam 2 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 1) Most
DBMS are referred to as _____________database
management systems. (Points 4) elemental linked
hierarchical relational 2. (TCO 1) A relational
DBMS provides protection of the
_______________________ through security
5
CIS 336 Final Exam Devry Remember
Education--cis336.com
CIS 336 Final Exam 3 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 2)
Explain what physical independence means. (Points
15) 2. (TCO 8) Sally wants to query the EMP
table and determine how many of the employees
live in each of the cities the company has
factories in. She writes the following query but
it does not work. What is wrong with the way the
query is constructed?
6
CIS 336 Final Exam Devry Remember
Education--cis336.com
CIS 336 Final Exam 4 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 7) For
every order, list the order number, order date,
part number, part description, and item class for
each part that makes up the order. 2. (TCO 8)
Write a query that will display the customer
number, last name, and first name for every
customer I whose first name begins with the
letter "D".
7
CIS 336 Final Exam Devry Remember
Education--cis336.com
CIS 336 Final Exam 4 Sets of Answers (Devry)
For more course tutorials visit www.cis336.com  
CIS 336 Final Exam 4 Sets of Answers  
8
CIS 336 Final Exam Devry Remember
Education--cis336.com