QUESTION 1

Select the correctly written query.

		SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID
		PULL * FROM CUSTOMERS WHERE CUSTOMERID = 10243
		SELECT * FROM CUSTOMERS WHERE CUSTOMERID = 10243
		GET LIST FROM CUSTOMERS

2 points

QUESTION 2

Which one is NOT a type of JOIN?

		INNER JOIN
		LEFT JOIN
		RIGHT JOIN
		OUTSIDE JOIN

2 points

QUESTION 3

Match the following terms with their definitions.

- A. B. C. D.	Primary Key
- A. B. C. D.	Secondary Key
- A. B. C. D.	Foreign Key
- A. B. C. D.	Candidate Key

A.	An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null.
B.	An attribute or combination of attributes used strictly for data retrieval purposes.
C.	A minimal ( irreducible) superkey; a superkey that does not contain a subset of attributes that is itself a superkey.
D.	A candidate key selected to uniquely identify all other attribute values in any given row; cannot contain null entries.

2 points

QUESTION 4

Normalization works through a series of stages called normal forms.

True

False

2 points

QUESTION 5

Storing data in a permanent, denormalized table is a recommended solution.

True

False

2 points

QUESTION 6

If a table has multiple candidate keys and one of them is a composite key, the table can have partial dependencies based on this composite candidate key, even when the primary key chosen is a single attribute.

True

False

2 points

QUESTION 7

A Primary Key can be used to uniquely identify a column or row within a table?

True

False

2 points

QUESTION 8

When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be ____?

		join-compatible
		domain-compatible
		shared-compatible
		union-compatable

2 points

QUESTION 9

Each table must have a two Primary keys.

True

False

2 points

QUESTION 10

The ER Model should be validated against expected processes. The 3 expected processes are inserts, updates, and _____.

		queries
		extracts
		distributes
		deletes