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#;

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#;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 6MC

See similar textbooks

Similar questions

Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;
Which of the following is not a valid SQL statement? CREATE TABLE anothernewtable (newtableid VARCHAR2 (2)); CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate, shipdate FROM orders); CREATE TABLE anothernewtable (firstdate, seconddate) AS (SELECT orderdate, shipdate FROM orders); All of the above are valid statements.
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
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
Which of the following SQL statements displays a customer’s name in all uppercase characters? (refer to the tables in the JustLee Books database.)a. SELECT UPPER('firstname', 'lastname')FROM customers;b. SELECT UPPER(firstname, lastname)FROM customers;c. SELECT UPPER(lastname, ',' firstname)FROM customers;d. none of the above
Which of the following SQL statements determines how many total customers were referred by other customers? (refer to the tables in the JustLee Books database.)a. SELECT customer#, SUM(referred)FROM customersGROUP BY customer#;b. SELECT COUNT(referred)FROM customers;c. SELECT COUNT(*)FROM customers;d. SELECT COUNT(*)FROM customersWHERE referred IS NULL;
In SQL Server, describe the distinction between the two data types for the characters as follows: NVARCHAR NVARCHAR NVARCHAR
Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statements
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
Which of the following SQL statements produces “Hello World” as the output? (refer to the tables in the JustLee Books database.)a. SELECT "Hello World" FROM dual;b. SELECT INITCAP('HELLO WORLD') FROM dual;c. SELECT LOWER('HELLO WORLD') FROM dual;d. both a and be. none of the above