Which of the following is not a valid SQL statement? (refer to the tables in the JustLee Books database.)a. SELECT MIN(pubdate)FROM booksGROUP BY categoryHAVING pubid = 4;b. SELECT MIN(pubdate)FROM booksWHERE category = 'COOKING';c. SELECT COUNT(*)FROM ordersWHERE customer# = 1005;d. SELECT MAX(COUNT(customer#))FROM ordersGROUP BY customer#;

Which of the following is not a valid SQL statement? (refer to the tables in the JustLee Books database.)a. SELECT MIN(pubdate)FROM booksGROUP BY categoryHAVING pubid = 4;b. SELECT MIN(pubdate)FROM booksWHERE category = 'COOKING';c. SELECT COUNT(*)FROM ordersWHERE customer# = 1005;d. SELECT MAX(COUNT(customer#))FROM ordersGROUP BY customer#;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

Which of the following is not part of a standard SQL statement? a. Importable programming libraries b. Predicate c. Expressions d. Clauses
Which of the following is a valid SQL statement? (refer to the tables in the JustLee Books database.)a. SELECT customer#, order#, MAX(shipdate-orderdate)FROM ordersGROUP BY customer#WHERE customer# = 1001;b. SELECT customer#, COUNT(order#)FROM ordersGROUP BY customer#;c. SELECT customer#, COUNT(order#)FROM ordersGROUP BY COUNT(order#);d. SELECT customer#, COUNT(order#)FROM ordersGROUP BY order#;
In SQL Server, describe the distinction between the two data types for the characters as follows: NVARCHAR NVARCHAR NVARCHAR
Which of the following SQL statements is invalid and returns an error message? ( refer to the tables in the JustLee Books database). a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); c. ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); d. ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); e. All of the above statements are invalid
The map function is equivalent to the SQL WHERE clause. True or false? (A) True (B) False
Which of the following operators is considered a single-row operator? (refer to the tables in the JustLee Books database.)a. INb. ALLc. <>d. <>ALL
Given the following SQL statement, which statement is most accurate?SELECT customer# FROM customersJOIN orders USING(customer#)WHERE shipdate-orderdate IN(SELECT MAX(shipdate-orderdate) FROM ordersWHERE shipdate IS NULL);a. The SELECT statement fails and returns an Oracle error message.b. The outer query displays no rows in its results because the subquery passes a NULLvalue to the outer query.c. The customer number is displayed for customers whose orders haven’t yet shipped.d. The customer numbers of all customers who haven’t placed an order are displayed
Create a function name BALANCE that returns the status of outstanding amount for each customer. Use the following criteria for your function: Outstanding_amt less than 5000 , returns ‘SMALL AMOUNT’ Outstanding_amt between 5000 and 10000 , returns ‘AVERAGE AMOUNT’ Outstanding_amt greater than 10000 , returns ‘LARGE AMOUNT’ Use function BALANCE in your SQL statements that display the cust_code, cust_name, Outstanding_amt and function BALANCE.
Write the difference between the characters' two data types in SQL Server: VARCHAR NVARCHAR
In The SQL Oracle Application Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.
In SQL Server, specify the differences between the two character data types as follows: NVARCHAR VARCHAR
The following statements are executed:create sequence my_seg; select my_seg.nextval from dual;select my_seg.nextval from dual;rollback; select my_seg.nextval from dual; What value will return when the last SQL statement is executed? Select one: a. 2b. 1c. 3d. 0e. NULL