Selected Answer b Answers a b c d Question 13 2 out of 2 points When the OR

Selected answer b answers a b c d question 13 2 out

This preview shows page 4 - 8 out of 14 pages.

Selected Answer: b. * Answers: a. / b. * c. ? d. \ Question 13 2 out of 2 points When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true. Selected Answer: Tru e Answers: Tru e Fals e Question 14 2 out of 2 points When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line. Selected Answer: Fals e Answers: Tru e Fals e Question 15 2 out of 2 points
Image of page 4
The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction. Selected Answer: Fals e Answers: Tru e Fals e Question 16 2 out of 2 points The basic form of the SQL SELECT command is ____. Selected Answer: a. SELECT-FROM-WHERE Answers: a. SELECT-FROM-WHERE b. FROM-SELECT-WHERE c. FROM-WHERE-SELECT d. WHERE-SELECT-FROM Question 17 2 out of 2 points You cannot assign names to computed columns. Selected Answer: Fals e Answers: Tru e Fals e Question 18 2 out of 2 points All SELECT statements require a WHERE clause. Selected Answer: Fals e Answers: Tru e Fals e Question 19
Image of page 5
2 out of 2 points The MIN function determines the minimum value in a column. Selected Answer: Tru e Answers: Tru e Fals e Question 20 0 out of 2 points The ____ operator specifies a range of values in a condition. Selected Answer: b. GROUP Answers: a. LIKE b. GROUP c. BETWEEN d. DISTINCT Question 21 2 out of 2 points When you need to sort data on two columns, the less important column is called the ____ sort key. Selected Answer: c. minor Answers: a. foreign b. primary c. minor d. double Question 22 2 out of 2 points In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on separate lines. Selected Answer: Fals e
Image of page 6
Answers: Tru e Fals e Question 23 2 out of 2 points A query is a question represented in a way that the DBMS can understand. Selected Answer: Tru e Answers: Tru e Fals e Question 24 2 out of 2 points The DISTINCT operator is useful when used in conjunction with the COUNT function. Selected Answer: Tru e Answers: Tru e Fals e Question 25 2 out of 2 points The WHERE clause applies to both rows and groups.
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 14 pages?

  • Spring '16
  • Maksim

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture