CIS 336 Education key to Success / cis336.com

1
CIS 336 Education key to Success / cis336.com
2
CIS 336 Education key to Success / cis336.com

• CIS 336 Final Exam (Feb 2016)
•  
• 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

3
CIS 336 Education key to Success / cis336.com

• CIS 336 Final Exam (July,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

4
CIS 336 Education key to Success / 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

5
CIS 336 Education key to Success / 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

6
CIS 336 Education key to Success / 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

7
CIS 336 Education key to Success / 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.

8
CIS 336 Education key to Success / 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

9
CIS 336 Education key to Success / cis336.com

• CIS 336 Group Project
•  
• For more course tutorials visit
• www.cis336.com
•  
• This project is designed to touch all aspects of
  the fundamental concepts of database design and
  logical data modeling covered during the class.
  Each student will be responsible for designing,
  developing, and demonstrating the functionality
  of a

10
CIS 336 Education key to Success / cis336.com

• CIS 336 iLab 1 Normal Forms and Entity
  Relationship Diagrams
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS336 Lab 1 Normal Forms and Entity
  Relationship Diagrams
• Introduction

11
CIS 336 Education key to Success / cis336.com

• CIS 336 iLab 2 The Expanded Entity Relationship
  Diagram
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS336 Lab 2 The Expanded Entity Relationship
  Diagram
• LAB OVERVIEW

12
CIS 336 Education key to Success / cis336.com

• CIS 336 iLab 3 Building the Physical
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS-336 Lab 3 Building the Physical
• LAB OVERVIEW
• Scenario and Summary

13
CIS 336 Education key to Success / cis336.com

• CIS 336 iLab 4 Introduction to Select, Insert,
  Update, and Delete Statements (only SQL Command,
  No output)
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS336 Lab 4 Introduction to Select, Insert,
  Update, and Delete Statements
• LAB OVERVIEW

14
CIS 336 Education key to Success / cis336.com

• CIS 336 iLab 5 Joining Tables
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS336 Lab5 Joining Tables
• LAB OVERVIEW
• Scenario and Summary

15
CIS 336 Education key to Success / cis336.com

• CIS 336 iLab7 Working with Views
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS-336 Lab7 Working with Views
• LAB OVERVIEW
• Lab 7 will introduce the concept of database
  views. This lab may be completed using

16
CIS 336 Education key to Success / cis336.com

• CIS 336 Quiz 1 (Devry)
•  
• For more course tutorials visit
• www.cis336.com
•  
• (TCO 3) Normalization works through a series of
  stages called normal forms. Typically _________
  stages must be completed before a table can be
  considered normalized.

17
CIS 336 Education key to Success / cis336.com

• CIS 336 Quiz 2 (Devry)
•  
• For more course tutorials visit
• www.cis336.com
•  
• (TCO 2) Explain what a composite attribute is
• (TCO 1) Data constitutes the building blocks of

18
CIS 336 Education key to Success / cis336.com

•  
• CIS 336 Quiz 3 (Devry)
•  
• For more course tutorials visit
• www.cis336.com
•  
• (TCO 7) Which of the following types of columns
  will automatically right-align the data when it
  is displayed?
• (TCO 7) Which of the following

19
CIS 336 Education key to Success / cis336.com

• CIS 336 Quiz 4 (Devry)
•  
• For more course tutorials visit
• www.cis336.com
•  
• (TCO 8) If a Cartesian join is used to link table
  A which contains five rows to table B which
  contains eight rows, there will be _______ rows
  in the results.

20
CIS 336 Education key to Success / cis336.com

• CIS 336 Quiz 5 (Devry)
•  
• For more course tutorials visit
• www.cis336.com
•  
• (TCO 6) Which of the following keywords is used
  to remove a row in a table?
• (TCO 6) When using the ALTER TABLE...DROP COLUMN
  command, which of the

21
CIS 336 Education key to Success / cis336.com

• CIS 336 Week 2 Quiz (New)
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS 336 Week 2 Quiz
• Question 1. (TCO 1) Raw facts,
  such as a telephone number, a birth date, and a
  customer name, are also referred to as _____

22
CIS 336 Education key to Success / cis336.com

• CIS 336 Week 3 Quiz (New)
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS 336 Week 3 Quiz
•  
• Question 1. (TCO 3) When
  designing a database, you should _____
• Question 2. (TCO 3) A table that
  is in 1NF and includes no partial

23
CIS 336 Education key to Success / cis336.com

• CIS 336 Week 4 Quiz (New)
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS 336 Week 4 Quiz
• Question 1. (TCO 7) Which of the
  following types of columns will automatically
  right-align the data when it is displayed?

24
CIS 336 Education key to Success / cis336.com

• CIS 336 Week 5 Quiz (New)
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS 336 Week 5 Quiz
• Question 1. (TCO 8) The ____ set
  operator in SQL combines rows from two queries
  and returns only the values that are common
  between the two sets.

25
CIS 336 Education key to Success / cis336.com

• CIS 336 Week 6 Quiz (New)
•  
• For more course tutorials visit
• www.cis336.com
•  
• CIS 336 Week 6 Quiz
• Question 1. (TCO 6) Which of the
  following keywords can be used to change the
  size, datatype, or default value of an existing
  column?

26
CIS 336 Education key to Success / cis336.com