BIS 345 Experience Tradition/uophelp.com

1
BIS 345 Experience Tradition/uophelp.com

• For more course tutorials visit
• www.uophelp.com

2
BIS 345 Final Exam Guide Set 1

• For more course tutorials visit www.uophelp.com
• (TCO 1) Which of the following sets of SQL
  clauses represent the minimum combination of
  clauses to make a working SQL statement? (Points
  5)
• SELECT, WHERE
• FROM, WHERE
• SELECT, FROM
• FROM, ORDER BY

3
BIS 345 Final Exam Guide Set 2

• For more course tutorials visit www.uophelp.com
• (TCO 1) Which of the following portions of an SQL
  Statement indicate the columns that should be
  included in the result set?(Points 5)
• SELECT
• FROM
• WHERE
• INSERT

4
BIS 345 Quiz 1

• For more course tutorials visit www.uophelp.com
• 1. (TCO 2) Use the ____ data type for columns
  that contain letters and special characters and
  for columns containing numbers that will not be
  used in calculations
•  2. (TCO 2) Which of the following functions
  would you use to extract characters from the
  middle of a string.
•  3. (TCO 2) Which date function will return the
  difference between two dates in the specified
  units?
•  4. (TCO 3) If you wanted to know the highest
  credit line in your customer database, which if
  the following functions would you use in your
  SQL.

5
BIS 345 Quiz 2

• For more course tutorials visit www.uophelp.com
• 1. (TCO 5) Which of the following is not an SSRS
  tool
•  2. (TCO 5) Reports created using report designer
  or report builder are generated in which of the
  following reporting languages.
•  3. (TCO 5) Which of the following tools is built
  on the Visual Studio 2008 shell
•  4. (TCO 5) Which of the following tools would
  you use to manage your SQL Server connection and
  reporting services?

6
BIS 345 Quiz 3

• For more course tutorials visit www.uophelp.com
• 1. (TCO 6) Which of the following is not a type
  of data source in SSRS
• 2. (TCO 6) Which of the data source credential
  options is the least recommended because of
  security risks
• 3. (TCO 5) All of the following are types of
  query for a data set except ________.
• 4. (TCO 6) _____ regions are items that must be
  associated with a data set.
• 5. (TCO 6) Data regions support grouping and
  ______.
• 6. (TCO 6) _____ is the simplest report item and
  contains no data values

7
BIS 345 Week 1 iLab

• For more course tutorials visit www.uophelp.com
• Student Name Name
• Using Lab 1, answer the questions and provide
  copies of your SQL Statements and/or results for
  each Section listed below
• Part A Customer List (4 points)
• a.What does the ORDER BY clause do?
•  b.Screen print your results and paste here
•  

8
BIS 345 Week 2 iLab

• For more course tutorials visit www.uophelp.com
• a.Lab 2 Student Answer Sheet
• Lab 2, answer the questions and provide copies of
  your SQL Statements and/or results for each
  Section listed below
•  Part A Employee List (4 points)
• a.What does Left function do? Is selecting the
  query and coping and could be pasted in a new
  query if is need it.

9
BIS 345 Week 3 iLab

• For more course tutorials visit www.uophelp.com
• Using Lab 3, answer the questions and provide
  copies of your SQL Statements and/or results for
  each Section listed below
• Part A Join two tables (4 points)
•  Paste your SQL Statement here
•  Screen print your results and paste here
•  Part B Join two tables and apply WHERE clause
  (4 points).

10
BIS 345 Week 4 iLab

• For more course tutorials visit www.uophelp.com
• Using Lab 4 provide copies of your SQL Statements
  and/or results for each Section listed below
• Part A Supplier and product list (10 points)
• a.Paste your SQL Statement here
• b.Screen print your results and paste here
•  sPart B Order information (10 points)
• a.Paste your SQL Statement here
• b.Screen print your results and paste here

11
BIS 345 Week 5 iLab

• For more course tutorials visit www.uophelp.com
• Using Lab 5, provide copies of your SQL
  Statements, results and reports for each Section
  listed below
• Part A Product and Category dataset (7 points)
•  Paste your SQL Statement here
•  Screen print your results and paste here
• Part B Product and Category report (10 points)

12
BIS 345 Week 6 iLab

• For more course tutorials visit www.uophelp.com
• Lab 6 Student Answer Sheet
•  Part A Product Cost History dataset (7 points)
•  Paste your SQL Statement here
•  Screen print your results and paste here

13
BIS 345 Week 7 iLab

• For more course tutorials visit www.uophelp.com
• Part A Territory Sales Dataset (5 points)
•  Paste your SQL Statement here
•  Screen print your results and paste here
•  Part B Territory Sales Report (10 points)

14
BIS 345 Experience Tradition/uophelp.com

• For more course tutorials visit
• www.uophelp.com