Which of the following statements is true? (refer to the tables in the JustLee Books database.)a. The MIN function can be used only with numeric data.b. The MAX function can be used only with date values.c. The AVG function can be used only with numeric data.d. The SUM function can’t be part of a nested function.

Which of the following statements is true? (refer to the tables in the JustLee Books database.)a. The MIN function can be used only with numeric data.b. The MAX function can be used only with date values.c. The AVG function can be used only with numeric data.d. The SUM function can’t be part of a nested function.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 1MC

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 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 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 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.
INFO 2303 Database Programing Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a function that takes patient date of birth. If the patient born after 30th June 1990 then he/she will be required to set appointment for immunization. Call this function from anonymous block to allow the user to enter the patient ID. Expected output: Enter the patient ID: 168 The status of X-immunization : REQUIRED
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
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 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 functiond. d. a and be. a, b, and c
Looking Up Data- INDEX () & MATCH() Which of the following statements describes how the INDEX) and MATCH() functions are combined to lookup data? A) MATCH() is used within the INDEX() function to return the relative position of the data in the lookup table B) INDEX) is used within the MATCH() function to return the relative position of the data in the lookup table C) MATCH() is used to match values from the lookup table and the source table, INDEX() returns the index of these values D) INDEX calculates the relative position of the data in the source table and returns values for MATCH() to lookup
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
on this table CREATE TABLE students ( std_id int NOT NULL PRIMARY KEY, f_name VARCHAR2(20), l_name VARCHAR2(20), std_address VARCHAR2(50), tel_no VARCHAR2(15), SEX VARCHAR2(10), birthdate date ); use PL/SQL oracle to solve create A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. arg is int all data are int and varchar2 and date