unit 6
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 character data.
15) The LIKE keyword can be used to search data with any kind of data type.
16) The BETWEEN keyword used in a criteria is inclusive of its boundary values.
17) When
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 character data.
15) The LIKE keyword can be used to search data with any kind of data type.
16) The BETWEEN keyword used in a criteria is inclusive of its boundary values.
17) When