Suppose you want to make a search more specific and exclude irrelevant records. Which of the following operators enable you to specify the location of your keywords in relation to one another? Question 24Select one:a.Truncation symbolsb.Boolean operatorsc.Wildcard symbolsd.Proximity operators

How can you use Boolean operators in your search?Question 1Answera.To perform mathematical calculationsb.To exclude all search resultsc.To customize search results by combining keywordsd.To create new keywordsClear my choice

What symbol will you use when you want to exclude certain words in your search?A. dash or minus sign B. quotation marks C. fewer words D. and/or

The Boolean search operator "OR" is often used with these terms:

Which of the following is the correct order of keywords for SQL SELECT statements?SELECT, FROM, WHEREFROM, WHERE, SELECTWHERE, FROM,SELECTSELECT,WHERE,FROM

1.Question 1True or False: AND, OR, NOT, IN, BETWEEN, and LIKE operators are all used to combine multiple filter conditions in the WHERE clause.1 pointTrueFalse2.Question 2What should be the correct WHERE clause condition to filter out customers who are not from any of these countries – USA, UK.1SELECT * FROM Customers WHERE ___________________________;1 pointWHERE Country NOT 'USA' OR Country NOT 'UK';WHERE NOT(Country = 'USA' OR Country = 'UK');3.Question 3If this query is written based on the Products table below, what would be the result?1SELECT quantity from Products WHERE quantity BETWEEN 2000 AND 8000;Table of Products1 point50002000, 5000, 8000 2000, 5000, 8000, 80004.Question 4What is the result of the following query when enacted on the Author table?123SELECT Author_name FROM Author WHERE Author_name LIKE '%an';1 pointS.B. Swaminathan, Thomas MorganEvan Hayek, S.B. Swaminathan, Thomas Morgan 5.Question 5True or False: There is no SELF JOIN clause in MySQL.1 pointTrueFalse6.Question 6A database contains two tables. An orders table (which is the left table), and the suppliers table (which is the right table).A JOIN is performed on the two tables. The output of this JOIN produces the following table of data:What type of JOIN has been performed here? 1 pointINNER JOINRIGHT JOINLEFT JOIN7.Question 7What JOIN keywords can be used to perform a SELF JOIN? Select all that apply.1 pointLEFT JOINRIGHT JOININNER JOIN8.Question 8How many tables do you need to create a SELF JOIN?1 pointOne tableTwo tables9.Question 9True or False: This SQL statement finds out the number of orders made by each customer.1SELECT COUNT(*) FROM Orders GROUP BY customerID;1 pointTrueFalse10.Question 10Select the missing SQL keyword to find the employees who have worked for more than 12 hours in total.1SELECT Emp_Name, SUM(Working_Hours) FROM Timesheet GROUP BY Emp_Name _________ SUM(Working_Hours) > 12;Timesheet table1 pointHAVINGGROUP