Week 8 Kahoot challenge

If a column contains the following values: "5", "5A", "5B", "6", and "6AA". What data type should the column be?

• CHAR

• INT

• CONCAT

• VARCHAR

Which datetime format code represents the abbreviated month name? (Like Jan instead of January)

• %b

• %M

• %m

• %a

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

• The table on the "one" side

• The table on the "many" side

• Could be either table

• I don't understand the question

In what scenario do we create a linking table?

• When one entity is functionally dependent on the other entity

• When there are repeating columns

• When two entities are partially dependent on one another

• I hate normalization, skip this question

What's your favorite villain character of all time? (Ungraded)

What does SQL do when you run this query?

DELETE FROM table1;

(Assume safe mode has been disabled)

• Deletes the last row of the table

• Deletes all rows in the table

• Deletes the entire table

• Throws an error because it's missing a WHERE clause

If I wanted to do a full outer JOIN of two tables, which clause(-s) would I use?

• LEFT JOIN, UNION, RIGHT JOIN

• INNER JOIN, UNION, INNER JOIN

• CROSS JOIN, UNION

• SOVIET UNION

Which date value will SQL not accept?

• "2018.08.15"

• 20180815

• "20180815"

• "2018-15-08"

Which icon in an ERD represents an attribute of an entity?

(an attribute that is not a PK or FK)

• Circle

• Key

• Arrow

• Diamond

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 customers

  WHERE state = "DC"

• SELECT *

  FROM customer

  WHERE state = "DC"

• SELECT *

  FROM customers

  WHERE state = DC

• SELECT *

  FROM cutsomers

  WHERE state = "DC"