п»їUnit 6 Job 1: Groundwork
Learning Objectives and Outcomes
Name the main occasions in the progress SQL transactions.
Run CHOOSE queries with wild credit cards, DISTINCT key phrase, calculations, sorting and aliasing. Run queries with the IN WHICH clause to filter the end result sets. Utilize the Aggregate capabilities COUNT, AVG, SUM, MIN, and UTMOST.
Answer the true-or-false queries on the subsequent page by filling out the response sheet.
Submit your completed response sheet to your instructor at the outset of Unit several. Unit 6 True/False Concerns
Indicate if the following assertions are accurate or phony on the scholar answer bed sheet.
1) SQL is the coding language used to manipulate info and data objects in a relational database software system. 2) SQL is actually a procedural language.
3) A declarative terminology is a language in which you tell the computer how to handle it not how. 4) DML, or Info Manipulation Terminology, contains all the commands for choosing and changing data. 5) DDL, or Data Classification Language, consists of all the directions for selecting and modifying data. 6) The * in SELECT 5. clause of the SQL affirmation is a wildcard for coming back all content in a desk. 7) The DISTINCT keyword in a CHOOSE statement comes back only unique rows. 8) The FROM keyword is utilized in a CHOOSE clause to determine which content are included in the query. 9) An alias in SQL is a replace name to get a column or table. 10) When using a great alias in SQL, the AS key phrase is required.
11) By default, ORDER BY sorts a line in an climbing order. 12) DESC verso the sort purchase of ORDER BY.
13) The WHERE clause is used to set standards by which to filter which in turn rows will be returned or affected. 14) The LIKE key phrase can be used with the '%' to look for patterns in character data. 15) So on keyword can be used to search data with any kind of info type. 16) The AMONG keyword found in a requirements is including its...