You want a list of products whose product lines contain the


Question 1

You want a list of products whose product lines contain the term Classic or Vintage. please pick up best option from the following.

  • a. SELECT productline
  • FROM products
  • WHERE MATCH(productline) AGAINST('Classic', 'Vintage');
  • Selected:
  • b. SELECT productline
  • FROM products
  • WHERE productline = 'Classic' OR productline = 'Vintage';
  • This answer is incorrect.
  • c. SELECT productline
  • FROM products
  • WHERE productline = 'Classic' AND productline = 'Vintage';
  • d. SELECT productName, productline
  • FROM products
  • WHERE MATCH(productline) AGAINST('Classic', 'Vintage');

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: You want a list of products whose product lines contain the
Reference No:- TGS02924066

Now Priced at $10 (50% Discount)

Recommended (94%)

Rated (4.6/5)