Lecture Materials Week 10 (File Name)

Question 1

Information systems used to support management decisions by producing info for assessment, analysis, planning

Answer 1

Business Intelligence systems

Question 2

Business Intelligence systems store their associated data in ____ __________

Answer 2

data warehouses

Question 3

The fundamental framework for an SQL query

Answer 3

The select statement

Question 4

All SQL statements end with a

Answer 4

semicolon

Question 5

The 6 parts of a select statement

Answer 5

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Question 6

The WHERE clause

Answer 6

is a conditional statement used to filter records

Question 7

The GROUP BY clause

Answer 7

is used with aggregate functions

Question 8

of the 6 parts of a SELECT statement, name the 2 mandatory parts

Answer 8

SELECT and FROM

Question 9

The ORDER BY clause

Answer 9

sorts results

Question 10

The syntactical order for SELECT statements

Answer 10

SELECT > FROM > WHERE > GROUP BY > HAVING > ORDER BY

Question 11

In the field list of the select statement, the * wildcard

Answer 11

means include all avalable columns

Question 12

In the field of the select statement, the comma is used when

Answer 12

there is a defined list, using commas to separate fields

Question 13

T/F - The order of the fields in the SELECT statement determines the order of the columns in the table

Answer 13

True

Question 14

This keyword eliminates duplicates in SQL

Answer 14

DISTINCT

Question 15

Keyword to limit how many rows are used

Where does this keyword appear?

Answer 15

LIMIT {number}

Keyword comes at the end of the query after any ORDER BY statements

Question 16

Conditional Statements are known as the WHERE clause, what are 4 examples

Answer 16

1. Series of Bool expressions
2. Several operators
3. Multiple clauses
4. Brackets

Question 17

SQL requires the use of _______ quotes

Answer 17

single

Question 18

The SQL % wildcard represents any sequence of _________ characters in a specific position in a string

Answer 18

contiguous

Question 19

If a statement attaches

WHERE SKU LIKE “%2__”

What SKU’s will come up?

Answer 19

Any that have 2 and then 2 other characters following it.

Question 20

T/F - SQL requires that the column used in the WHERE clause also appears in the SELECT clause

Answer 20

False

Question 21

Used to rename objects for the duration of the query

Answer 21

Aliases

Question 22

Aliases can rename _____ or ______

Answer 22

fields or tables

Question 23

Field renaming is good for

Answer 23

Ensuring valid field names when data is exported

Question 24

Table renaming becomes important when

Answer 24

JOINS are involved

Question 25

Alias Column Syntax order column_name AS SELECT FROM alias_name table_name

Answer 25

SELECT column_name AS alias_name FROM table_name

Question 26

Alias Table Syntax column_name FROM table_name SELECT alias_name AS

Answer 26

SELECT column_name FROM table_name AS alias_name

Question 27

Another advantage of aliases is that you can _____ columns and give them a single name

Answer 27

merge Example: Select blah( 'blah', 'blahblah', 'blahah' ) as Politicians