This quiz will test your understanding about Extract & Analyze Data from Databases. Please answer the following 3 questions.
Quiz Summary
0 of 3 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 3 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 3
1. Question
What does the IN operator allows you to do in the WHERE clause?
CorrectIncorrect -
Question 2 of 3
2. Question
Consider this SQL command “SELECT OrderID, COUNT(CustomerID) as NCustomers
FROM Orders GROUP BY OrderID HAVING COUNT(CustomerID) >1 “. What does this SQL query returns?CorrectIncorrect -
Question 3 of 3
3. Question
Consider this SQL command “SELECT OrderID, CompanyName, ContactName, AVG(Freight) as AverageFreight FROM Orders JOIN Customers on CustomerID = CustomerID
group by OrderID, CompanyName, ContactName “. What does this SQL query returns?CorrectIncorrect