Description
Question 15 pts
Write a sql statements to do the following:
Display Account Number and Name column from Vendor table. Return only Vendors that have Credit rating of 1 and Active Flag set to 1.
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 25 pts
Write a ql statements to do the following:
Display First Name, Last Name and Email Address columns from Contact table. Return only those contacts that have an Email promotion of 1 or 2
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 35 pts
Write SOL statements to do the following:
Return columns CustomerID, TerritoryID and AccountNumber from Customer table. Return only those customers that belong to Territories Northwest, Central, France and United Kingdom. Review the SalesTerritory table to get TerritoryID for each territory. In this SOL statement use the IN operator..
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 45 pts
Write sql statements to do the following:
Display the First Name, Middle Name and Last Name columns for everyone from the Contact table whose Last Name ends with “ms.” Also write code to make sure all Middle Names are returned in Upper case.
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 55 pts
Write SOL statements to do the following:
Display all columns for everyone in the Contact table whose First Name contains “ll”
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 65 pts
Write SOL statements to do the following:
Display Account Number and Name from the Vendor table whose Name begins with B or L
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 75 pts
Write SQL statements to do the following:
Display all columns for everyone whose Middle Name is NULL from the Contact table.
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 85 pts
Write SOL statements to do the following:
Display Name and Product Number columns from the Product table. Concatenate both columns to create a new column with alias name “ProductName”. Write code to make sure and remove any Right and Left spaces on both the Name and Product Number columns.
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 95 pts
Write SOL statements to do the following:
Return columns ProductID and OrderQty from the SalesOrderDetail. Also,
multiply the OrdeQty by the UnitPrice to create new column with alias name “TotalOrderCost”
HTML EditorKeyboard Shortcuts
Font SizesParagraph
p Flag this QuestionQuestion 105 pts
Write SOL statements to do the following:
Display Name, Product Number and List Price columns from Product Table. Return only those records where ListPrice not equal to 249.79
HTML EditorKeyboard Shortcuts
Font SizesParagraph
Question 14 pts What operator do you use to filter by more than one column?
WHERE
AND
SELECT
None of the above
Flag this Question Question 24 pts If you had two conditions in WHERE clause which operator should you use to match either condition?
HAVING
JOIN
OR
None of the above
Flag this Question Question 34 pts Of the three answers below, which operator ranks higher in order of evaluation?
OR
AND
None of the above
Flag this Question Question 44 pts A WHERE clause is used to filter data. With a WHERE you can also do what?
A WHERE clause inserts data
You can specify multiple WHERE clause
A WHERE clause creates tables
Flag this Question Question 54 pts Which of the following are true statements regarding the use of WILDCARDS
Dont overuse WILDCARDS
Search patterns that begin with WILDCARDS are the slowest to process
Be careful where you place WILDCARDS. Misplaced WILDCARDS might not return data you iintended.
All of the above.
Flag this Question Question 64 pts A search pattern is defined as “a search condition made up of literal text, wildcard characters or any combination of the above.”
True
False
Flag this Question Question 74 pts The LIKE operator is not an operator it is a predicate.
True
False
Flag this Question Question 84 pts Some database systems are configured as case-sensitive. In case-sensitive configurations, a search like %fish% will not match “FISH bean bag toy.”
True
False
Flag this Question Question 94 pts An Alias as an alternate name for a field
True
False
Flag this Question Question 104 pts Using a WILDCARD you can create search patterns that can be compared against your data.
True
False
