CSE MCQs :: DBMS MCQs
- Aggregate functions are functions that take a ___________ as input and return a single value.
-
Select __________ from instructor where dept name= 'Comp. Sci.';Which of the following should be used to find the mean of the salary ?
- All aggregate functions except _____ ignore null values in their input collection.
-
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.
- The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.
- We can test for the nonexistence of tuples in a subquery by using the _____ construct.
Whatsapp
Facebook
