MCQs
Total Questions : 7
Answer: Option B. -> Avg(salary)
Avg(salary)Avg() is used to find the mean of the values.
Answer: Option B. -> Count(*)
Count(*)* is used to select all values including null.
Answer: Option A. -> Collection of values
Collection of values
Answer: Option A. -> Distinct
DistinctDistinct keyword is used to select only unique items from the relation.
Answer: Option D. -> Unknown
UnknownUnknown values do not take null value but it is not known.
Answer: Option B. -> Not exists
Not existsExists is used to check for existence of tuples.
Answer: Option C. -> In, not in
In, not inIn checks if the query has the value but not in checks if it does not have the value.