Note the st column name is truncated this represents

This preview shows page 15 - 19 out of 31 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 2 / Exercise 16
Oracle 12c: SQL
Casteel
Expert Verified
Note: The ST column name is truncated, this represents the STATE column. Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table? A) SELECT INITCAP(firstname, lastname) FROM customers; B) SELECT LENGTH (city, state, zip) FROM customers; C) SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers; D) SELECT INITCAP((firstname),( lastname)) FROM customers; Points Earned: 2.2/2.2 Correct Answer(s): C Quiz for Chapter 10 (10 questions for 20 points) ...
7 of 8 3/9/2011 12:10 AM
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 2 / Exercise 16
Oracle 12c: SQL
Casteel
Expert Verified
9. Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. Which of the following SQL statements will return an error message, based upon the contents of the CUSTOMERS table? Points Earned: 2.2/2.2 Quiz for Chapter 10 (10 questions for 20 points) ...
8 of 8 3/9/2011 12:10 AM
1. If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first. Submitted by Velez,Jorge on 2/27/2011 2:24:12 PM Points Awarded 20.00 Points Missed 0.00 Percentage 100%
2. AVG, COUNT, and STDDEV are all considered group functions. Points Earned: 2.0/2.0
B) False 3. When the SELECT statement includes both WHERE and GROUP BY clauses, the GROUP BY clause is always evaluated first. A) True B) False Correct Answer(s): False Points Earned: 2.0/2.0 Correct Answer(s): True Points Earned: 2.0/2.0
4. The ____ function is used to determine how widely data are spread out within a group. Points Earned: 2.0/2.0
5. The ____ function calculates the standard deviation for a specific set of data. Points Earned: 2.0/2.0 Quiz for Chapter 11(10 questions for 20 points) ...
6. SUM, AVG, and COUNT are all considered group functions. 1 of 2 3/9/2011 12:11 AM
A) True B) False 7. If the DISTINCT keyword is not included in the AVG function, the ____ keyword will be assumed.
8. By default, the AVG function will include NULL values when calculating the average of the numeric values in a specified column. A) True B) False

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture