Database

Midierm 2018 (FalD Prof Serete Scott October 26, 2018 Name: Part I (15 Points) For each of the following questions answer True/False, select the appropriate letter that matches the correct answer or fill in the blank 1. When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true. a. True b. False 2. The DISTINCT operator is useful when used in conjunction with the COUNT function. a. True b. False 3. In a nested query, the outer query is evaluated first. a. True b. False 4. When you use the function, you can use the asterisk () to represent any column. a. SUM b. COUNT c. MAX d. MIN 5. In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as a. ovals b. equal signs c. lines d. circles