A _____ is a collection of values with no inherent order

Refer to the Product table. Which of the following would complete the SQL statement to select all products with sizes 0-3M, 3-6M, and 6-9M (Select all options that would work). SELECT ProductName, Quantity FROM Product WHERE Size _____ (‘0-3M’, ‘3-6M’, ‘6-9M’);

Refer to the Product table. Complete the SQL statement to select the two set…… ‘Cosmic Encounters Expansion Set’ and ‘Terraforming Mars Expansion Set’. ProductID Product Name Price Quantity 012 Cosmic Encounters Expansion Set 95.99 12 011 Terraforming Mars 69.95 6 143 Mousetrap 56.95 12 214 Terraforming Mars Expansion Set 95.99 18 421 Cosmic Encounters Basic 49.95 6 129 Azul 44.99 24 SELECT ProductName, Quantity FROM Product WHERE ProductName LIKE _____;

Which of the following is in SQL but is not a relational algebra operation?  

Complete the ORDER BY clause to sort the Products by ProductName alphabetically, then Quantity from the smallest to the largest. SELECT ProductName, Size, Quantity, SupplierId FROM Product ORDER BY _____ ;

Refer to the following tables: Employee ID Name Salary 4428 Amin Shah 42500 5993 Malia Tarkas 53000 Student ID Name Scholarship 1408 Indira 3000 5993 Malia Tarkas 7110 Jiho Chen 4500 How many rows are in the table defined by the following relational algebra expression?

Refer to the tables. Which products are returned by the query below? SELECT ProductName FROM Product P WHERE NOT EXISTS (SELECT * FROM Sales WHERE ProductID = P.ProductID);

Which relational algebra expression(s) is equivalent to the following SQL statement? SELECT PassengerName FROM Booking WHERE TicketPrice

Suppose relation R(A,B,C) has the following tuples:   A B C 1 2 3 4 2 3 4 5 6 2 5 3 1 2 6   and relation S(A,B,C) has the following tuples:   A B C 2 5 3 2 5 4 4 5 6 1 2 3   Compute (R – S) union (S – R), often called the “symmetric difference” of R and S. Which of the following tuples is in the result?

Breakdown of glucose in glycolysis first results in ________ molecules.