Which of the following is not a valid statement? (refer to the tables in the JustLee Books database.)a. You must enter the ALL keyword in a group function to include all duplicate values.b. The AVG function can be used to find the average calculated difference between twodates.c. The MIN and MAX functions can be used on any type of data.d. all of the abovee. none of the above

Which of the following is not a valid statement? (refer to the tables in the JustLee Books database.)a. You must enter the ALL keyword in a group function to include all duplicate values.b. The AVG function can be used to find the average calculated difference between twodates.c. The MIN and MAX functions can be used on any type of data.d. all of the abovee. none of the above

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 12MC

See similar textbooks

Similar questions

Which of the statements below is correct? (See the tables in the JustLee Books database for further information.) Only numeric data may be utilized with the MIN function. Only date values may be utilized with the MAX function. Only numeric data may be utilized with the AVG function. A nested function cannot contain the SUM function.
Which of the following statements is correct? (refer to the tables in the JustLee Books database.)a. The WHERE clause can contain a group function only if the function isn’t also listed in the SELECT clause.b. Group functions can’t be used in the SELECT, FROM, or WHERE clauses.c. The HAVING clause is always processed before the WHERE clause.d. The GROUP BY clause is always processed before the HAVING clause.
Which of the following functions is used to calculate the total value stored in a specified column? (refer to the tables in the JustLee Books database.)a. COUNTb. MINc. TOTALd. SUMe. ADD
I would like to create a function to sum up total order amount within the date range, but i don't know how to write the right query. The query below is for counting the total orders, but I want to change to sum up total order amount. The Database table is attached. Please assist. ************************************** USE SQLBook; DROP FUNCTION IF EXISTS GetDateRangewithordersAmountGO CREATE FUNCTION GetDateRangewithordersAmount( @startDate DateTime, @endDate DateTime)RETURNS TABLE ASRETURN ( select [State], count (*) as [TotalOrderAmount] FROM [SQLBook].[dbo].[Orders] WHERE [OrderDate] between @startDate AND @endDate group by [State])GO SELECT * FROM GetDateRangewithordersAmount('2015-09-01','2015-10-31');GO
Which of the following SELECT statements returns 30 as the result? (refer to the tables in the JustLee Books database.)a. SELECT ROUND(24.37, 2) FROM dual;b. SELECT TRUNC(29.99, 2) FROM dual;c. SELECT ROUND(29.01, -1) FROM dual;d. SELECT TRUNC(29.99, -1) FROM dual;
Which of the following functions can be used to include NULL values in calculations? (refer to the tables in the JustLee Books database.)a. SUMb. NVLc. MAXd. MIN
Which of the following functions can be used to substitute a value for a NULL value? (refer to the tables in the JustLee Books database.)a. NVLb. TRUNCc. NVL2d. SUBSTRe. both a and df. both a and c
Which of the following statements is correct? (refer to the tables in the JustLee Books database.)a. The IN comparison operator can’t be used with a subquery that returns only one row of results.b. The equals (=) comparison operator can’t be used with a subquery that returns morethan one row of results.c. In an uncorrelated subquery, statements in the outer query are executed first, and thenstatements in the subquery are executed.d. A subquery can be nested only in the outer query’s SELECT clause.
Create a function that converts temperature from Fahrenheit to Celsius. You need to use themost suitable data types for this operation. Use sql commands.
Which of the following is correct? (refer to the tables in the JustLee Books database.)a. A group function can be nested inside a group function.b. A group function can be nested inside a single-row function.c. A single-row function can be nested inside a group function. d. a and be. a, b, and c
Which of the following statements is correct? (refer to the tables in the JustLee Books database) a. A table can contain a maximum of only one column marked as unused. b. You can delete a table by removing all columns in the table. c. Using the SET UNUSED clause allows you to free up storage space used by a column. d. None of the above statements are correct.
Which of these statements regarding the VLOOKUP function is true? Question 18 options: A) The VLOOKUP function can be set up to find either exact or approximate matches for a value that is being looked up. B) Numerical values in the first column of the table must always be in decending order. C) When the VLOOKUP function is used to find an exact match to a text value the fourth argument is TRUE. D) With using VLOOKUP, the comparison table is read horizontally.