Consider a table named products with columns product_id, product_name, and category. Write a SQL query that retrieves the product names for products in the 'Electronics' category whose names ending with the letter 'c' and having third letter as 'a'. Choose the correct option for the query:A. SELECT product_nameFROM productsWHERE category = 'Electronics'AND product_name LIKE '_ac%';B. SELECT product_nameFROM productsWHERE category = 'Electronics'AND product_name LIKE '_a_c%';C. SELECT product_nameFROM productsWHERE category = 'Electronics'AND product_name LIKE '_ _a%c';D. SELECT product_nameFROM productsWHERE category = 'Electronics'AND product_name LIKE '_a%c'

Which SQL query retrieves all rows where the 'name' column does not start with the letter 'A'?

With SQL, how do you select all the records from a table named "Persons" with the criteria that the column named "FirstName" is "Peter" and the column named "LastName" is "Jackson"?Select one:a.SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'b.SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'c.All of the answers are correctd.SELECT FirstName='Peter', LastName='Jackson' FROM Persons

You are given a table Employee which has the following columns :id, FirstName, LastName.You have to use a query to display all those employees whose first names start with the letter ‘R’ and end with the letter ‘I’. Some queries are given below -(a) SELECT * FROM Employee WHERE FirstName LIKE '%RI%';(b) SELECT * FROM Employee WHERE FirstName LIKE 'R%' AND FirstName LIKE '%I';(c) SELECT * FROM Employee WHERE FirstName LIKE 'R' AND 'I';(d) SELECT * FROM Employee WHERE FirstName LIKE 'R%I';Choose the most appropriate option from below :Options: Pick one correct answer from belowOnly (c)Only (b)(b) and (d)(b), (c) and (d)(a) and (c)None of the above

Consider the following table structure:Productidnamepricetype_idProduct_typeidnamediscountWhich of the following query is used to display the product_type name, product name and discount of product_type named 'Books'?

Which query will output the table contents when the value of the string field P_DESCRIPT include the word ‘hammer’?Select one:a.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT = ‘hammer’;b.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT = ‘%hammer%’;c.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT include ‘hammer’;d.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT like ‘%hammer%’;