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

ou need to run a query that will count all of the records in the products table. The products table lists the productID, productName, and productDescription. The productID field is the primary key. There are no other constraints on any of the fields. What query or queries should you execute? (Choose all that apply.)1 pointSELECT count() * FROM productsSELECT count(DISTINCT productName) FROM productsSELECT count(productID) FROM productsSELECT count(*) FROM productsCoursera Honor Code  Learn more

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?Select one:a.SELECT DISTINCT V_CODEFROM PRODUCT;b.SELECT UNIQUE V_CODEFROM PRODUCT;c.SELECT DIFFERENT V_CODEFROM PRODUCT;d.SELECT ONLY V_CODEFROM PRODUCT;

In SQL, which command is used to SELECT only one copy of each set of duplicable rowsSELECT DISTINCTSELECT UNIQUESELECT DIFFERENTAll of the aboveReview AnswerNext

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.

The Employees table contains repeat entries in the JobTitle column, as many employees share the same job title.Which code snippet ensures that a query will list each job title once, independent of how many times it appears in the JobTitle column?SELECT JobTitle = 1SELECT UNIQUE JobTitleSELECT COUNT(JobTitle) = 1