Question 1 You want a list of products whose product lines contain the term Classic or Vintage.

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');