Foxoyo
Hey..!!
Aggregate Functions DBMS
Practice
MCQs
Quizzes
About
Leaderboard
Amazon Books
5
MCQs
0
Attempts
0 %
Accuracy
share
Filter by
Type here
Apply
We can test for the nonexistence of tuples in a subquery by using the _____ construct
EXISTS
Not exist
Exist
NOT EXISTS
The ____ connective tests for set membership, where the set is a collection of values produced by a selectclause.
The ____ connective tests for the absence of set membership
In, not in
In, or
Or, in
Not in, in
Select __________ from instructor where dept name= ’Comp.
Sc
i.’;Which of the following should be used to find the mean of the salary
Mean(salary)
Count(salary)
Sum(salary)
Avg(salary)
Select count (____ ID)from teacheswhere semester = ’Spring’ and year = 2010;If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression
Count
Avg
Distinct
Primary key
Aggregate functions are functions that take a ___________ as input and return a single value
Aggregate value
Both A & B
Single value
Collection of values
1
take a quick Quiz
Practice mcqs on Aggregate Functions DBMS
Let's start
pick difficulty level
all
1
2
3
4
5
5
Mcqs
0
attempts
0
followers
Related Topics
Aggregate Functions DBMS
Functions
C Functions
Python Mapping Functions and Modules
CSS Properties Elements Functions Tables
Python Dictionary Functions and Built
R Programming R Control Structures Functions Scop
Membrane Structure and Functions
Library Functions
Functions and Subroutines
Suggested Books