Write a sql statements to Display Account Number and Name column from Vendor table

$23.00

Category:

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