Consider the following statements: (1) For a, b. and m being integers with m≥2. if a=b (mod m), then 2a = (a+b) (mod m). (2) Let p, q, and r be propositions. p-> (q -> r) and p-> (q AND r) are logically equivalent. Select one of the following choices: O a. (1) is True and (2) is False O b. (1) is False and (2) is True ○ c. (1) and (2) are True d. (1) and (2) are False

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'

Which clause do you add to the following SELECT statement to limit the display to those categories that their total price is out of the range 5000 to 7000 (We also do not want to include 5000 and 7000 in the result)? SELECT catergoty_id, SUM(price) FROM products GROUP BY catergoty_id O a. HAVING SUM(price) 7000 O b. HAVING SUM(price) > 5000 and SUM(price) 7000 O d. WHERE SUM(price) > 5000 and SUM(price) < 7000

IN SQL If you omitted the WHERE clause of SELECT statement, the query returns an error because the where clause is required. Select one: True False