aggregate functions

mcqspedia.com has 5 Question/Answers about Topic aggregate functions

Groups that do not satisfy having clause predicate are

Groups that do not satisfy having clause predicate are
  • A. Applied
  • B. Removed
  • C. Retrieved accordingly
  • D. Not retrieved
  • Correct Answer: Option B

SQL standard says that sum operator should ignore an input of

SQL standard says that sum operator should ignore an input of
  • A. 0s
  • B. 1s
  • C. Null value
  • D. strings
  • Correct Answer: Option C

Clause that apply aggregate functions to get a single result tuple for each group, is known to be

Clause that apply aggregate functions to get a single result tuple for each group, is known to be
  • A. Select clause
  • B. From clause
  • C. Where clause
  • D. Distinct clause
  • Correct Answer: Option A

If tuples are satisfying where predicate, then they are placed into groups by the

If tuples are satisfying where predicate, then they are placed into groups by the
  • A. Having clause
  • B. Group by clause
  • C. Like clause
  • D. Distinct clause
  • Correct Answer: Option B

To specify duplicate retention, we can use keyword in place of distinct, which is

To specify duplicate retention, we can use keyword in place of distinct, which is
  • A. Select distinct
  • B. Duplicate
  • C. Whole
  • D. All
  • Correct Answer: Option D