Premium Essay

Unit 6 Assignment 1 Questions

In: Computers and Technology

Submitted By junior3535
Words 363
Pages 2
Unit 6 Assignment 1: Homework
Learning Objectives and Outcomes
Name the main events in the development of SQL statements.
Run SELECT queries with wild cards, DISTINCT key word, calculations, sorting and aliasing.
Run queries with the WHERE clause to filter the result sets.
Use the Aggregate functions COUNT, AVG, SUM, MIN, and MAX.

Assignment Requirements
Answer the true-or-false questions on the next page by filling out the answer sheet.

Required Resources
Textbook

Submission Requirements
Submit your completed answer sheet to your instructor at the beginning of Unit 7.

Unit 6 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.

1) SQL is the programming language used to manipulate data and data objects in a relational database management system. 2) SQL is a procedural language. 3) A declarative language is a language in which you tell the computer what to do not how. 4) DML, or Data Manipulation Language, contains all the commands for selecting and modifying data. 5) DDL, or Data Definition Language, contains all the commands for selecting and modifying data. 6) The * in SELECT * clause of an SQL statement is a wildcard for returning all columns in a table. 7) The DISTINCT keyword in a SELECT statement returns only unique rows. 8) The FROM keyword is used in a SELECT clause to determine which columns are included in the query. 9) An alias in SQL is a substitute name for a column or table. 10) When using an alias in SQL, the AS keyword is required. 11) By default, ORDER BY sorts a column in an ascending order. 12) DESC reverses the sort order of ORDER BY. 13) The WHERE clause is used to set criteria by which to filter which rows are returned or affected. 14) The LIKE keyword can be used with the '%' to search for patterns in...

Similar Documents

Free Essay

Network

...Integration Unit 1 Homework The following homework is designed to cover the course objectives for this unit. Assignment 1.1: Textbook/Workbook Assignments • Complete the following exercises and questions from Routers and Routing Basics: CCNA 3 Labs and Study Guide: Vocabulary Exercise: Matching on page 3 VLSM Subnetting a Subnet Exercises on pages 9-11 VLSM Addressing Design Scenarios 1-6 on pages 15-20 Summary Route Exercises on pages 21-24 Concept Questions on pages 25-27 VLSM Case Study on page 27 Internet Research on page 29 (Use the ITT Tech Virtual Library.) • Complete Chapter 9 Review Questions 2-7, 10, 14, 20-22 on pages 258-259 of Introduction to Telecommunications. Submit your written answers to your instructor at the beginning of Unit 2. . Assignment 1.2: Virtual Labs • Complete Virtual Labs 6, 7, and 8 from the CCNA 640-802 CCNA Simulator, which you can find by clicking through these paths: ICND1 Troubleshooting Scenarios Lab 6: IP Addressing and Routing. ICND1 Troubleshooting Scenarios ICND1 Part 4: Troubleshooting Labs Lab 7: IP Routing I ICND 2 Troubleshooting Scenarios Lab 13: IP Routing II Submit your written answers to your instructor at the beginning of Unit 2. ©ITT Educational Services, Inc: Date: 03/13/09 Network Technology and Service Integration Unit 2 Homework The following homework is designed to cover the course objectives for this unit. Assignment 2.1: Textbook/Workbook Assignments • Complete the following exercises and questions from......

Words: 2825 - Pages: 12

Premium Essay

Aaaaa

...J. C., & Griffin, M. (2013). Business research methods (9th ed.). Mason, OH: South-Western. Course Learning Outcomes Upon completion of this course, students should be able to: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Design and plan a research study. Apply statistical methods to business research. Apply research techniques to commerce and business issues. Differentiate between descriptive and inferential statistics. Devise the sampling theory into appropriate sampling distributions. Write and test a hypothesis. Contrast and compare descriptive, correlational, and qualitative non-experimental research. Contrast and compare experimental and quasi-experimental research. Write a publishable research proposal paper using APA guidelines. Apply ethical research standards. Credits Upon completion of this course, the students will earn three (3) hours of college credit. Course Structure 1. Unit Learning Outcomes: Each unit contains Learning Outcomes that specify the measurable skills and knowledge students should gain upon completion of the unit. 2. Unit Lesson: Each unit contains a Unit Lesson, which discusses unit material. 3. Reading Assignments: Each unit contains Reading Assignments from one or more chapters from the textbook. Suggested Readings are provided in the Unit I, II, III, IV, V, and VIII study guides to aid students in their course of study. The readings themselves are not provided in the course, but students are encouraged to read the...

Words: 3803 - Pages: 16

Premium Essay

Unit 1 Labs

...ITT TECHNICAL INSTITUTE NT1210 Introduction to Networking Onsite Course GRADED ASSIGNMENTS Graded Assignment Requirements Retain all handouts issued in every unit, as well as any assignment, research, or lab documents you prepare as part of assignments and labs. Some may be used more than once in different units. NOTE: Always check with your instructor for specific due dates of assignments. Graded Assignments Unit 1 Assignment 1: Computer Basics Review Course Objectives and Learning Outcomes Identify the major needs and major stakeholders for computer networks and network applications. Describe how digital devices store data. Describe the differences between input and output devices. Assignment Requirements In the Chapter Review Activities at the end of Chapter 1 in the Odom textbook (answers can be found in the textbook): Respond to the multiple-choice questions. Complete the List the Words inside Acronyms table. Required Resources Odom textbook Computer with word processing software Internet access Printer Submission Requirements: Submit your responses as a typed document using Arial or Times New Roman 12-point font, double-spaced. Label your assignment Unit 1 Assignment 1. Unit 2 Assignment 1: Identifying Network Topologies Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Identify the classifications of networks and how they......

Words: 16182 - Pages: 65

Premium Essay

Police Abuse Essay

...ITT TECHNICAL INSTITUTE NT1210 Introduction to Networking Onsite Course GRADED ASSIGNMENTS Graded Assignment Requirements Retain all handouts issued in every unit, as well as any assignment, research, or lab documents you prepare as part of assignments and labs. Some may be used more than once in different units. NOTE: Always check with your instructor for specific due dates of assignments. Graded Assignments Unit 1 Assignment 1: Computer Basics Review Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Describe how digital devices store data. * Describe the differences between input and output devices. Assignment Requirements In the Chapter Review Activities at the end of Chapter 1 in the Odom textbook (answers can be found in the textbook): * Respond to the multiple-choice questions. * Complete the List the Words inside Acronyms table. Required Resources * Odom textbook * Computer with word processing software * Internet access * Printer Submission Requirements: Submit your responses as a typed document using Arial or Times New Roman 12-point font, double-spaced. Label your assignment Unit 1 Assignment 1. Unit 2 Assignment 1: Identifying Network Topologies Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Identify......

Words: 16043 - Pages: 65

Premium Essay

Introduction to Networking

...ITT TECHNICAL INSTITUTE NT1210 Introduction to Networking Onsite Course GRADED ASSIGNMENTS Graded Assignment Requirements Retain all handouts issued in every unit, as well as any assignment, research, or lab documents you prepare as part of assignments and labs. Some may be used more than once in different units. NOTE: Always check with your instructor for specific due dates of assignments. Graded Assignments Unit 1 Assignment 1: Computer Basics Review Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Describe how digital devices store data. * Describe the differences between input and output devices. Assignment Requirements In the Chapter Review Activities at the end of Chapter 1 in the Odom textbook (answers can be found in the textbook): * Respond to the multiple-choice questions. * Complete the List the Words inside Acronyms table. Required Resources * Odom textbook * Computer with word processing software * Internet access * Printer Submission Requirements: Submit your responses as a typed document using Arial or Times New Roman 12-point font, double-spaced. Label your assignment Unit 1 Assignment 1. Unit 2 Assignment 1: Identifying Network Topologies Course Objectives and Learning Outcomes * Identify the major needs and major stakeholders for computer networks and network applications. * Identify......

Words: 16043 - Pages: 65

Premium Essay

Mba5501 Syllabus

...Objectives Upon completion of this course, students should be able to: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. Explain both the Marketing Concept and the Holistic Marketing Concept. Analyze the macroenvironments as related to the marketing process. Illustrate the use of marketing research and the forecasting of demand. Describe the development of customer value, satisfaction, and loyalty. Explain the use of customer relationship management in cultivating customer relationship. Illustrate the consumer buying process and the organizational buying process. Illustrate market segmentation, market targeting, and brand equity. Describe positioning and differentiation strategies. Illustrate the development of product strategy and explain competitive strategies. Explain the marketing strategies for service companies. Identify and explain the various pricing strategies. Describe the management of the retail and wholesale business. Classify the management of advertising, sales promotion, events, and public relations. Identify and explain direct marketing and personal selling. Outline and describe new product development. Credits Upon completion of this course, the students will earn three (3) hours of college credit. Course Structure 1. Unit Learning Objectives: Each unit contains Learning Objectives that specify the measurable skills and knowledge students should gain upon completion of the unit. 2....

Words: 3472 - Pages: 14

Premium Essay

Nt2640

...and Final Examination Answer Keys Added examination keys Immediately 03/18/2013 Answer Keys for Midterm and Final Updated some answers to address the accuracy March 2013 04/19/2013 Assignment labels on Pages 43, 52, 61, 78, 87, 97, 106 and 132. Added labels to identify additional assignments in affected units Clarification of additional assignments March 2013 Table of Contents COURSE OVERVIEW 5 Catalog Description 5 Goals and Expectations 5 Learning Objectives and Outcomes 6 Career Impact 6 INSTRUCTIONAL RESOURCES 7 Required Resources 7 Additional Resources 7 COURSE MANAGEMENT 9 Technical Requirements 9 Test Administration and Processing 9 Replacement of Learning Assignments 10 Communication and Student Support 10 Academic Integrity 10 GRADING 11 COURSE DELIVERY 13 Instructional Approach 13 Methodology 13 Facilitation Strategies 14 UNIT PLANS 15 Unit 1: The TCP/IP Model, LANs, WANs, and IP Networks 15 Unit 2: TCP/IP Network, Transport, and Application Layers 24 Unit 3: IP Subnetting and Basic Router Configuration 34 Unit 4: IP Routing with Connected, Static, and RIP-2 Routes 44 Unit 5: IP Troubleshooting and EIGRP 53 Unit 6: Subnet Design 62 Unit 7: Advanced IP Routing Topics and OSPF 69 Unit 8: Advanced IP Topics 79 Unit 9: LANs 88 Unit 10: WANs 98 Unit 11: Course Review and Final Examination 107 COURSE SUPPORT...

Words: 22068 - Pages: 89

Premium Essay

Accounting

...STUDENT COPY The following sections contain student copies of the assignments that must be distributed to students at least two weeks prior to the due dates for those assignments. Online students will have access to those documents in PDF format available for downloading at any time during the course. ------------------------------------------------- Graded Assignment Requirements Assignment Requirements documents provided below must be printed and distributed to students as the guidance for completing the assignments and submitting them for grading. Instructors must remind students to retain all handouts and assignment documents issued in every unit, as well as student-prepared documentation and graded deliverables. Some or all these documents will be used repeatedly across different units. Unit 1. Lab 1. Preparing a Virtual Workstation Image Windows 7 Virtual Machine “Keyless” Installation and Re-arm Process Purpose: This section describes the reason for and the procedure to use the “keyless” installation for Windows 7 Professional applicable to our lab environment for IT109/NT1230, and to use the “Re-arm” procedure to extend the trial period to meet our curriculum needs. Background: In installing Windows 7 Professional into a virtual machine in the VMware Player for the labs in our lab environment, if the Product Key for Windows 7 Professional is applied and activated during or at the end of the installation, the installed virtual machine will be......

Words: 5558 - Pages: 23

Premium Essay

Enron Bay

...|ENMU Ruidoso Branch Community College | |Course Syllabus | This course syllabus is required reading. Please make a copy of the syllabus and keep it handy for reference. |Course information: Adolescent Psychology; PSY 202 | | | |Semester: Fall I August 21-Oct. 12, 2012 |Year: 2012 | |Course #: PSY 202 |Title: Adolescent Psychology | |CRN #: 18858 |Credits: 3 | Instructor information: Dinah Hamilton, M.Ed. Dinah.Hamilton@enmu.edu 575-257-2120 X 385 Rationale for student taking this course: This course will meet the requirements for a Psychology course with General Core Education......

Words: 3023 - Pages: 13

Free Essay

123123123123

...|UNIVERSITI TUNKU ABDUL RAHMAN (UTAR) | | |FACULTY OF ACCOUNTANCY AND MANAGEMENT | | | | | |Bachelor of International Business (Hons) | | | | | |Unit Code & |UKFF4024 | | |Unit Title: |MULTINATIONAL FINANCE | | |Course of Study: |Bachelor of International Business (Hons) | | |Year of Study: |Year Three, Trimester Two | | |Trimester Year |Jan 2016 | | |Credit Hour: |4 credit hours ......

Words: 2523 - Pages: 11

Premium Essay

Financial Management

...Page 1 of 7 ASSIGNMENT 1st SEMESTER : STUDY UNITS COVERED DUE DATE TOTAL MARKS MATERIAL REQUIRED : : : : FINANCIAL MANAGEMENT (FM) MODULES 1 - 10 3pm Tuesday 16 March 2010 100 ANSWER SHEET Refer to page 7 INSTRUCTIONS TO CANDIDATES FOR COMPLETING AND SUBMITTING ASSIGNMENTS The complete “Instructions to Students for Completing and Submitting Assignments” must be collected from any IMM GSM office, the relevant Student Support Centre or can be downloaded from the IMM GSM website. It is essential that the complete instructions be studied prior to commencing your assignment. The following points highlight only a few important notes. 1) You are required to submit ONE assignment per subject. 2) The assignment will contribute 20% towards the final examination mark, and the other 80% will be made up from the examination, however the examination papers will count out of 100%. 3) Although your assignment will contribute towards your final examination mark, you do not have to earn credits for admission to the examinations; you are automatically accepted on registering for the exam. 4) Number all the pages of your assignment (page 1 of 4) and write your name and surname, student number and subject at the top of each page. 5) The IMM GSM requires assignments to be presented on plain A4 paper. You must show all working calculations, including and where appropriate multiple choice working calculations. 6) A separate assignment cover, which is provided by the IMM GSM, must be......

Words: 1992 - Pages: 8

Premium Essay

Diversity

...South-Western Cengage Learning, 2010; ISBN-13: 978-0-538-47808-3 Course Outline: Introduction Unit 1: Chapters 1, 4, 5 Chapter 1 – Exploring the World of Business and Economics Chapter 4 – Choosing a Form of Business Ownership Chapter 5 – Small Business, Entrepreneurship, and Franchises Unit Exam Unit 2: Chapters 9, 10, 11, 6, 7 Chapter 9 – Attracting and Retaining the Best Employees Chapter 10 – Motivating and Satisfying Employees and Teams Chapter 11 – Enhancing Union-Management Relations Chapter 6 – Understanding the Management Process Chapter 7 – Creating a Flexible Organization Unit Exam Unit 3: Chapters 12, 13, 14, 15 Chapter 12 – Building Customer Relationships Through Effective Marketing Chapter 13 – Creating and Pricing Products that Satisfy Customers Chapter 14 – Wholesaling, Retailing, and Physical Distribution Chapter 15 – Developing Integrated Marketing Communications Unit Exam Unit 4: Chapters 2, 18, 20, 3 Chapter 2 – Being Ethical and Socially Responsible Chapter 18 – Understanding Money, Banking, and Credit Chapter 20 – Understanding Personal Finances and Investments Chapter 3 – Exploring Global Business Unit Exam Final Exam (cumulative) Your final grade will be based on: Four Unit Exams 40% (10% each unit exam) Final Exam 20% Case Study 10% Questions of the Day 20% Homework and class participation ......

Words: 1187 - Pages: 5

Free Essay

Sc4730 Assignments

...INSTITUTE SC4730 Environmental Science Onsite Course GRADED ASSIGNMENTS ------------------------------------------------- Assignments and Exercises………………………………………………………… page 2 Labs…………………………………………………………………………………….page 16 Project…...............................................................................................................page 21 ------------------------------------------------- Graded Assignments Unit 1 Exercise 1: Statistics and Graphing Course Objectives and Learning Outcomes In this assignment, you will interpret and graph descriptive statistics. Assignment Requirements Work in small groups to complete Problems 1-4 given in the worksheet provided by your instructor (Problems Worksheets). This is also available at the link below. Fill out one activity sheet (found at the end of the document) for each of the 4 questions. Required Resources * Statistics and Graphing (SC2730.U1.HO1) Worksheets also available at: http://esa21.kennesaw.edu/activities/stats/stats.pdf * Problems Worksheets (SC2730.U1.HO2) also available at: http://esa21.kennesaw.edu/activities/stats/problems.pdf Submission Requirements 4 completed activity sheets (1 each for Problems 1-4) Unit 1 Problem Set 1: Scientific Method Applied Problem Sets Course Objectives and Learning Outcomes In this assignment, you will outline the steps of the scientific method. Assignment Requirements Refer to the Applied Problem Sets located on......

Words: 5239 - Pages: 21

Free Essay

Docx

...English IE2 READING & WRITING 1. Course Statistics : 120 periods (8 credits) Number of instruction weeks : 10 Number of sessions : 30 Number of sessions per week :3 Number of periods per session 2. Pre-requisite Number of periods :4 Students who achieved IE1 course score > 50 or scored from 35-60 on the Placement Test are required to take this course. 3. Learning outcome Students who have successfully completed the course are expected to have English proficiency at high intermediate level or higher. 4. Course books Reading Activator (Intermediate) Reading Activator (Advanced) Writing Activator (Intermediate) Writing Activator (Advanced) 5. Additional material ESP Handouts NorthStar 3 – Reading and Writing (3rd edition) 6. Lab Practice 2 sessions 7. Weekly Guide: Week 1 2 Session 1 ESP Unit 01: Information Technology - Handout 1 HW: NorthStar 3 Unit 1: The World of Advertising (pp 01- 10) Unit 02: Construction - Handout 2 HW: NorthStar 3 Unit 03: Going to Extremes Sports and Obsession (pp 3948) Unit 03: Engineering 3 4 Vocabulary and Reference Introduction & Review - Introduction to Reading Skills - R.A.I: pp 14-15; 18-31 - R.A.A: pp19-27 - Introduction to Writing Skills - Review: Paragraph writing (designed by the instructor) Fact and Negative Fact - R.A.I: pp 34-47 - R.A.A: pp 35-43 Independent writing Handout 1 - Overview of independent writing ...

Words: 938 - Pages: 4

Free Essay

Mm225 Unit 2 Asignment Business Management

...Unit 2: Instructor Graded Assignment Equations In this and future Instructor Graded Assignments you will be asked to use the answers you found in the Unit 1 Assignment. Note: For these questions you need to cite a reliable source for information, which means you cannot use sites like Wikipedia, Ask.com®, and Yahoo® answers. If you do use those sites the instructor may award 0 points for your response. The Assignment problems must have the work shown at all times. The steps for solving the problems must be explained. Failure to do so could result in your submission being given a 0. If you have any questions about how much work to show, please contact your instructor. Assignments must be submitted as a Microsoft Word® document and uploaded to the Dropbox for Unit 2. Type all answers directly in this Assignment below the question it applies to. All Assignments are due by Tuesday at 11:59 PM ET of the assigned Unit. Finding the National Average Price for Gas These first few questions will require you to use the internet to search for the national average price for gas. Remember to use a scholarly site for information. List the website(s) you visited here: http://fuelgaugereport.aaa.com/todays-gas-prices/.com 1. (2 points): What was the average price of a gallon of gas 1 year from when your business math class started? A month ago the national average gas price was 2.035 2. (5 points): You have $50 on hand and need to buy gas. How many......

Words: 1068 - Pages: 5