ITPEC Textbook
Reading settings
Theme

Guest settings stay on this device. Sign in to sync reader settings.

Contents
Chapter 4 · DatabasePractice
← Return to textbook

CONCEPT PRACTICE

Original correlated EXISTS definition

1 related verified questions. Take them one at a time.

Filter questions
Question sources

1 of 1 questions match.

Textbook Exercises
0/1 answered

Question 1 of 1

0/1 answered

Volume 1 · Chapter 4 · Textbook Exercises · Q10

Original textbook exercise · Select the image to enlarge
Read the question as text

Which of the following is the appropriate SQL statement for extracting Product information (ProductNumber, ProductName) of the products where InventoryQuantity is less than 100 units from the “Product” table and the “Inventory” table? Product Inventory ProductNumber ProductName UnitPrice ProductNumber InventoryQuantity

The original image above preserves the complete textbook wording and layout.

Choose your answer
Choose an option to check your answer.
1 / 1Back to lesson →

Related questions

These questions share a verified concept. Each source keeps its own answers and progress.

Source: FE Vol 1.pdf, PDF page 296, textbook p. 286 · Information-technology Promotion Agency, Japan · First Edition: April, 2015. ID: tb-v1-c4-q10. Publisher answer and commentary · private review.

Original question · Q10
Which of the following is the appropriate SQL statement for extracting Product information (ProductNumber, ProductName) of the products where InventoryQuantity is less than 100 units from the “Product” table and the “Inventory” table? Product Inventory ProductNumber ProductName UnitPrice ProductNumber InventoryQuantity a) SELECT X.ProductNumber, ProductName FROM Product X, Inventory Y WHERE X.ProductNumber = Y.ProductNumber OR InventoryQuantity < 100 b) SELECT X.ProductNumber, ProductName FROM Product X, Inventory Y WHERE InventoryQuantity < 100 c) SELECT ProductNumber, ProductName FROM Product WHERE EXISTS (SELECT * FROM Inventory WHERE InventoryQuantity < 100) d) SELECT ProductNumber, ProductName FROM Product WHERE ProductNumber IN (SELECT ProductNumber FROM Inventory WHERE InventoryQuantity < 100)

Scroll horizontally to read the image at full size.

Figure

Open original ↗