1. A table can have only one

   	a.	Foreign Key
   	b.	Unique Key
   	c.	Primary Key
   	d.	Alternate Key

5 points

QUESTION 4

1. In the E-R diagram style that was illustrated in the Smart Draw video and web site, a weak entity is represented via

   	a.	Diamond
   	b.	Double Rectangle
   	c.	Oval
   	d.	Double Diamond

5 points

QUESTION 5

1. What word is likely missing from the query:

   SELECT emp_id, fname, lname,start_date, title FROM employee ______ title = 'Head Teller';

   a		WHICH
   b		WHERE
   c		FIND
   d		DISTINCT

5 points

QUESTION 6

1. Which SQL operator is typically used when you want to combine data from several tables?

   a		GROUP BY
   b		COMBINE
   c		JOIN
   d		HAVING

5 points

QUESTION 7

1. How many different "Normal Forms' have been defined by database theorists?

   a		4
   b		More than 4
   c		2
   d		3

5 points

QUESTION 8

1. When is is possible to take a Snapshot of your Virtualbox virtual machine?

   a		None of these
   b		Both of these (running or stopped)
   c		When the machine is running
   d		When the machine is stopped

5 points

QUESTION 9

1. What kinds of tables can be used as the source of data in SELECT queries? (i.e. as part of the FROM clause)

   a		Virtual Tables (from CREATE VIEW)
   b		Permanent tables (from CREATE TABLE)
   c		All of these
   d		Temporary Tables (from a subquery)

5 points