Which of the following queries will use a subquery to find all of the rows in the track table that has a unit_price of 0.99 and has the length of the song in milliseconds that is longer than the AVG track length of all tracks in the album_id between 5 and 10? SELECT * FROM TRACK WHERE milliseconds > O (SELECT AVG(milliseconds) FROM track WHERE unit_price = 0.99) AND album_id BETWEEN 5 AND 10; SELECT * FROM TRACK WHERE milliseconds > (SELECT AVG(milliseconds) FROM track WHERE album_id BETWEEN 5 AND 10) AND unit_price = 0.99;

Which of the following queries will use a subquery to find all of the rows in the track table that has a unit_price of 0.99 and has the length of the song in milliseconds that is longer than the AVG track length of all tracks in the album_id between 5 and 10? SELECT * FROM TRACK WHERE milliseconds > O (SELECT AVG(milliseconds) FROM track WHERE unit_price = 0.99) AND album_id BETWEEN 5 AND 10; SELECT * FROM TRACK WHERE milliseconds > (SELECT AVG(milliseconds) FROM track WHERE album_id BETWEEN 5 AND 10) AND unit_price = 0.99;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 1MC

See similar textbooks

Similar questions

Which of the following commands drops any columns marked as unused from the SECUSTOMERORDERS table? DROP COLUMN FROM secustomerorders WHERE column_status = UNUSED ALTER TABLE secustomerorders DROP UNUSED COLUMNS; ALTER TABLE secustomerorders DROP (unused); DROP UNUSED COLUMNS;
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 queries is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? SELECT ONLY V_CODE FROM PRODUCT; SELECT UNIQUE V_CODE FROM PRODUCT; SELECT DIFFERENT V_CODE FROM PRODUCT; SELECT DISTINCT V_CODE FROM PRODUCT;
Which of the following queries is used to list a unique value for Emp_name, where the list will produce only a list of those values that are different from one another? Select different emp_name from Employee; Select only emp_name from Employee; Select distinct emp_name from Employee; Select unique emp_name from Employee;
Which of the following queries correctly uses an alias for the MRENT field? a. SELECT * AS monthly rent FROM TENANTS b. SELECT ID, MRENT AS "monthly rent" FROM TENANTS c. SELECT * AS "monthly rent" FROM TENANTS d. SELECT MRENT, ID AS "monthly rent" FROM TENANTS
What’s the difference between a single-row subquery and a multiple-rowsubquery?
Which of the following displays the order date for order 1000 as 03/31? (refer to the tables in the JustLee Books database.)a. SELECT TO_CHAR(orderdate, 'MM/DD')FROM ordersWHERE order# ¼ 1000;b. SELECT TO_CHAR(orderdate, 'Mth/DD')FROM ordersWHERE order# ¼ 1000;c. SELECT TO_CHAR(orderdate, 'MONTH/YY')FROM ordersWHERE order# ¼ 1000;d. both a and be. none of the above
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 operators is used to find all values greater than the highest value returned by a subquery? (refer to the tables in the JustLee Books database.) a. >ALL b. < ALL c. >ANY d.< ANY e. IN
Which of the following queries is valid? (refer to the tables in the JustLee Books database.) a. SELECT b.title, b.retail, o.quantityFROM books b NATURAL JOIN orders odNATURAL JOIN orderitems oWHERE od.order# ¼ 1005; b. SELECT b.title, b.retail, o.quantityFROM books b, orders od, orderitems oWHERE orders.order# ¼ orderitems.order#AND orderitems.isbn ¼ books.isbnAND od.order# ¼ 1005; c. SELECT b.title, b.retail, o.quantityFROM books b, orderitems oWHERE o.isbn ¼ b.isbnAND o.order# ¼ 1005; d. none of the above
Which of the following queries creates a Cartesian join?(refer to the tables in the JustLee Books database.)a. SELECT title, authoridFROM books, bookauthor;b. SELECT title, nameFROM books CROSS JOIN publisher;c. SELECT title, giftFROM books NATURAL JOIN promotion;d. all of the above
Database Q1: Which one of the following INSERT statements will successfully insert a single row? The following table has been created: CREATE TABLE student_table ( stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ; a) INSERT VALUES INTO student_table (143354, ‘Roberts’, ‘Cameron’, 6543); b) INSERT INTO student_table COLMUNS (stud_id, last_name, lunch_num) VALUES (143352, ‘Roberts’, 5543, ‘Cameron’); c) INSERT TO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, ‘Cameron’, ‘Roberts’); d) INSERT INTO student_table VALUES (143354, ‘Roberts’, ‘Cameron’, 6543); Q2: What does the following SQL statement display: SELECT EMP_ID, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY > (SELECT MIN (E. SALARY) FROM EMPLOYEES E) ORDER BY SALARY DESC; a) Employees information who earn less money than the maximum salary b) Employees information who earn more money than the highest employee salary c) Employees information who earn…