View Count: 0 Duration: 74 mins Accessed date: Not Yet Viewed
###### Post your comment / feedback here

 Sorry!For this module there is no Sample Code.
 Sorry!For this module there is no Assignments.
Question No: 1 of 20
`Does COUNT(*) include NULL values? `
Options:
1. Yes
2. No
a
Explanation:

Question No: 2 of 20
`Does AVG function consider NULL values? `
Options:
1. Yes
2. No
b
Explanation:

Question No: 3 of 20
`The functions COUNT(), MIN() and MAX() cannot take as input which of the following data type? `
Options:
1. int
2. char
3. decimal
4. date
c
Explanation:

Question No: 4 of 20
`Can grouping be done on multiple columns `
Options:
1. Yes
2. No
a
Explanation:

Question No: 5 of 20
`Which of the following statement is used to alias the column Empname as Employeename? `
Options:
1. Select Empname AS EmployeeName from Employee
2. Select Empname Employeename from Employee
3. Only a
4. Both a and b
d
Explanation:

Question No: 6 of 20
`Query to get all employees belonging to department 10 and 20 `
Options:
1. Select * from employee where deptid IS EQUAL TO 10 OR 20
2. Select * from employee where deptid =10 AND deptid=20
3. Select * from employee where deptid IN(10,20)
4. None
c
Explanation:
Select * from employee where deptid IN(10,20) Note: (Select * from employee where deptid =10 OR deptid=20) is also correct

Question No: 7 of 20
`Aggregate functions can return? `
Options:
1. only multiple values
2. only single value
3. either single value or multiple values
b
Explanation:

Question No: 8 of 20
`Which of the following is not a aggregate function `
Options:
1. Sum
2. With
3. Min
4. Avg
b
Explanation:

Question No: 9 of 20
`Aggregate functions can be used in the select list or the_______ clause of a select statement or subquery. They cannot be used in a______ clause. `
Options:
1. Where,Having
2. Having,Where
3. Groupby,Having
4. Groupby, where
b
Explanation:

Question No: 10 of 20
`Which of the following function is used for calculating aggregate value. `
Options:
1. Sum
2. Max
3. Average
4. Avg
d
Explanation:

1