You have two tables named dbo.CurrentProducts and dbo.ArchiveProducts. You have the following query: SELECT ProductID, Name FROM dbo.CurrentProducts UNION ALL SELECT ProductID, Name FROM dbo.ArchiveProducts; You need to predict the list of products that the query will produce. Which list of products should the query return?Products that appear in dbo.CurrentProducts or dbo.ArchiveProducts.Products that appear in both tables are listed multiple times.Products that appear in dbo.CurrentProducts or dbo.ArchiveProducts but not in both.Products that appear in dbo.CurrentProducts or dbo.ArchiveProducts. Products that appear in both tables are listed only once.Products that have a matching ProductID and Name in dbo.CurrentProducts or dbo.ArchiveProducts.

Question 1You have a table that lists products. Because there are different editions, there are duplicate product names in the productName field. You need to create a list of all of the different product names. If there are different editions of the product, you only want to list one record for each product name. What query should you execute? 1 pointSELECT DISTINCT productName FROM productsSELECT UNIQUE productName FROM productsSELECT INDIVIDUAL productName FROM productsSELECT SEPARATE productName FROM products

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'?

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'

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

Problem StatementCreate a table named "products" with columns "product_id" (int), "product_name" (varchar), "description" (varchar), "unit_price" (decimal), and "available_stock" (int). Additionally, the table should have constraints such that "product_id" acts as the primary key and "product_name" is unique.The table structure is given below:Input format :No console input.Output format :The output should display a detailed description of the created 'products' table.Refer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.