Course Hero Logo

W07 quiz CIT 225.docx - W07 quiz CIT 225 1. Single column...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 2 pages.

W07 quiz CIT 2251.Single column grouping is the simplest and most often used type of grouping.a.Trueb.False
2.The COUNT() function creates an explicit group when it is the only thing returned in the SELECT-list.
3.The MIN() function returns the minimum value within a set.
4.Aggregation functions take only columns as arguments.
5.The following query uses the COUNT function to return the first letter of the last_name columnvalues from the customer table where the last_name column values that start with the letter ‘K’or ‘M’ in ascending last_name order.a.Trueb.False
6.The following query uses the COUNT function to return the first letter of the last_name columnvalues from the customer table where the last_name column values from the customer tablewhere the last_name column values that start with the letter ‘K’ or ‘M’ in ascending last_nameorder.
7.Which of the following creates an explicit group in a query? Multiple answers are possible.)
8.The following COUNT function calls always return the same value.
End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
N/A
Tags
Sociology, Tuple, Aggregate function

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture