Week 6 Kahoot game

Which of the following is not a valid column alias?

• Customer_Name

• Customer Name

• CustomerName

• "Customer Name"

Which of the following WHERE clauses will return vendor names that start with a letter from A to D?

• WHERE vendor_name <= E

• WHERE vendor_name <= "E"

• WHERE vendor_name <= "D"

• WHERE vendor_name <= D

I want to query from the customers table and return all information about customers in DC. Which of the following queries would achieve this?

• SELECT *

  FROM customer

  WHERE state = "DC"

• SELECT *

  FROM customers

  WHERE state = DC

• SELECT *

  FROM cutsomers

  WHERE state = "DC"

• SELECT *

  FROM customers

  WHERE state = "DC"

If two tables have a one-to-many relationship, which table do you need to add a foreign key column to?

• The table on the "one" side

• The table on the "many" side

• Could be either table

What's the best TV show ever? (ungraded question)

Which of the normal forms resolves repeating or multi-valued columns?

• The first NF

• The second NF

• The third NF

• The fourth NF

For a table in the second normal form, each non-primary key column in the table must...

• Have a unique value

• Have a non-null value

• Depend on only one column that is part of the primary key of the given table

• Depend on all columns that make up the primary key of the given table

Which statement is false about the USING keyword?

• You can use it to simplify the syntax for joining tables.

• It can be used when the columns being compared have the same name.

• You can code a USING clause in addition to the ON clause.

• It can be used with inner or outer joins.

When is the first project standup taking place?

• Discussion tomorrow

• Today

• Next lecture

• Discussion next week

Like a join, a union combines data from two or more tables. But, instead of combining columns from base tables, a union...

• Combines rows from multiple base tables

• Combines the result sets of two or more SELECT statements

• Combines columns from the same table

• By default, does not eliminate duplicate rows