CIS 336 Entire Course (Devry)
For more course tutorials visit
www.uophelp.com
CIS 336 Entire Course: Devry University
**************************************************************************************************************
CIS 336 Final Exam 4 (Devry)
For more course tutorials visit
www.uophelp.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".
2. (TCO 8) Write a query that will display the earliest date an order was placed.
3. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.
*************************************************************************************************************************************
CIS 336 Final Exam 2 (Devry)
For more course tutorials visit
www.uophelp.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, control, and recovery facilities. (Points : 4)
user
network
system
database
3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)
referential
restrictive
secondary
redundant
4. (TCO 2) A field that consists of integer values is a _________ type field. (Points : 4)
Date/Time
Yes/No
Memo
Numeric
5. (TCO 3) The PK must uniquely identify each entity instance. A...