Database Domain #3 Lesson 6 Quiz | American Baptist College - Edubirdie

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

171

Pages:

1
Author:

Muthia M.

Fillin the Blanks 1. The most _____ aggregate used in data calculations is SUM. [GROUP BY and SUM] Answer: COMMON 2. A query must be told how to _____ the data. [GROUP BY and SUM] Answer: GROUP 3. A _____ clause is used before grouping columns in an aggregate when filters are needed on data. [HAVING] Answer: HAVING 4. A HAVING clause filters _____ based on aggregates. [HAVING] Answer: DATA 5. The MIN aggregate returns the _____ number in a list of numbers per group of columns. [MIN and MAX] Answer: SMALLEST 6. To search for the highest sale within a list of sales, one would use the _____ aggregate. [MIN and MAX] Answer: MAX 7. The _____ aggregate shows the number of records for each item in a group. [COUNT and AVG] Answer: COUNT 8. The AVG aggregate gives an _____ of a group of numbers. [COUNT and AVG] Answer: AVERAGE

Related Documents

Database Domain #3 Lesson 6 Quiz

Database Domain #3 Lesson 6 Quiz - Page 1

of 1

Recommended Documents

Introduction to Microsoft Office

Introduction to Microsoft Office

American Baptist College BU 100L | Basic Computer Science

Lecture Note

Definition of Artificial Intelligence

Definition of Artificial Intelligence

American Baptist College BU 100L | Basic Computer Science

Lecture Note

Coding and Programming Spacial Computing

Coding and Programming Spacial Computing

American Baptist College BU 100L | Basic Computer Science

Lecture Note

Tokenization of Real World Assets

Tokenization of Real World Assets

American Baptist College CSCI 3621 | Networking

Lecture Note

Solana Ecosystem and Use Cases

Solana Ecosystem and Use Cases

American Baptist College CSCI 3621 | Networking

Lecture Note

Show more

New Documents from this Course

Database Domain #5 Lesson 1 Quiz

Database Domain #5 Lesson 1 Quiz

American Baptist College CIT370 | Database Design and Processing

Assignment

Database Domain #4 Lesson 1 Quiz

Database Domain #4 Lesson 1 Quiz

American Baptist College CIT370 | Database Design and Processing

Assignment

Database Domain #3 Lesson 5 Quiz

Database Domain #3 Lesson 5 Quiz

American Baptist College CIT370 | Database Design and Processing

Assignment

Flow Control with Iteration Test

Flow Control with Iteration Test

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #18

ITS Databases Practice Exam #18

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #9

ITS Databases Practice Exam #9

American Baptist College CIT370 | Database Design and Processing

Assignment

Show more